Microsoft Excel 365: Ultimate Beginner Guide

**This course includes downloadable instructor files to work with and follow along.

Are you ready to conquer Excel 365 like a pro? Look no further. Our Microsoft Excel 365 Ultimate Beginner Guide is the perfect starting point for students and anyone eager to dive into the world of number-crunching, data organizing, and chart making.

Need to know your cells from your columns? No worries, as we'll guide you through Excel's interface, introducing you to the world of workbooks and worksheets. Learn to navigate like a champ.

Say goodbye to manual calculations and discover how to enter data efficiently, format numbers, and work with basic formulas and functions.

Make graphs your secret weapon. Uncover the power of Excel's charting tools. We'll teach you how to create eye-catching visuals to impress your colleagues and managers.

Data can be messy, but not for you. We'll explore how to sort, filter, and manage data effectively. Learn to share your work, collaborate with peers, and ensure your Excel skills shine in group projects. We'll cover sharing options and tips for stress-free teamwork.

Become an Excel efficiency expert and discover shortcuts, hidden gems, and tips that will save you time and frustration. You can be an Excel guru in no time.

By the end of this course, you should be able to confidently tackle Excel spreadsheets and impress your professors or future employers. So, what are you waiting for? Let's embark on this Excel adventure together.

In this course, you will learn how to:

• Access the Microsoft 365 online portal, launch Excel desktop, navigate the interface, and improve efficiency with keyboard shortcuts.

• Understand the order of operations and the BODMAS rule and use the 'Big 6' basic Excel functions to create formulas.

• Know the difference between absolute and relative referencing, create named ranges, and use named ranges in formulas.

• Apply number formatting, format cells, rows, and columns, copy formatting with Format Painter, and work with conditional formatting.

• Perform lookups with VLOOKUP and XLOOKUP and use logical functions to make better decisions.

• Create and use Excel tables, sort and filter list data, present data with charts, and insert in-cell charts like sparklines.

• Freeze and unfreeze panes, adjust page setup options, and insert headers, footers, and page breaks.

• Protect cells, worksheets, and workbooks from editing and save the workbook in different file formats.

• Work with files in Excel Online, co-author spreadsheets with others in real time, and share workbooks with others.

• Add an Excel workbook to a Teams channel and share in a Teams meeting.

This course includes:

1. 10+ hours of video tutorials

2. 100+ individual video lectures

3. Course and exercise files to follow along

4. Certificate of completion