Classroom Instructor Led Microsoft Excel Training 817-841-9560 excel@dfwexcel.com

Public Excel Classes

Our Public Excel Classes are held across the Dallas Fort Worth Metroplex and are open to everyone. We provide you everything you need for the class, so all you need to do is dress comfortably and show up. In each class we will provide you with a full size training computer, Excel training file, Excel training binder, and a laminated Excel shortcut guide. We also offer all of our classes in a live online format for those that need the convenience of a live online training format. Need CPE credits? All of our Excel training classes provide CPE credits.

Public Classes Schedule

DateClassLocationPriceRegistration
December 4, 2020
9:00 AM to 5:00 PM
Excel Introduction Live Online$395.00 Class is Full. Waiting List
December 9, 2020
9:00 AM to 5:00 PM
Excel Intermediate Part 1 Live Online$395.00 Class is Full. Waiting List
December 18, 2020
9:00 AM to 5:00 PM
Excel Intermediate Part 2 Live Online$395.00 Class is Full. Waiting List

Need to Pay via an Invoice?

No problem. If you need to pay with an invoice, please use our contact form and let us know what class you would like to attend and we will email you an invoice you can pay via your Accounts Payable department.

Level 1: Excel Introduction

Overview

This course is ideal for complete novices, those who have basic knowledge of Excel or are self-taught. The course will provide you with the skills you need to work quickly and produce functional and well formatted spreadsheets. This course is often used to benchmark Microsoft Excel skills and ensure a level of understanding for new hires at companies. Students will leave feeling confident about creating professional worksheets with the software and be able to navigate the interface intuitively and productively.

Price

$395 per Student

CPE Credits

8 CPE Credits

Prerequisites

Participants must have basic keyboard and mouse skills and be familiar with the Windows operating system.

Duration

1 Day

Class Outline
Getting Started with Excel
  • Working with the Excel Environment
  • Title Bar
  • Ribbon and Ribbon Tabs
  • Quick Access Toolbar
  • Worksheet Views
  • Backstage View
Creating and Opening Workbooks
  • Create New Workbook
  • Open Existing Workbook
  • Pin a Workbook
  • Using Templates
  • Compatibility Mode
Saving and Sharing Workbooks
  • Save and Save As
  • Auto Recovery
  • Exporting Workbooks
  • Sharing Workbooks
Cell Basics
  • Understanding Cells
  • Select a Cell
  • Select a Cell Range
  • Inserting Cell Content
  • Deleting Cell Content
  • Cutting & Pasting Cell Content
  • Drag and Drop Cells
  • Completing Series with Fill Handle
Modifying Columns, Rows, and Cells
  • Changing Column Width
  • Changing Row Height
  • Inserting & Deleting Columns and Rows
  • Hiding & Showing Columns and Rows
  • Wrapping Cell Text
  • Merging Cells
Formatting Cells
  • Font Type, Size, Color, and Decorations
  • Cell Borders and Fill Colors
  • Cell Alignment and Styles
Cell Formats
  • Number Formats
  • Percentage Formats
  • Date Formats
Working with Multiple Worksheets
  • Inserting Worksheets
  • Copying Worksheets
  • Deleting Worksheets
  • Moving Worksheets
  • Renaming Worksheets
  • Changing Worksheet Tab Colors
  • Grouping and Ungrouping Worksheets
Using Find and Replace
  • Finding Text
  • Replacing Text
Page Layout and Printing
  • Print Pane
  • Print Area
  • Page Orientation
  • Page Breaks
Intro to Formulas
  • Formulas Overview
  • Mathematical Operators
  • Cell References
  • Creating Formulas
  • Copying Formulas
Creating More Complex Formulas
  • Order of Operations
  • PEMDAS
Relative and Absolute Cell References
  • Relative References
  • Absolute References
  • Cell References Across Worksheets
Functions
  • Functions Overview
  • Parts of a Function
  • Function Arguments
  • Using Functions
  • Function Library
