Gain essential Excel® skills to organize, analyze, and present data effectively. Learn to navigate the Excel interface, create and save workbooks, enter and edit cell data, perform calculations, format worksheets, print workbooks, and manage multiple worksheets. This course is perfect for beginners looking to build a strong foundation in Excel.

• Navigate and use Excel 2021
• Create, save, and manage basic workbooks
• Perform calculations and use functions
• Format and print worksheets
• Manage workbook properties and views

Advance your Excel® skills to the next level. Learn how to work with specialized functions, manage lists, analyze data, create advanced charts, and utilize PivotTables and PivotCharts for deeper insights. Ideal for users who already understand the basics and want to expand their capabilities.

• Apply logical, text, date, and time functions
• Sort, filter, and outline data
• Create and format tables and charts
• Use advanced conditional formatting
• Leverage PivotTables and PivotCharts for data analysis

Master advanced Excel® features including collaboration, automation, and sophisticated data analysis. Learn to link data across workbooks, protect and share your files, validate and audit data, automate tasks with macros, and perform forecasting and mapping.

• Work with multiple worksheets and workbooks
• Share and protect Excel files
• Automate tasks with data validation and macros
• Utilize lookup functions and dynamic arrays
• Forecast trends and visualize data with sparklines and maps

Unlock the full potential of PivotTables and PivotCharts to summarize, organize, and visualize large sets of data. Learn to prepare data, create PivotTables from various sources, analyze and format PivotTable data, and present insights with PivotCharts.

• Prepare and organize data for analysis
• Create PivotTables from local and external data sources
• Summarize, filter, and format PivotTable data
• Create and manipulate PivotCharts

Learn to transform raw data into compelling visual presentations using Excel® charts. This course focuses on generating actionable organizational intelligence by helping you answer critical business questions with data-driven visuals.

• Generate and format charts
• Integrate data visuals into reporting workflows
• Enhance decision-making with impactful presentations

Deepen your knowledge of Excel® functions for powerful data analysis. Move beyond simple calculations to extract meaningful intelligence from your data using logical, text, and specialized functions.

• Apply advanced Excel functions for analysis
• Customize formulas for specific business needs

Develop the expertise to create advanced formulas for complex calculations and audit your workbooks to troubleshoot and resolve errors, ensuring data accuracy and reliability.

• Use lookup and reference functions
• Audit and evaluate formulas
• Troubleshoot and correct Excel data issues

Streamline your workflow and boost productivity by automating repetitive tasks, validating data, and mastering Excel’s macro features.

• Set up data validation and error checking
• Create and manage macros to automate tasks
• Enhance data integrity and efficiency