Excel – Standard – Half Day

$ 140.00

Class Duration: 3 Hours

Class Agenda

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: Excel Essentials & Formulas and Functions

  • Be able to Navigate Excel and create spreadsheets
  • Be able to use excel’s basic functions (sum, max, min, avg)
  • Select cells and sheets using keyboard shortcuts
  • Introduction to the Excel Interface
  • Search & Help
  • Smart Lookup
  • Zooming
  • Navigating and Selecting Cells
  • Keyboard Shortcuts
  • Deleting/Replacing Cell Data
  • Performing Simple Calculations
  • Saving the Workbook File
  • Overview of The Formulas Ribbon
  • Building Basic Formulas
  • Using Simple Functions
  • Formulas/Functions with the Autofill Command
  • Relative and Absolute Cell References

Module 2: Formatting, Spreadsheet Design, Page Setup & Printing

  • Be able to edit a spreadsheet by adding columns and rows
  • Creating reusable fonts, and formats in workbooks by saving them as templates
  • Adjust settings for workbook so its suitable for printing? using print options in Excel
  • Inserting Rows & Columns
  • Moving, Copying and Pasting Data
  • Using Autofill to Complete A Series of Values
  • Formatting Worksheet Data/Using Cell Styles
  • Introduction to Worksheet Themes
  • Creating Custom Templates
  • Managing Worksheets: Inserting, Deleting, Renaming, Move/Copy
  • Grouping Worksheets
  • Freezing or Splitting Panes
  • Grouping and Hiding Rows/Columns
  • Creating Custom Views
  • Spell Checking Your Worksheets
  • Setting Print Options
  • Using the Page Layout View
  • Printing Your Worksheet

Module 3: List/Table Essentials & Charting

  • Create tables to help make analyzing large data sets easier with table tools
  • Using Filters and Sorting tools on a data sets show the data you are looking for
  • Create and save visuals and charts for data sets
  • What is a well-defined list?
  • Inserting Tables 
  • Flash fill
  • Multi-Level Sorting
  • Removing Duplicates
  • Filtering Records
  • Using Slicers to filter
  • Automatic Subtotals
  • The Quick Analysis Tools
  • Inserting Data Charts
  • Recommended Charts
  • Editing Chart Elements
  • Adding/Removing Data From A Chart
  • Creating Custom Chart Templates
  • Printing Charts
  • Inserting Sparkline

Module 4: Pivot Tables, Protecting & Linking Data

  • Find discoveries within data sources using PivotTables
  • Create Pivot Charts out of PivotTables for visual representations of reports.
  • Protect and lock worksheets and workbooks to restrict users.
  • Creating Pivot Tables From Lists Or Tables
  • Office 365 Pivot Table Enhancements
  • Filtering Pivot Tables
  • Multi-Select Slicers
  • Working With Pivot Charts
  • Data Validation Rules
  • Applying Built In Conditional Formatting
  • Creating Custom Conditional Formats
  • Comments
  • Linking Data
  • Cell, Sheet, And File Protection

Module 5: Advanced Functions

  • Use Database Functions: XLOOKUP(), SUMIF(), and AVERAGEIF()
  • Fix errors using auditing, or handle inevitable errors with backup values
  • Apply data cleanup and isolation/consolidation techniques.
  • Creating and Applying Names In A Worksheet
  • VLOOKUP Function
  • XLOOKUP Function
  • ROUND function
  • Using the Formula Auditing Tools
  • Using the IF Function and Nesting Functions
  • Using the IFERROR Function
  • Summary Based Functions: SUMIF(S), COUNTIF(S), AVERAGEIF(S)
  • Text Functions: LEFT, RIGHT & MID
  • CONCAT function and Text-To-Columns Feature

Module 6: Data Auditing and problem Solving

  • Find optimal values for a single cell or a set of inter-related cells. 
  • Create and run basic macros to automate repetitive tasks.
  • Add macros to the Excel ribbon
  • Using the Data Consolidation Tool 
  • Using the Goal Seek Tool
  • Using the Solver Tool
  • Using the Scenario Manager
  • Recording and Running Macros
  • Understanding the Macro/VBA Developer Interface
  • Editing Macros with the Visual Basic Editor
  • Adding Buttons to Run Macros From the Ribbon
“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