IF Function
  • IF Function Overview
  • IF Function Arguments
  • Using the IF Function
VLOOKUP Function
  • VLOOKUP Function Overview
  • VLOOKUP Function Arguments
  • Using the VLOOKUP Function
Charts
  • Charts Overview
  • Chart Components
  • Chart Layout and Styles

Level 2: Excel Intermediate Part 1

Overview

Our Excel Intermediate Classes are our most popular classes. The class is broken down into a Part 1 focused heavily on data management, formulas, and functions, and a Part 2 that is focused on the presentation of the data of through a variety of tools including PivotTables, Advanced Charts, and Conditional Formatting. This class is typically ideal for someone that has taken the Excel Introduction class or someone that has used Excel for a long-time without any formal training. Students who have used Excel for years are quite often surprised after taking this class on how much Excel they did not actually know and/or how there are much more efficient ways to accomplish their business tasks in Excel. After taking this class, we highly recommend you take the second part of this class which is Excel Intermediate Part 2.

Price

$395 per Student

CPE Credits

8 CPE Credits

Prerequisites

Participants must have basic knowledge of entering data, formatting and simple formulas. Participants should be familiar with the topics covered in the Excel Introduction class.

Duration

1 Day

Class Outline
Tables
  • Tables Overview
  • Table Structured Cell References
  • Table Styles
  • Table Options
  • Table Slicers
  • Converting Tables to Ranges
  • Removing Duplicate Rows
Range Names
  • Range Names Overview
  • Navigating Range Names
  • Creating Range Names
  • Creating Range Names in Bulk
  • Assigning Range Names
  • Using Range Names in Formulas
  • Managing Range Names
Functions Overview
  • Functions Overview
  • Functions vs Formulas
  • Why use Functions?
Date and Time Functions
  • NOW Function
  • TODAY Function
  • YEAR Function
  • MONTH Function
  • DATE Function
  • DAYS Function
Statistical Functions
  • SUM Function
  • AVERAGE Function
  • MIN Function
  • MAX Function
  • MEDIAN Function
  • COUNT Function
  • COUNTA Function
  • COUNTBLANK Function
Text Functions
  • CONCAT Function
  • PROPER Function
  • UPPER Function
  • LOWER Function
  • LEFT Function
  • RIGHT Function
  • MID Function
  • TRIM Function
  • LEN Function
  • FIND Function
  • SUBSTITUTE
Logical Functions
  • IF Function
  • IFS Function
  • Nested IFs Function
  • AND Function
  • OR Function
  • COUNTIF Function
  • COUNTIFS Function
  • SUMIF Function
  • SUMIFS Function
  • AVERAGEIF Function
  • AVERAGEIFS Function
Lookup Functions
  • VLOOKUP Function
  • HLOOKUP Function
  • INDEX Function
  • MATCH Function
