The Microsoft Excel 2010 Level 2 training is a one-day course that equips students in analyzing alternative data sets, creating dynamic worksheets by using PivotTables, creating charts and graphics, automating repetitive tasks, working with other Microsoft Office programs, and collaborating on workbooks.
Completion of the course equips the participants with the following skill set:
Module 1: Analyse Alternative Data Sets
Lab: Defining an Alternative Data Set
Lab: Defining Multiple Alternative Data Sets
Lab: Varying Your Data to Get a Desired Result by Using Goal Seek
Lab: Finding Optimal Solutions by Using Solver
Lab: Analysing Data by Using Descriptive Statistics
Module 2: Create Dynamic Worksheets by Using PivotTables
Lab: Analysing Data Dynamically by Using PivotTables
Lab: Filtering, Showing, and Hiding PivotTable Data
Lab: Editing PivotTables
Lab: Formatting PivotTables
Lab: Creating PivotTables from External Data
Module 3: Create Charts and Graphics
Lab: Creating Charts
Lab: Customizing the Appearance of Charts
Lab: Finding Trends in Your Data
Lab: Summarizing Your Data by Using Sparklines
Lab: Creating Dynamic Charts by Using PivotCharts
Lab: Creating Diagrams by Using SmartArt
Lab: Creating Shapes and Mathematical Equations
Module 4: Automate Repetitive Tasks by Using Macros
Lab: Enabling and Examining Macros
Lab: Creating and Modifying Macros
Lab: Running Macros When a Button Is Clicked
Lab: Running Macros When a Workbook Is Opened
Module 5: Work with Other Microsoft Office Programs
Lab: Including Office Documents in Workbooks
Lab: Storing Workbooks as Parts of Other Office Documents
Lab: Creating Hyperlinks
Lab: Pasting Charts into Other Documents
Module 6: Collaborate with Colleagues
Lab: Sharing Workbooks
Lab: Managing Comments
Lab: Tracking and Managing Colleagues' Changes
Lab: Protecting Workbooks and Worksheets
Lab: Authenticating Workbooks
Lab: Saving Workbooks for the Web
This course is beneficial for information workers who want to learn advanced-level Excel 2010 skills.
Before attending this course, candidates must have:
Name | Code | Fee |
---|
OR