This course also covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2019): Exam MO-200 and Excel Expert (Office 365 and Office 2019): Exam MO-201.
Master the basics—and open the door to more advanced skills in data analysis, reporting, data visualization, and spreadsheet management.
In this Excel for beginners course, you’ll learn how to create and format spreadsheets, apply Excel formulas and Excel functions, design and modify Excel charts, and organize information into structured tables and worksheets. You’ll develop the confidence to use Excel like a pro, streamline everyday tasks, and set a strong foundation for advanced tips and future certifications.
Upcoming Schedules
| Date | Time | Enroll |
|---|---|---|
| Nov 04 - Nov 04, 2026 | 8:00 AM - 4:00 PM America/New_York | Add To Cart |
| Nov 09 - Nov 09, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
| Nov 12 - Nov 12, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
| Nov 17 - Nov 17, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
| Nov 20 - Nov 20, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
| Nov 25 - Nov 25, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
| Nov 30 - Nov 30, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
| Dec 03 - Dec 03, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
| Dec 08 - Dec 08, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
| Dec 11 - Dec 11, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
| Dec 16 - Dec 16, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
| Dec 21 - Dec 21, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
| Dec 24 - Dec 24, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
| Dec 29 - Dec 29, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
Prerequisites for Excel – Part 1 Course
Excel – Part 1 Course Outline
- Navigate the Excel user interface and organize your workspace efficiently
- Use Excel commands and features, and locate tools with shortcut keys
- Create and save a basic workbook
- Access and use Excel Online for cloud-based collaboration
- Enter and edit data entry efficiently in worksheets
- Find help and support through built-in tools and Microsoft Support resources
- Build Excel formulas to perform calculations quickly
- Insert and manage Excel functions like SUM, AVERAGE, and logical operators
- Reuse and copy formulas and functions using step-by-step techniques
- Insert, delete, and adjust cells, columns, and rows
- Search for and replace data, and use filter tools for data management
- Apply text and number formatting, including borders and shading for visual emphasis
- Align, arrange, and organize worksheet content
- Apply colors, borders, and predefined styles for professional spreadsheets
- Apply basic conditional formatting to highlight trends
- Create and use templates to streamline repetitive tasks
- Preview and print worksheets with correct page layout settings
- Configure headers and footers to provide context in printed sheets
- Customize your sheet layout for clean presentation
- Manage multiple sheets and workbooks efficiently
- Update workbook properties to maintain organized files
- What Is Microsoft Copilot Chat?
- The Magic Prompt Formula
- Work Smarter with AI
Resources
FAQs on Excel – Part 1
You’ll learn to create and format spreadsheets, build formulas and functions (like SUM and AVERAGE), design charts, organize data into tables, and manage worksheets and cells effectively.
Basic computer literacy, familiarity with PC operating system navigation, and basic internet usage skills are required. No prior Excel experience is necessary.
This course is designed for beginners who want to build foundational Excel skills, including new employees, students, or professionals looking to improve spreadsheet management and data organization abilities.
Yes, you’ll learn to build formulas, use common functions like SUM, AVERAGE, and logical operators, and how to copy and reuse them efficiently across worksheets.
Yes, this beginner course establishes core Excel skills in navigation, calculations, formatting, and data organization, preparing you for advanced topics and future Excel certifications.