Flash Fill
  • Using Flash Fill
  • Troubleshooting Flash Fill
  • Limitations of Flash Fill

    Level 2: Excel Intermediate Part 2

    Overview

    This is second part of our two Excel Intermediate classes, and it is focused on presenting and analyzing data using PivotTables. We cover PivotTables from the ground up teaching all the fundamental concepts. Then we go into more advanced topics like PivotTable calculations, PivotCharts, and integrating PivotTables and PivotCharts into robust dashboards.

    Price

    $395 per Student

    CPE Credits

    8 CPE Credits

    Prerequisites

    For the best results, participants should be familiar with the topics covered in the Excel Introduction and Excel Intermediate Part 1 classes.

    Duration

    1 Day

    Class Outline
    PivotTable Fundamentals
    • Preparing the Data
    • Anatomy of a PivotTable
    • Slicing and Dicing with a PivotTable
    • Grouping Data
    • Sorting Data
    • Custom PivotTable Field Names
    • PivotTable Slicers
    • PivotCache
    • Refreshing Data
    PivotTable Calculations
    • Customize Subtotals
    • Showing Values as Calcuations
    • Calculated Fields
    • Calculated Items
    PivotCharts
    • Creating a PivotChart
    • PivotChart Control Buttons
    • PivotChart and PivotTable Filters
    PivotChart with Slicers Dashboards
    • Example Dashboards
    • Key Components of Dashboard
    • Basic Steps to Create Dashboard
    • PivotTable Cache
    PivotChart with Slicers Dashboards Integrating Everything Together
    • Creating Dashboards
    • Creating Dashboards with Multiple Sheets
    • Utilizing Hyperlinks for Navigation
    • Utilizing Icons for Navigation
    • Drilling into Details of Dashboard Charts

    Level 2: Excel Intermediate Part 3

    Overview

    This is third part of our three Excel Intermediate classes, and it is focused on data validation, conditional formatting, advanced charts, form controls, optimization with Solver and Goal Seek, and recorded Macros. You will learn the following:

     

    • How to control what users enter with Data Validation
    • How to dynamically change formatting based on the values of the data using Conditional Formatting
    • How to enrich the user experience by putting website like controls like scroll bars using Form Controls
    • How to optimize problems using Solver and Goal Seek
    • How to record Macros and execute recorded Macros
    Price

    $395 per Student

    CPE Credits

    8 CPE Credits

    Prerequisites

    For the best results, participants should be familiar with the topics covered in the Excel Introduction, Excel Intermediate Part 1, and Excel Intermediate Part 2 classes.

    Duration

    1 Day

    Class Outline
    Data Validation
    • Understanding Data Validation
    • Data Validation Rule Setting
    • Data Validation Tool Tips
    • Data Validation Custom Error Messages
    Conditional Formatting
    • Understanding Conditional Formatting
    • Highlight Cell Rules
    • Top/Bottom Rules
    • Data Bars
    • Color Scales
    • Icon Sets
    • Custom Rules
    • Advanced Rules based on Formulas
    • Creating a Schedule (Gantt Chart) using Conditional Formatting
    Advanced Charts
    • Waterfall Chart
    • Histogram Chart
    • Pareto Chart
    • Treemap Chart
    • Geography Filled Maps
    • 3D Geography Maps
    • Sparkline Cell Chart
    Form Controls
    • List Box
    • Spin Button
    • Check Box
    • Option Button
    • Scroll Bar
    • Radio Button
    Optimization & What If Analysis
    • Solver Overview
    • Framing the Problem
    • Setting Objective
    • Setting Constraints
    • Understanding Results
    • Goal Seek
    Recorded Macros
    • Macros Overview
    • Recording a Macro
    • Executing a Macro
    • Modifying a Macro
    • Running Macro from Button

    Level 3: Excel Power Query (Get & Transform)

    Overview

    Power Query is a data connection technology that comes with Excel that enables you to discover, connect, combine, and refine data sources to meet your analysis needs. Features in Power Query are available in Excel and Power BI Desktop. With Power Query you can search for data sources, make connections, and then shape that data (for example remove a column, change a data type, or merge tables) in ways that meet your needs. Once you’ve shaped your data, you can share your findings or use your query to create reports. This class is designed to teach Power Query from the ground up and assumes you have not used Power Query in the past. Once we have covered the foundational topics of Power Query, then we will move on to the Power Query M language (code) that is used to create queries in Power Query.

    Price

    $395 per Student

    CPE Credits

    8 CPE Credits

    Who this course is for
    • New to Power Query or never been formally trained in Power Query
    • Users who utilize often the VLOOKUP and INDEX/MATCH Functions
    • People performing Data Analytics in Excel, Power Pivot, Power BI, Tableau, Python, R
    • Business Intelligence Specialists using Excel, Tableau, Power Pivot, Power BI, Python, R
    • Data Analysts / Financial Analysts using Excel, Tableau, Power Pivot, Power BI, Python, R
    • If you or your team needs to fetch data from different sources and transform it so that it can be used in Excel for further analysis, then this course will help you master Power Query features from scratch
    • IT specialists who performs Extract Transform & Load (ETL) activities for business
    Duration

    1 Day

    Class Outline
    Power Suite Overview
    • What is Power Pivot, Power Query, Power View and Power Map
    • The Power Suite Workflow
    • Power Query Examples
    • Power Pivot Examples
    • Power View Examples
    Data Loading Options
    • Common Usage Patterns
    • Load to a Table
    • Load to a Pivot Table
    • Load to a Pivot Chart
    • Only Create Connection
    • Add to the Data Model
    Standard Transformations
    • Basic Data Transformations
    • Text Data Transformations
    • Number Data Transformations
    • Date Data Transformations
    Advanced Transformations
    • Indexes and Conditional Columns
    • Grouping and Summarizing Data
    • Transposing Data
    • Pivoting and UnPivoting Data
    Merging, Appending, and Updating Queries
    • Updating Workbook Queries
    • Combining Multiple Queries
    • Appending Queries
    • Utilizing a Folder of Data Files

     

    Custom Columns
    • Columns From Examples
    • Custom Columns
    M Language and Advanced Query Editor Concepts
    • M Language Overview
    • Parameters in Power Query
    • Maintaining Parameters
    • Custom M Function Overview
    • Custom M Functions with Parameters
    • Custom M Functions using Advanced Editor
    Query Organization and Dependencies
    • Grouping Queries
    • Query Dependency View

    Level 3: Power Pivot and DAX

    Overview

    You will be learning in-detail about all the techniques of Power Pivot of excel and what are its usages & benefits. This course will help you to know how Power Pivot  will help to analyze the comprehensive data to make timely business decisions. This class is ideal for Excel users that want to pull data into Excel using Power Query and summarize and analyze the data in Power Pivot. 

    Price

    $395 per Student

    CPE Credits

    8 CPE Credits

    Prerequisites

    For the best results, participants should be familiar with the topics covered in the Excel Introduction, Excel Intermediate Part 1, and Excel Intermediate Part 2 classes.

    Duration

    1 Day

    Class Outline
    Power Suite Overview
    • What is Power Pivot, Power Query, Power View and Power Map
    • The Power Suite Workflow
    • Power Query Examples
    • Power Pivot Examples
    • Power View Examples
    Data Modeling
    • Introduction
    • Understanding Excel’s Data Model
    • Data View versus Diagram View
    • Database Normalization
    • Data Tables versus Lookup Tables
    • Relationships versus Merged Tables
    • Creating Table Relationships
    • Updating Table Relationships
    • Active versus Inactive Relationships
    • Relationship Cardinality
    • Connecting Multiple Data Tables
    • Data Filter Direction
    • Hiding Fields from Client Tools
    • Defining Hierarchies
    Power Pivot and DAX
    • Introduction
    • Creating a Power Pivot Table
    • Power Pivots versus Normal Pivots
    • Data Analysis Expression (DAX) Overview
    • Calculated Columns
    • DAX Measures
    • Creating Implicit Measures
    • Creating Explicit Measures (AutoSum)
    • Creating Explicit Measures (Power Pivot)
    • Filter Context
    • Measure Calculation Steps
    • Dimensions vs Measures
    • Best Practices
    Popular DAX Functions
    • Introduction
    • DAX Formula Syntax and Operators
    • Common DAX Function Categories
    • Basic Math and Statistical Functions
    • COUNT, COUNTA, DISTINCTCOUNT, and COUNTROWS Functions
    • Logical Functions: IF, AND, OR
    • SWITCH Function
    • Text Functions: LEN, CONCATENATE, UPPER, LOWER, PROPER, LEFT, MID, RIGHT, SEARCH, SUBSTITUTE
    • CALCULATE Function
    • Adding Filter Context with FILTER
    • Removing Filter Context with ALL
    • Joining Data with RELATED Function
    • Iterator (“X”) Functions: SUMX
    • Iterator (“X”) Functions: RANKX
    • Date and Time Functions
    • Time Intelligence Formulas
    • Speed and Performance Factors
    • DAX Best Practices

      Level 3: Excel VBA Macro Programming

      Overview

      Visual Basic for Applications is the integrated programming language used in Excel. In this class we take an in-depth look at this language starting from the ground up, and how it is applied to developing programs & automating operations in Excel. The first two days of the class are learning the fundamental VBA skills, and the third day is focused on applying those skills in all day group project.

      Price

      $1,495 per Student

      CPE Credits

      24 CPE Credits

      Prerequisites

      For the best results, participants should be familiar with the topics covered in the Excel Introduction, Excel Intermediate Part 1, and Excel Intermediate Part 2 classes.

      Duration

      3 Days

      Class Outline
      Introduction to VBA
      • Why use VBA if I can record macros in Excel?
      • Recoding a Simple macro
      • Reviewing the code
      • Familiarisation with the VBA environment
      • Running Code from the VB Editor window
      • Getting help on code
      • Stepping through a procedure
      • Using a Break point
      • Communicating with the User
      VBA Terminology
      • Modules and procedures
      • Components of your code
      • Objects, Collections, Properties and methods
      • Using the Excel Object model
      Data Types, Variables and Operators
      • Working with variables and constants
      • Using Data types
      • Working with operators and expressions
      • Implicit and Explicit Declarations
      • Variable Scope – Procedural, Modular or Public
      • Passing variables by Value
      • Passing variables by Reference
      • Using Arrays
      Workbooks and Worksheets
      • Workbook objects and methods
      • Creating a new workbook
      • Adding and Renaming Sheets
      • Saving and Closing a Workbook
      Functions
      • Mathematical functions
      • Date and time functions
      • String functions
      • Using Excel functions in VBA code
      User Defined Function Procedures
      • Creating User Defined functions
      • Using user-defined functions in a worksheet
      • Declaring Multiple arguments in a function
      • Creating a Function Library
      Loops
      • Do Until and Do While loops
      • Looping at least once
      • For Next Loop
      • For Each Loops with collections
      Decision Structures
      • Using IF to make decisions
      • Testing for multiple conditions
      • Establishing Flow control
      • Branching
      • Call other procedures
      Working with Names
      • Adding Names
      • Deleting Names
      • Creating Hidden Names
      • Checking for the Existence of a Name
      Manipulating data
      • Working with the Ranges and Selections
      • Using the Cells Property to Select a Range
      • Using the Offset Property to Refer to a Range
      • Using the Columns and Rows Properties
      • Using the Union Method to Join Multiple Ranges
      • Using the IsEmpty Function
      • Using the CurrentRegion Property
      • Using the Areas Collection
      File management techniques in VBA
      • Open and Save files
      • Copy, move and delete files
      • Changing folders
      • Using Excel Open and SaveAs dialog boxes in code
      Custom Forms / Dialog boxes
      • Creating a user form
      • Labels, text boxes, combo boxes and list boxes
      • Setting properties for the form and controls
      • Assigning data to combo boxes and list boxes
      • Option buttons, Groups, checkboxes and buttons
      • Creating the event code for controls
      • Initialising the form
      • Closing the form
      • Using RefEdit to allow user interaction
      Managing Information with VBA
      • Linking Excel to an Access database
      • Adding a Record to the Database from Excel
      • Retrieving Records from the Database
      • Updating an Existing Record

      Contact Us

      Phone

      817-841-9560

      Email

      excel@dfwexcel.com

      Office Address

      5608 Malvey Ave,
      Suite 14620,
      Fort Worth, TX 76107

      Mailing Address

      PO Box 712
      Aledo, TX 76008

      Communication Preference

      14 + 9 =