Excel 365 for Beginners

Are you ready to conquer Excel 365 like a pro? Look no further than our Microsoft Excel 365 Ultimate Beginner Guide – your gateway to the world of number-crunching, data organization, and chart-making.

Need to know your cells from your columns? No worries, as we provide expert guidance through Excel’s interface, unveiling the world of workbooks and worksheets. Learn to navigate with ease!

Say goodbye to laborious manual calculations and embrace mastery of efficient data entry, number formatting, and basic formulas and functions.

Unlock the potential of Excel’s charting tools, turning graphs into your secret weapon for crafting stunning visuals that will leave your colleagues and managers in awe.

Messy data becomes a breeze to manage as we delve into sorting, filtering, and effective data management.

Learn the art of sharing your work, collaborating seamlessly with peers, and ensuring your Excel skills shine in group projects. We’ll cover sharing options and teamwork tips.

Transform into an Excel efficiency expert armed with shortcuts, hidden gems, and time-saving tips that can elevate your proficiency.

Upon completing this course, you can confidently conquer Excel spreadsheets and leave a lasting impression on professors and future employers. Don’t wait any longer – join us on this exciting Excel adventure.

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.

WHAT YOU GET

Certificate of Completion

• Earn a certificate each time you complete a course.
• Showcase your commitment to continuous growth and professional development.
• Impress potential employers.
• Enhance your professional profile.
• Available in PDF format to Download or Print.

INSTRUCTOR

Deborah Ashby

Meet Deb, your go-to guide in the exciting world of Excel and beyond! With her infectious enthusiasm and razor-sharp expertise, she's on a quest to turn everyone into Excel wizards. Deb doesn't just stop at Excel, though. She'll lead you through the fascinating realms of Microsoft Word, PowerPoint, and other Microsoft 365 apps, helping businesses and individuals alike to unlock their full potential. But she's no ordinary trainer. Boasting an impressive track record of over 25 years and revered by past and current learners alike, Deb's teaching prowess is unparalleled. To top it off, she's a proud recipient of the coveted Microsoft MVP (Most Valuable Professional) award. Buckle up and join Deb on this exhilarating learning journey!