Microsoft Excel 2013 / 2010: Level 3
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
- Creating, Maintaining, Filtering and using Subtotals in a List
- Recording, Assigning and Using Macros
- Creating and Using User Defined Functions
- Performing “What If” Analyses
- Working with Scenarios
- Querying a Database
- Importing and Exporting Files and Data
- Protecting Data
- Pivot Tables, Reports and Charts
- Other Advanced Business Analysis Tools
Prerequisites
- Microsoft Excel 2013 / 2010 Level 2 or equivalent experience
Outline
- Working with Lists
- Creating a List
- Maintaining a List
- Editing Records Using the Data Form
- Filtering a List
- Using Subtotals in a List
- Working with Macros and User Defined Functions
- Recording and Using Macros
- Assigning Macros
- Using User Defined Functions
- Using Basic Analysis Tools
- Performing “What If” Analyses
- Working with Scenarios
- Using Advanced Analysis Tools and External Data
- Querying a Database
- Importing and Exporting Files
- Protecting Data
- Using Data Validation
- Using Worksheet Protection
- Password Protecting a Workbook
- Using Business Analysis Tools
- Working with Pivot Tables and Pivot Charts
- Identifying the Parts of a Basic Pivot Table
- Pivot Table Reports
- Create a PivotTable from worksheet data
- Create a PivotTable from an external data source
- Create a PivotChart report from an existing PivotTable report
- Delete a PivotTable or PivotChart report
- Slicers
- Using slicers
- Formatting slicers for a consistent look
- Sharing slicers between PivotTables
- Sparklines
- Types of Sparklines
- Create a sparkline
- Customize sparklines
- Control which value points are shown
- Change the style of or format sparklines
- Online Analytical Processing (OLAP)
- Business intelligence
- What is Online Analytical Processing (OLAP)?
- OLAP features in Excel 2013 / 2010