Excel 2021 for Beginners
Excel 2021 for Beginners
- DURATION: 11h 10m
- VIDEOS: 100
- LEVEL: Beginner
- Description
- Course Resources
Welcome to “Excel 2021 for Beginners,” a comprehensive course designed to equip you with the essential skills to navigate and utilize Microsoft Excel effectively. In this course, we’ll explore Excel’s features, from understanding the interface to mastering formulas, functions, and data visualization.
You will begin by differentiating between Excel 2021 and Excel for Microsoft 365, delving into the intricacies of the start screen, ribbons, tabs, and menus. As you progress, you’ll learn to work with templates, manage workbooks, and manipulate data efficiently. Discover the power of formulas and functions like SUM and AVERAGE, and gain insights into named ranges for enhanced calculations.
Hands-on exercises accompany each module, allowing you to apply your newfound knowledge and reinforce your skills. This course covers the fundamentals and beyond — from formatting cells, rows, and columns to structuring lists and utilizing advanced features like VLOOKUP and charts.
As you navigate through workbook views, learn printing essentials, and explore data protection, you’ll gain confidence in Excel’s versatile functionalities. By the end of the course, you should be able to create, format, and analyze data, making Excel an invaluable tool for personal and professional tasks. Join us today to unlock the full potential of Excel 2021 and enhance your productivity!
In this course, you will be able to:
- Know what’s new in Excel 2021 and navigate the interface.
- Create your first Excel spreadsheet and use keyboard shortcuts.
- Understand basic and intermediate Excel formulas and functions.
- Apply formatting to cells and use conditional formatting.
- Use Excel lists, sorting, and filtering effectively.
- Link to other worksheets and workbooks.
- Analyze data using charts and insert pictures into a spreadsheet.
- Work with views, zooms, and freezing panes.
- Set page layout and print options.
- Protect and share workbooks and save them in different file formats.
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!
The course comes with course and exercise files compressed into .zip format. You will need to download the .zip file to your PC or Mac (the files are not compatible with a mobile device) and unzip it. Once unzipped, all of the exercise files will reside in one folder.
Click on the below to open Dropbox in a new browser tab, then click on “Download” in the top right-hand corner.
VIDEO LED, HIGH DEFINITION TRAINING
EXCERCISE FILES INCLUDED
2,000,000+ STUDENTS AROUND THE WORLD
UNCONDITIONAL, 30 DAY MONEY BACK GUARANTEE
VIEWABLE ON PC AND MAC DEVICES
ACCESS THIS COURSE AND OVER 200 OTHERSWhat people are saying
Trusted by
Start Your Membership
Simon Sez: “Let’s make you a software superstar!”
From Excel to photo editing, experience quality courses that ensure easy learning.
START YOUR MEMBERSHIPLearn More