Microsoft Excel Essentials/Advanced Courses
- Excel Level 1 – User Essentials
- Excel Level 2 – Tables & Charts
- Excel Level 3 – Formulas & Functions
- Excel Level 4 – Pivot Tables
Microsoft Excel Power User Courses
Excel Training for Employees and Individuals in the Annapolis area
Data Creative provides live, instructor-led Excel classes to help you master Microsoft’s most popular data-related application, Microsoft Excel. Our top-rated, expert instructors train thousands of employees each year to produce higher quality work with more efficiency and confidence. Every class is live using hands-on exercises.
Excel Training for Private Groups in the Annapolis area
Data Creative can deliver live, in-person or virtual Excel classes to your group at your location in the Annapolis, Maryland area.. Our instructors will go onsite to deliver standard or customized classes to meet your needs, schedule and budget. We can also deliver your private class virtually using Teams or Zoom. Contact Data Creative today to learn more about our private group training capabilities.
Request a private group training event here for your group in Annapolis, Maryland or call 916-601-0992 for more information.
Upcoming Excel Classes
Excel Level 1 – User Essentials
Creating Spreadsheets and Understanding Basic Formula Construction — 4 hours
Excel Level 1 is a four-hour instructor-led class providing the basic concepts and skills needed to be both productive and efficient in the application. At course completion, participants will be able to create and edit worksheets and workbooks, perform basic formulas and functions, and understand how to format, manipulate, print, and protect their data.
- Navigating and Workbook Basics
- Basic Formulas and Functions
- Understanding and utilizing Absolute vs Relative references
- Formatting, Styles and Themes
- Data Entry Shortcuts
- Autofill, Linking and Paste Options
- Inserting, Deleting, Hiding Rows and Columns
- Protecting Worksheets and Workbooks
- Importing Data
- Printing and Saving Options
Class Schedule
Excel Level 2 – Tables & Charts
Data Analysis and Visualization — 4 hours
Excel Level 2 is a four-hour instructor-led class providing training on intermediate-level features and tools within Microsoft Excel to organize and analyze data. Upon successful completion of the class, students will be able to perform an array of common tasks more confidently and efficiently, such as working with named ranges, tables, advanced formats, and charts.
- Customizing the Ribbon, Quick Access Toolbar, Status Bar, Options
- Inserting, Deleting, Hiding and Rearranging Worksheets
- Creating and Managing Named Ranges
- Understanding Excel Table Structure
- Creating a Table
- Creating and Customizing Table Styles
- Conditional and Custom Formats
- Adding Graphics
- Creating Charts Utilizing Visualizations
Class Schedule
Excel Level 3 – Formulas & Functions
Creating Formulas and Working with Built-In Functions including Lookup — 4 hours
Excel Level 3 is a four-hour instructor-led class taking participants to an advanced level using formulas and functions in Microsoft Excel. By the end of the class, participants will be able to manipulate large data sets more quickly and easily using a variety of advanced functions and formulas. Participants will also be able to summarize data efficiently using the subtotals feature.
- IF, AND, OR, NOT
- Creating Nested Functions
- VLOOKUP, HLOOKUP, XLOOKUP
- Date/Time & Text Functions
- SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS
- Formula Auditing Tools
- 3D References
- Subtotals
Class Schedule
Excel Level 4 – Pivot Tables
Summarizing and Analyzing Large Amounts of Data — 4 hours
Excel Pivot Tables is a four-hour instructor led class covering Pivot Tables, a powerful feature in Microsoft Excel which enables data manipulation with simple dragging and dropping. At the end of this class, participants will be able to sort, filter, group, summarize, and format data with ease and efficiency using Pivot Tables.
- Setting up your Source Data
- Creating Pivot Tables in Excel
- Pivoting your Data
- Drilling Down
- Sorting Pivot Table Data
- Grouping Fields in the Pivot Table
- Filtering Pivot Table Data
- Using Slicers to Visually Filter Data
- Exploring Report Layouts
- Calculating Pivot Table Values
- Generating and Manipulating Pivot Charts
- Showing and Hiding Show Commands Features
Class Schedule
Upcoming Excel Classes
Excel Level 5 – Power Pivot
Creating Data Models and Performing Data Analysis — 4 hours
Excel Power Pivot is a four-hour instructor-led course covering the Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can combine large volumes of data from various sources, perform information analysis rapidly, and share insights easily.
- Importing Data from Access and Excel
- Understanding Relationships Between Data Tables
- Creating Relationships from List Data
- Creating Hierarchies
- Shaping the Data Model with Data Analysis Expressions Functions (DAX)
- Creating Calculated Columns
- Creating Calculated Measures
- Customizing DAX Expressions
Class Schedule
Excel Level 6 – Power Query
Preparing and Manipulating Data Sets — 4 hours
Excel Power Query is a four-hour instructor-led course covering the Power Query add-in feature you can use to prepare and manipulate large data sets. Power Query helps you collect data from different sources using a graphical interface and apply transformations using a Power Query Editor.
You can import data, clean it, transform it, then reshape it according to your needs. You can set up a query once and re-use it later by simply refreshing. Power Query has several useful features embedded in it, such as the appending of data and creating relationships between different data sets. You can group and summarize data with the help of the Power Query tool.
- Introduction to Power Query
- Data Scrubbing
- Data Preparation Challenges
- Combining Data from Multiple Sources and Mismatched Tables
- Unpivoting Tables to Restructure Data or Address Previous Poor Design
- Avoiding Common Data Wrangling Pitfalls to Build Robust Queries
Class Schedule
Annapolis Excel Classes
What People Are Saying About Us
Frequently Asked Questions
Microsoft Excel is a powerful spreadsheet software developed by Microsoft. It is used for data analysis, calculation, visualization, and organizing information. Excel is essential in various fields, including finance, accounting, data analysis, project management, and more.
No prior experience is necessary. Our Excel classes cater to all levels, from beginners to intermediate and advanced users. Our instructors will start from the basics and gradually build up your skills.
The class will cover a wide range of topics, including Excel basics, formulas and functions, data manipulation, charts and graphs, conditional formatting, data validation, pivot tables, and more. The syllabus will be provided at the beginning of the course.
Our online Excel classes are conducted through a user-friendly virtual learning platform. You can participate in live sessions, access pre-recorded lectures, and interact with the instructor and fellow students in real-time.
To participate in our online classes, you will need a computer or laptop with a stable internet connection. The virtual learning platform we use is accessible through standard web browsers, and no additional software installation is required.