Exceljet

This course offers complete beginners the opportunity to build foundational skills in using Microsoft Excel effectively and efficiently. Students develop familiarity with the interface, gaining experience with worksheets and entering data. Students learn about the many formatting features in Excel, including conditional formatting, as they begin to work with elementary formulas and charts. By the end of the course, students will know multiple tools for increasing their productivity in Excel spreadsheets.

Through this course, students get in-depth training for understanding and optimizing their use of formulas in Microsoft Excel. Students learn the foundations of formulas and creating references and ranges, and develop familiarity with using IF functions and VLOOKUP for navigating their data. They also learn how to manipulate text with formulas, use Excel for statistics, and troubleshoot formula errors. By the time that students have finished the course, they will also have the ability to use formulas to increase workplace productivity.

For students who want to optimize their productivity, this course teaches how to create and use pivot tables in Microsoft Excel. Students learn to use pivot tables for calculations and groupings and to customize pivot table layouts. In addition, students gain experience with using slicers and creating pivot charts. Finally, students learn how to troubleshoot unexpected errors in their pivot tables.

In this course, students discover how to use a new feature in Microsoft Excel called Dynamic Arrays. Students learn about arrays as a concept as well as Boolean algebra and operations. Then, students learn how to make the feature work for them with instructions for sorting and filtering data, finding unique values and generating sequences and random values. In the end, students learn to use XLOOKUP and combine it with Boolean logic.

This course helps students visualize their data with charts in Microsoft Excel. Students start by learning about the anatomy of charts and how to create and format them. Then, students get exposure to a wide range of different types of charts, such as line charts, pie charts, histogram charts, and area charts. Students also learn about making charts dynamic and how to create and use pivot charts.

Through this course, students discover quick tools for increasing productivity with Microsoft Excel shortcuts. The course covers shortcuts for entering, editing, and formatting data, as well as making selections and navigating in a spreadsheet. Students also learn about using shortcuts for formulas and tables and editing the spreadsheet grid.

Students in this course learn all about tables for Microsoft Excel, from what they are and what they do to how to build them and how to benefit from them. Students get a theoretical introduction to tables and learn to navigate, customize, and format them. Additionally, students learn how to use formulas with tables, gaining experience with structured references and slicers. At the end of the course, students discover pivot tables and charts and how to create them.

This course gets students started on using conditional formatting, an easy tool for data visualization in Microsoft Excel. Students learn about the uses of conditional formatting and how it works. Then, they discover how to use preset conditional formatting before learning how to tailor their own conditional formatting with formulas. By the end of the class, students will understand where their data analysis would benefit from conditional formatting and how to apply it.