Excel – Supported – Half Day

$ 240.00

Module Duration: 3.5 Hours

Class Agenda

Resource Setup 30 Minutes
Training Session 3 Hours
Breaks Prescribed by Instructor

The ability to work with and analyze data is critical to the success of your organization. For decades, Microsoft Excel has been the go-to application for doing so. With our Excel courses, you will learn to navigate the application confidently while creating and developing worksheets and workbooks that employ the most popular features Excel has to offer. Continuing on, learn to control data – a skill that is a significant benefit to your organization. You will learn to analyze massive amounts of data, extract information from it, and present the information clearly using more advanced features. Finally, explore the most advanced features to work in collaboration with others to deliver actionable organizational intelligence while keeping and maintaining workbooks for multiple purposes with efficiency in mind.

Module 1: Introduction to Spreadsheets and Basic Formulas

  • Navigate the Excel user interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help
  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas and Functions
  • Insert, Delete and Adjust Cells, Columns Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools

Module 2: Introduction to Spreadsheet Appearance and Organization

  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates
  • Preview and Print a Workbook
  • Set Up the Page Layout
  • Configure Headers and Footers
  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties

Module 3: Intermediate Formulas and Basic Data Lists

  • Work with Ranges
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date and Time Functions
  • Work with Text Functions
  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data

Module 4: Intermediate Data Structure and Visualization

  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting
  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features
  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Timelines and Slicers

Module 5: Workbook Consolidation and Collaboration

  • Use Links and External References
  • Use 3-D References
  • Consolidate Data
  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks
  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros

Module 6: Data Auditing and problem Solving

  • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas
  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Using the Goal Seek Feature
  • Forecasting Data Trends
  • Create Sparklines
  • Map Data
“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

Event Details

Phone: (602)252-3955

Email: registration@trainingtoyou.com

Scroll to Top