Microsoft Excel Level 3
This course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel® 2007, 2010, 2013, or 2016 and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
Lesson 1: Streamlining Workflow
- Create a Macro
- Edit a Macro
- Apply Conditional Formatting
- Ali Data Validation Criteria
- Update a Workbook's Properties
- Modify Excel's Default Settings
Lesson 2: Collaborating with Others
- Protect Files
- Share a Workbook
- Set Revision Tracking
- Review Tracked Revisions
- Merge Workbooks
- Administer Digital Signatures
- Restrict Document Access
Lesson 3: Auditing Worksheets
- Trace Cells
- Troubleshoot Errors in Formulas
- Troubleshoot Invalid Data and Formulas
- Watch and Evaluate Formulas
- Create a Data List Outline
Lesson 4: Analyzing Data
- Create a Trenuline
- Create Scenarios
- Perform What-If Analysis
- Perform Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
- Create a Workspace
- Consolidate Data
- Link Cells in Different Workbooks
- Edit Links
Lesson 6: Importing and Exporting Data
- Export Excel Data
- Import a Delimited Text File
Lesson 7: Using Excel with the Web
- Publish a Worksheet to the Web
- Import Data from the Web
- Create a Web Query
Microsoft Excel - Expert
The class will teach you how to create Marco's, conditional formatting, securing your workbooks, expert functions, auditing worksheets, analyzing data, and importing, exporting data.
Includes essential topics from level 3
