Microsoft Excel Training
Microsoft Excel is the most popular spreadsheet program you will encounter. Used almost universally throughout business and the government, Excel handles everything from adding and subtracting to manipulating large sets of data and so much more. So vast is its feature list that even experienced users often find there is still much to learn. It’s a very sandbox-like environment where you can do almost anything and the more features you know about, the more options you have.
​
Often, the biggest hurdle is thinking creatively enough to determine how various features can be combined to solve a problem. That is why we believe it is vital for Excel training to teach you to apply what you are learning in the real world.
Our Microsoft Excel courses will help you:
-
Work faster and more accurately by getting Excel to do your calculations for you
-
Make your reports more useful by converting plain-looking data into visually striking charts
-
Find what you are looking for in large sets of data through sorting, filtering and other features
-
Get Excel to retrieve appropriate data or make decisions for you using advanced functions
-
Roll up multi-dimensional data into useful 2-dimensional reports through Pivot Tables
-
...and more
Getting Started with Microsoft Excel
Course Objectives:
By gaining a solid understanding of spreadsheet concepts, participants will increase their productivity. This workshop introduces the methods of data entry, formatting, using basic formulas, printing, and being comfortable with the terminology in Excel.
Unit 1: Getting Started with Microsoft Excel
✓ Navigate the Excel User Interface
✓ Use Excel Commands
✓ Create and Save a Basic Workbook
✓ Enter Cell Data
✓ Use Excel Help
Unit 2: Performing Calculations
✓ Create Worksheet Formulas
✓ Insert Functions
✓ Reuse Formulas and Functions
Unit 3: Modifying a Worksheet
✓ Insert, Delete, and Adjust Cells, Columns, and Rows
✓ Search for and Replace Data
✓ Use Proofing and Research Tools
Unit 4: Formatting a Worksheet
✓ Apply Text and Number Formats
✓ Align Cell Contents
✓ Apply Styles and Themes
✓ Apply Basic Conditional Formatting
✓ Create and Use Templates
Unit 5: Printing Workbooks
✓ Preview and Print a Workbook
✓ Set Up the Page Layout
✓ Configure Headers and Footers
Unit 6: Managing Workbooks
✓ Manage Worksheets
✓ Manage Workbook and Worksheet Views
✓ Manage Workbook Properties
Microsoft Excel Level 2
Course Objectives:
This one-day hands-on workshop will help participants become efficient in the intermediate level use of Microsoft Excel.
By gaining a solid understanding of spreadsheet concepts, participants will increase their productivity. This workshop introduces the methods of data entry, formatting, using advanced formulas, analyzing data, and pivot charts.
​
Recommended Prior Learning:
Completion of the Getting Started with Microsoft Excel workshop or equivalent knowledge.
Unit 1: Calculating Data with Advanced Formulas
✓ Apply Cell and Range Names
✓ Calculate Data Across Worksheets
✓ Use Specialized Functions and Array formulas
Unit 2: Analyzing Data with Functions and Conditional Formatting
✓ Using text and logical functions
✓ Use Specialized Functions
✓ Work with Logical Functions
✓ Work with Date & Time Functions
✓ Apply intermediate and advanced conditional formatting
Unit 3: Organizing Worksheet and Table Data
✓ Create and Modify Tables
✓ Format Tables
✓ Sort or Filter Data
✓ Use Subtotal and Database Functions to Calculate Data
Unit 4: Presenting Data Using Charts
✓ Create a Chart
✓ Modify Charts
✓ Format Charts
✓ Use Advanced Chart Features
Unit 5: Analyzing Data Using PivotTables, Slicers, and PivotCharts
✓ Create a PivotTable
✓ Analyze PivotTable data
✓ Filter Data Using Slicers
✓ Analyze Data Using PivotCharts
Extras:
​
✓ Financial Functions
✓ Working with Graphical Objects
✓ Using Array Formulas
Microsoft Excel Level 3
Course Objectives:
Upon completion of this one day hands-on workshop, participants will be able to enhance productivity and efficiency by streamlining workflow, collaborate/share with other workbook users, audit worksheets, analyze data, work with multiple workbooks, import and export data and use macros.
​
​
Recommended Prior Learning:
Completion of the Microsoft Excel Level 2 workshop or equivalent knowledge.
Unit 1: Working with Multiple Workbooks
✓ Consolidate Data
✓ Link Cells in Different Workbooks
✓ Use Links and External 3-D References
Unit 2: Applying Conditional Logic
✓ Use Lookup Functions
✓ Combine Functions
✓ Use Formulas and Functions to Apply Formatting
Unit 3: Auditing Worksheets
✓ Add Data Validation Criteria
✓ Trace Cells
✓ Search for Invalid Data and Formulas with Errors
✓ Watch and Evaluate Formulas
Unit 4: Collaborating with Other Users
✓ Protect Files
✓ Share a Workbook
✓ Track Revisions
✓ Merge Workbooks
✓ Restrict Document Access
Unit 5: Automating Workbook Functionality
✓ Update Workbook Properties
✓ Create a Macro
✓ Edit a Macro
✓ Apply Conditional Formatting
Unit 6: Forecasting Data
​
✓ Create Trendlines
✓ Create Sparklines
✓ Create Scenarios
✓ Perform a What-If Analysis
✓ Perform a Statistical Analysis with the Analysis Tool Pak