Advanced Excel
As a professional in your field, you already know the benefits of using Microsoft Excel. There is a way to make it an even more powerful tool in the management of your business. Our Advanced Microsoft Excel training will give you a more efficient vision of your operation as well as improve your bottom line.
Total: 32 Hours
Duration: 2 months
Module 1: Using Formatting and Functions
- Applying Formatting to Numbers
- Creating Custom Number Formats
- Applying Conditional Formats
- Using Formulas in Conditional Formats
- Absolute and Relative References Naming a Range
- Using a Named Range in a Formula
- Using Lookup Functions
- IF Functions
Module 2: Using Templates and Workbooks
- Applying a Template
- Using a Template
- Creating a New Template
- Editing a Template
- Linking Between Workbooks
- Importing Data from Text Files
- Importing Data from Other Applications
- Importing an HTML Table
- Publishing Data to the Web
Module 3: Working with Data
- What is a List?
- Validating Data Entries
- Sorting Data
- Subtotaling and Outlining Data
- Extracting Data with Filters
- Using Advanced Filters
- Using Query
- Querying the Web
- Using XML to Share Data
Module 4: Analyzing Data
- Using PivotTable Add info about Slicers
- Managing PivotTable Reports
- Creating PivotChart Reports
- Using Charts and Trendlines
- Working with Scenarios
Module 5: Using Macros and Auditing Tools
- What is a Macro?
- Recording a Macro
- Running a Macro
- Editing a Macro
- Auditing Workbooks
- Tracing Errors
Module 6: Sharing Workbooks
- Creating a Shared Workbooks
- Consolidating Data
- Protecting Columns
- Protecting Worksheets
- Protecting Worksheet Content
- Protecting Cells
- Assigning a Password
- racking Changes
- Adding Comments
- Preparing a Workbook
Course Instructor
Pay With
All rights reserved PeopleNTech Software