Introduction to Microsoft Excel Training (EXC365.1)

1 day

The Introduction to Excel course is designed for beginners seeking to learn the fundamentals of Microsoft Excel. This comprehensive course covers various aspects of Excel, such as the Microsoft Office basics, creating and managing workbooks, using the Ribbon and Backstage View, customizing the Quick Access Toolbar, entering and formatting data, editing worksheets, working with rows and columns, using formulas, and finalizing worksheets for printing. By the end of this course, students will have a solid foundation in Excel, enabling them to efficiently manage and analyze data.

Excel Version: This course primarily targets Excel 365 and Excel 2021; however, we draw …

Introduction to Microsoft Excel 2019 (EXC2019.1)

1 day

This Introduction to Microsoft Excel 2019 course begins with the fundamentals of creating a workbook and gradually progresses to cover the program's most advanced features. The curriculum is designed to help you navigate Excel's interface, enter and format data efficiently, use formulas, edit your worksheets, and prepare your work for printing.

This is the updated version of 55271AC from the retired Microsoft Courseware Marketplace. Note that we have a newer version that covers Excel 2021 and 365.

Introduction to Microsoft Excel 2016 (EXC2016.1)

1 day

In this Introduction to Microsoft Excel 2016 course, you'll start from the very basics of creating a workbook, and gradually work your way up to using advanced features introduced in Excel 2013 and 2016. The course covers how to work with the ribbon, understand the Backstage View, and customize the Quick Access Toolbar. You'll learn how to efficiently enter and format data, use formulas, and edit your worksheets. The course concludes with preparing your worksheets for printing and exploring new features in the latest Excel versions.

This is the updated version of 55165AC from the retired Microsoft Courseware Marketplace. Note …

Excel 2019 Pivot Tables (0200-500-19-W)

1 day

In this course you will learn how to create and modify PivotTables and PivotCharts, as well as how to filter and modify fields to format and group data. In addition, you will learn to use the advanced features of PivotTables, such as consolidating multiple workbooks as well as creating and using page fields. Finally, you will learn how to generate PivotTables using imported data from external data sources. This information could be in Access, SQL Tables, the Internet, or other database programs. Understanding how to work with PivotTables and PivotCharts to achieve the results you want is one of the …

Excel 2019 Formulas (0200-240-19-W)

1 day

In this course, you will cover how to: name cells and ranges, use those names in formulas, use Logical and Lookup function formulas, use the IF and IFS formulas, Data Validation, use Match and Indexing formulas, work with Date and Time formulas, and use the formula auditing tools to trouble shoot problems in formulas.

In this course, you will cover how to: name cells and ranges, use those names in formulas, use Logical and Lookup function formulas, use the IF and IFS formulas, Data Validation, use Match and Indexing formulas, work with Date and Time formulas, and use the formula …

Intermediate Microsoft Excel Training (EXC365.2)

1 day

This Intermediate Excel course builds upon the foundational skills acquired in the Introduction to Excel course, offering a deeper understanding of Excel's capabilities. The course covers common functions like IF, COUNTIF, and TEXTJOIN, as well as working with lists, tables, and advanced formatting. It also provides an introduction to visualizing data through charts, sparklines, and SmartArt. Throughout the course, students will learn how to apply these concepts to real-world scenarios, improving their ability to manage and analyze data effectively.

Excel Version: This course primarily targets Excel 365 and Excel 2021; however, we draw attention to features that are not supported …

Advanced Microsoft Excel Training (EXC365.3)

1 day

The Advanced Excel course is designed for experienced users looking to leverage Excel's powerful features to streamline their work and enhance their data analysis capabilities. The course delves into topics such as PivotTables, advanced functions, auditing workbooks, and data tools. Students will also explore importing and consolidating data, What-If analysis, recording and using macros, and collaborating with others. Through hands-on exercises and real-world examples, students will master advanced Excel techniques, equipping them with the skills needed to tackle complex data analysis tasks efficiently.

Excel Version: This course primarily targets Excel 365 and Excel 2021; however, we draw attention to features …

Intermediate Microsoft Excel 2019 (EXC2019.2)

1 day

This Intermediate Microsoft Excel 2019 course is designed to deepen your understanding of Excel's powerful features, with a focus on formulas, list management, illustrations, data visualization, table manipulation, and advanced formatting. Each topic is accompanied by practical exercises to reinforce your learning.

This is the same course as 55269AC from the retired Microsoft Courseware Marketplace. Note that we have a newer version that covers Microsoft Excel 2021 and 365.

Intermediate Microsoft Excel 2016 (EXC2016.2)

1 day

This Intermediate Microsoft Excel 2016 will take your Excel skills to the next level. Learn how to use advanced formulas, work with lists, illustrations, and tables, and visualize your data with sophisticated charting techniques. Understand how to apply advanced formatting such as conditional formatting and styles, and even get familiar with new features in Excel 2013 and Excel 2016. Throughout the course, you'll get hands-on experience with exercises designed to reinforce what you've learned and build real-world skills.

This is the updated version of 55166AC from the retired Microsoft Courseware Marketplace. Note that we have newer versions: one that covers Excel …

Advanced Microsoft Excel 2019 (EXC2019.3)

1 day

This Advanced Microsoft Excel 2019 course will take you through the key functionalities of Microsoft Excel, from creating Pivot Tables, auditing worksheets, using various data tools, to recording and using macros. You will also learn how to work collaboratively and effectively with others, explore various random useful features, and understand how to harness the power of the cloud. Each module is accompanied by practical exercises to help consolidate your learning.

This is the updated version of 55270AC from the retired Microsoft Courseware Marketplace. Note that we a newer version that covers Excel 2021 and 365.

Advanced Microsoft Excel 2016 (EXC2016.3)

1 day

This Advanced Microsoft Excel 2016 equips you with essential Excel skills for data manipulation and analysis, workbook auditing, and collaborative work. Master the art of creating and working with pivot tables, and learn how to audit worksheets for data dependencies and precedents. Further, delve into various data tools such as text-to-columns conversion, data validation, and goal seeking. Enhance your collaborative work efficiency with workbook and worksheet protection methods, and empower your Excel proficiency with macro recording and editing. Learn to use and customize sparklines, prepare your workbook for internationalization and accessibility, and understand how to import and export data. The …