Microsoft Excel 2013 / 2010: Level 2
This course takes users to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts.
With our extensive knowledge of the different software currently on the market, including all Microsoft and Adobe applications, ON-TRACK Corporate Training Ltd. has a diverse and flexible schedule that can be customized to your needs – we offer group course (both public and corporate), one-on-one training, and on-site training options. We also have easily accessible on-line training videos available.
Duration: 1 Day
Objectives
- Using multiple worksheets, workbooks and workspaces
- Working with Financial functions
- Use advanced formatting techniques
- Using the Auditing Tools to track information
- Using charts to display financial data
- Using Macros to automate your work environment
- Use Templates
Prerequisites
- Microsoft Excel 2013 / 2010 Level 1 or equivalent experience
Outline
- Using Multiple Worksheets and Workbooks
- Using Multiple Worksheets
- Inserting New Worksheets
- Renaming Worksheets
- Deleting Worksheets
- Creating Multiple Views
- Freezing Panes
- Viewing and Arranging Multiple Worksheet Windows
- Navigating in Multiple Workbooks
- Selecting and Viewing Multiple Workbooks
- Creating and Opening a Workspace
- Managing Multiple Worksheets and Workbooks
- Selecting Multiple Worksheets
- Moving and Copying Data between Worksheets
- Linking Data Between Worksheets
- Creating a 3-D Formula
- Charting
- Using Charts
- Creating a Chart
- Changing Chart Type, Style and Chart Sub-Type
- Changes to the Chart Source Data
- Add data to an existing chart
- Change the data in an existing chart
- Remove data from a chart
- Managing Chart Objects
- Moving and Resizing Chart Objects
- Deleting Chart Objects
- Adding Data Series and Objects to a Chart
- Changing the Chart Type
- Formatting Chart Objects
- Printing Charts
- Advanced Functions
- Creating and Using Functions
- Using Built-in Functions
- Working with Arguments: The PMT Function
- Using Dates and Times
- Using Dates in Calculations
- Using Nested Functions
- Auditing Worksheets
- Identifying the Auditing Commands
- The Watch Window
- The Formula Evaluator
- Tracing and Correcting Worksheet Errors
- Advanced Formatting
- Using Comments in a Worksheet
- Reviewing, Showing, and Hiding Comments
- Deleting a Comment
- Working with Styles
- Applying a Style
- Modifying Existing Styles
- Using Format Painter
- Creating Custom Number Formats
- Applying an AutoFormat (Table Format)
- Conditional Formats
- Clear conditional formats