Excel Made Easy: Learn Microsoft Excel from Scratch
Boost your productivity and career opportunities with our step-by-step Excel online and presential course. Whether you’re a beginner or need a refresher, you’ll learn how to manage data, create formulas, use spreadsheets, and build reports with confidence.
English or Spanish | Private or small group options | Start anytime
Scroll down to explore the full course guide and choose the learning format that works best for you.
Table of Contents
Excel for Absolute Beginners – Study Program
Chapter 1: Introduction to Excel
- What is Excel? Overview and uses
- Understanding the Excel interface (Ribbon, Cells, Worksheets)
- Navigating an Excel Workbook
- Saving and Opening Workbooks
- Basic Data Entry (Typing text and numbers)
Chapter 2: Formatting Basics
- Adjusting Column Width and Row Height
- Changing Fonts, Colors, and Cell Styles
- Cell Alignment and Text Wrapping
- Borders and Cell Background Colors
- Number Formatting (Currency, Percentage, Date, etc.)
Chapter 3: Basic Data Manipulation
- Copying, Cutting, and Pasting Data
- Using AutoFill and Flash Fill
- Inserting and Deleting Rows/Columns
- Sorting Data (Alphabetical, Numerical)
- Filtering Data
Chapter 4: Basic Formulas and Functions
- Understanding Formulas in Excel
- Basic Arithmetic Operations (+, -, *, /)
- Using SUM, AVERAGE, MIN, MAX
- Introduction to Cell References (Relative vs. Absolute)
- AutoSum and Quick Calculations
Chapter 5: Working with Tables and Data Management
- Creating and Formatting Tables
- Sorting and Filtering Data in Tables
- Removing Duplicates
- Basic Data Validation (Dropdown Lists)
- Freezing Panes for Easier Navigation
Chapter 6: Introduction to Charts and Graphs
- Types of Charts in Excel
- Creating a Simple Chart
- Customizing Chart Design and Layout
- Adding Titles, Labels, and Legends
- Printing and Exporting Charts
Chapter 7: Intermediate Functions
- IF Function (Basic Logical Tests)
- COUNTIF and SUMIF Functions
- CONCATENATE / TEXTJOIN for Merging Data
- LEFT, RIGHT, MID for Text Extraction
- Understanding Basic Error Messages
Chapter 8: Working with Multiple Sheets
- Adding, Renaming, and Deleting Sheets
- Linking Data Between Sheets
- Grouping and Organizing Sheets
- Basic Protection and Locking of Sheets
- Creating a Summary Sheet
Chapter 9: Introduction to Pivot Tables
- What is a Pivot Table?
- Creating a Basic Pivot Table
- Customizing Pivot Table Fields
- Sorting and Filtering Data in Pivot Tables
- Introduction to Pivot Charts
Chapter 10: Printing and Sharing Excel Files
- Setting Up Page Layout and Print Areas
- Using Print Preview
- Adjusting Margins and Page Orientation
- Exporting as PDF
- Sharing and collaborating on Excel Files
"My team and I really enjoyed this Excel course and learned a lot. The material was well-structured and easy to follow and the instructor was knowledgeable and engaging. I found the course to be very useful and relevant to my goals"
“Robert is a great teacher! I know a lot more about Excel now and that makes my job easier. He was clear, concise and had lots of real life examples. That made a huge difference. I do recommend any of his courses, but especially Excel and PowerPoint..”
“I highly recommend them. Was in need to improve my knowledge and skills with excel due to a new project and role at work. They were very knowledgeable and made the process and course smooth, fun and gave me the skills needed.”
"Excelente curso de Excel para obtener mayor conocimientos. Fácil de entender y con muchos ejemplos de cosas que se presentan en mi trabajo dia a dia."
"I took the computer basics class in Spanish, and it was exactly what I needed. The instructor was patient and explained everything clearly. Now I feel confident using email and Word for my job!"
"Maison Academy helped me refresh my PC skills after years away from the workforce. I loved the flexibility of taking classes online and still getting personal attention. Highly recommend!"
"I wanted to improve my tech skills to help run my small business. The one-on-one sessions were super helpful and tailored to what I needed. Learning in English and Spanish was a plus!"
"At 56, I wasn’t sure if going back to class made sense, but Maison Academy made it easy. The instructor worked with my pace, and now I feel much more confident using my computer for everyday tasks. It’s never too late to learn."
