Best Business Analyst Classes Online

This tutorial teaches students easy techniques for optimizing their time spent in Microsoft Excel spreadsheets. Students discover keyboard shortcuts, autofill options, and ways to spend less time reformatting data and grids. Additionally, students learn to create easy charts and harness commands. By the end of the class, students will have acquired 10 new skills in Excel.

In this series of four courses, beginner students gain all the tools that advanced business professionals use in Microsoft Excel. Students learn how to navigate and customize spreadsheets and get experience solving problems with formulas and functions before discovering automation techniques for working with large data sets. In addition, students learn to use graphs, charts, pivot tables and charts, and macros for data analysis and gain familiarity with Visual Basic for Excel. Graduates earn a professional certificate.

Students in this course level up from novice to expert in using Microsoft Excel for business. Students learn the fundamentals of using data in spreadsheets, including data integrity, as they learn how to create charts and graphs and take advantage of conditional formatting and templates. As students progress through the course, they gain experience with functions, formulas, macros, and pivot tables and pivot charts, and also learn to use automated tools and do data analysis. At the end of the course, graduates earn an Excel certification from Austin Peay State University continuing education, recognized by the global CPD Certification Service.

Through a series of three courses, beginners in this professional certificate program gain advanced skills in Microsoft Excel. Students start by learning how Excel can power business data analysis and discover how to create and manage spreadsheets, enter and manage data, and generate charts for data visualization. Then, students learn to use functions, formulas, tables, and pivot tables and charts before gaining experience with automation, macros, and Visual Basic for Excel. Graduates earn a professional certificate through edX.

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 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.

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.

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.

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.