Microsoft Excel 101 - The Ultimate Beginner's Workshop

Microsoft Excel is a widely used tool, but many beginners find it intimidating. This course simplifies Excel and focuses on essential skills to help you work efficiently, whether for academic, professional, or personal use.

Course Description

Microsoft Excel is a powerful tool, but it can feel overwhelming when you’re just starting out. This course breaks it down into simple, manageable lessons. You’ll learn how to navigate Excel, enter and format data, apply basic formulas, and create simple charts. Each module builds practical skills through hands-on tasks that reflect real-world use.

By the end of the course, you’ll be confident in using Excel for academic, professional, and personal tasks.

What Will You Learn?

• How to navigate the Excel interface and understand the Ribbon

• Entering and formatting data for better organization

• Using basic formulas and functions to perform calculations

• Sorting, filtering, and structuring data efficiently

• Creating simple charts to visualize data

• Saving, printing, and sharing Excel files professionally

Course Curriculum

Module 1: Getting Started with Excel

Learn the basics of Excel, including how to navigate the interface and manage workbooks.

• Lecture 1: Understanding the Excel Interface
  Learn about the Ribbon, toolbars, and key Excel features.

• Lecture 2: Creating, Opening, and Saving Workbooks
  Learn how to create, save, and manage Excel files.

Module 2: Entering and Formatting Data

Discover how to enter and format data for better readability and organization.

• Lecture 3: Entering Data – Text, Numbers, and Dates
  Learn how to input and edit different types of data.

• Lecture 4: Formatting Cells – Font, Colors, and Borders
  Customize text appearance and improve document readability.

• Lecture 5: Adjusting Column Width, Row Height, and Cell Alignment
  Optimize your spreadsheet layout for clarity.

Module 3: Basic Formulas and Functions

Master essential formulas and functions to perform calculations efficiently.

• Lecture 6: Writing Basic Formulas (+, –, , /)
  Use mathematical operators for simple calculations.

• Lecture 7: Essential Functions – SUM, AVERAGE, MIN, MAX
  Apply basic functions for quick data analysis.

• Lecture 8: Using AutoSum for Quick Calculations
  Automate totals using Excel’s AutoSum feature.

Module 4: Organizing and Sorting Data

Learn how to structure and manage large datasets effectively.

• Lecture 9: Sorting Data Alphabetically and Numerically
  Arrange your data in ascending or descending order.

• Lecture 10: Filtering Data to Show Specific Information
  Display only the information you need.

• Lecture 11: Using Tables to Structure Data
  Convert data into structured tables for easier management.

Module 5: Creating Simple Charts

Visualize your data using Excel’s charting tools.

• Lecture 12: Choosing the Right Chart for Your Data
  Understand different chart types and when to use them.

• Lecture 13: Creating and Customizing Bar and Pie Charts
  Build and style simple charts to display your data visually.

Module 6: Saving, Printing, and Sharing Excel Files

Learn how to store, print, and share your work efficiently.

• Lecture 14: Saving in Different Formats (Excel, PDF, CSV)
  Export your Excel files in various formats.

• Lecture 15: Printing Excel Sheets with Proper Formatting
  Adjust print settings to neatly present your work.

• Lecture 16: Sharing Workbooks and Collaborating
  Learn to collaborate and share Excel files with others.

Who This Course Is For?

• Beginners who have never used Excel before

• Students needing Excel for academic projects

• Professionals developing basic spreadsheet skills

• Anyone wanting to feel confident using Excel

Certificate of Completion

Students who finish all lectures and quizzes in this course will earn a Certificate of Completion from Eduta—perfect for adding to your resume, LinkedIn profile, or client proposals.