Beginner to Intermediate Excel for Real-World Applications

Learn beginner to intermediate concepts, features, and functions that you will need to create and work with data in Microsoft Excel. This course guides students through the most useful concepts of Microsoft Excel with real-world scenarios and application.

Build a strong foundation tutorial for beginners which extends to intermediate concepts.

• Basic Navigation and Shortcuts

• Formatting and Formulas

• Vlookups and If Statements

• Pivot Tables and Charts

Your Tool Belt

Knowing how to use Microsoft Excel is one of the greatest tools you can have in your tool belt. This is one application that anyone can benefit from to increase productivity and stay organized.

Content and Overview

This course is intended for students, entry level grads, new managers, administrators or anyone looking to learn more about how to use Microsoft Excel. This course offers 40 lectures and 4 hours of content, and at the end you’ll understand the most common and useful features and concepts of Excel for practical, real-world scenarios.

Hands-on assignments are included in the course to test your knowledge. These exercises allow you to immediately get hands on to practice your new skills.

Starting with the basic navigation and terminology, the course highlights useful shortcuts and time-savings which if instilled now, can save time and make you more productivity with any task. Sections that follow include learning about page layouts, formatting, basic formulas and features.

After these beginner concepts are completed, the course teaches you how to manage datasets with more advanced logic statements like If Statements and VLOOKUPs, then you’ll learn how to create pivot tables and charts. The power that comes from this skill set cannot be overstated. Having the ability to work with big data, to understand pivot tables and charts to tell a story about the data and quickly slice, dice and visualize will always be in demand and a great skill for anyone to learn.

Students completing the course will have a great start in any career that involves working with any reporting or data but it’s a skill that can benefit just about anyone in general.

Disclaimer

The course content was created on Windows 11 using Microsoft 365. Prior versions or other Operating Systems may have slightly varied functionality but the course overall is still applicable to learn with.