Microsoft Excel Training | Excel Courses in St Louis

Microsoft Excel Training Outline

Module 1: Navigation of the Excel Interface

• Understanding the Excel Start Screen
• Excel Tab Interface
• Introduction to Microsoft Excel
• Excel Workbook Screen
• Ribbon
• Name Box
• Formula Bar
• Worksheet Tab
• Understanding the Backstage View
• Accessing the Backstage View
• Understanding Dialog Boxes
• Launching Dialog Boxes
• Understanding Quick Access Toolbar
• Changing the Location of the Bar
• Understanding the Status Bar

Module 2: Use of Lists and Tables

• Understanding Lists
• Applying a Filter
• Clearing a Filter
• Performing an Alphabetical Sort
• Performing a Numerical Sort
• Creating a Table
• Inserting or Deleting Table Records
• Removing Duplicates
• Modifying a Table
• Sorting Data in a Table
• Naming Tables
• Resizing Tables
• Converting a Table to a Range
• Deleting a Table

Module 3: Conditional Formatting

• Understanding Conditional Formatting
• Highlighting Cells Containing Values
• Highlighting Cells Containing Text
• Highlighting Duplicate Values
• Using Top and Bottom Rules
• Using Data Bars
• Using Color Scales
• Using Icon Sets
• Creating Custom Rules
• Conditional Formatting Rules Manager
• Clearing Rules

Module 4: Using Formulas and Creating Pivot Tables

• Using Sparklines
• Using Formulas in Excel
• Exploring Excel Functions
• Insert Function Button
• Working with Names and Ranges
• AVERAGE Function
• COUNT Function
• Common Logical Functions
• Using Formulas in Excel
• IF Formulas
• IFS Formulas

Module 5: Visualising Your Data

• Creating and Formatting Charts
• Create a PivotTable from an Excel Data List
• Refresh Data/Change Data Source
• Changing the Pivot Table Design
• Creating and Modifying a Pivot Chart
• VLOOKUP
• HLOOKUP
• XLOOKUP
• Creating and Managing Drop-down Lists
• Undo, Redo, and Repeat with Keystrokes

Module 6: Paste Special Techniques

• Basic Use Cases for Paste Special
• Transposing Data Using Paste Special
• Applying Paste Special Operations to Improve Data Accuracy

Who should attend this Microsoft Excel Masterclass?

This Microsoft Excel Masterclass in St Louis is designed for individuals of varying skill levels who want to enhance their proficiency in using Microsoft Excel. This course can benefit a wide range of professionals, including:

• Beginners
• Intermediate Users
• Advanced Users
• Business Professionals
• Entrepreneurs and Small Business Owners
• Data Analysts
• Administrative Professionals
• Project Managers

Prerequisites of the Microsoft Excel Masterclass

There are no formal prerequisites for this Microsoft Excel Masterclass.

Microsoft Excel Masterclass Overview

The Microsoft Excel Masterclass in St Louis offers an in-depth exploration of Microsoft Excel, a crucial tool in today's data-driven world. As one of the leading Microsoft Excel Training Courses, it provides comprehensive insights into the functionalities and applications of Excel, making it relevant for a wide array of professional and personal tasks.

Understanding and mastering Microsoft Excel is essential for professionals across various sectors, including finance, marketing, data analysis, and administration. Microsoft Excel Training in St Louis is not just about learning software; it's about equipping oneself with the skills to efficiently manage, analyze, and present data in a compelling and accurate manner. This knowledge is vital for anyone aiming to enhance their analytical skills and improve their workplace productivity.

This 1-day training by The Knowledge Academy in St Louis is meticulously designed to cater to both beginners and advanced users of Excel. It offers practical, hands-on experience, ensuring that delegates walk away with a robust understanding of Excel's capabilities. The course is structured to provide immediate value, empowering attendees with the skills to transform their approach to data handling and presentation.

Course Objectives:

• To introduce the basic features and functions of Microsoft Excel
• To enhance proficiency in data organization and manipulation
• To develop skills in creating and formatting charts and graphs
• To master advanced functions such as VLOOKUP and PivotTables
• To improve efficiency in data analysis and decision-making processes
• To provide insights into automating tasks with Excel Macros and VBA

Upon completion of the Microsoft Excel Masterclass in St Louis, delegates will not only have a strong command over Excel's features but also gain the confidence to apply these skills in real-world scenarios. This empowerment will lead to improved efficiency and effectiveness in their professional roles.

What’s included in this Microsoft Excel Masterclass?

• World-Class Training Sessions from Experienced Instructors 
• Microsoft Excel Certificate
• Digital Delegate Pack