Microsoft Excel 101 – The Ultimate Beginner’s Workshop
Microsoft Excel 101 – The Ultimate Beginner’s Workshop, Microsoft Excel is a widely used tool, but many beginners find it intimidating.
Course Description
Starting with Microsoft Excel can feel confusing—but it doesn’t have to be. This beginner-friendly course guides you through the core features of Excel in a clear, simple way. You’ll learn how to navigate the interface, enter and format data, use basic formulas, and create charts. Each lesson is practical and hands-on, helping you apply Excel to real-life academic, work, or personal tasks.
By the end of the course, you’ll be comfortable using Excel and ready to handle everyday spreadsheet needs with confidence.
What You’ll Learn?
- Navigate the Excel interface and understand key features like the Ribbon
- Enter and format text, numbers, and dates
- Use simple formulas and functions to calculate values
- Sort and filter data to stay organized
- Create clear, easy-to-read charts
- Save, print, and share Excel files professionally
Course Curriculum
Module 1: Getting Started with Excel Build your foundation by learning the layout and basic functions of Excel.
- Lecture 1: Understanding the Excel Interface
- Lecture 2: Creating, Opening, and Saving Workbooks
Module 2: Entering and Formatting Data Learn to work with different types of data and format it for better presentation.
- Lecture 3: Entering Data – Text, Numbers, and Dates
- Lecture 4: Formatting Cells – Font, Colors, and Borders
- Lecture 5: Adjusting Column Width, Row Height, and Cell Alignment
Module 3: Basic Formulas and Functions Use Excel to perform calculations and summarize information quickly.
- Lecture 6: Writing Basic Formulas (+, –, ×, ÷)
- Lecture 7: Essential Functions – SUM, AVERAGE, MIN, MAX
- Lecture 8: Using AutoSum for Quick Calculations
Module 4: Organizing and Sorting Data Learn how to manage and clean up your data effectively.
- Lecture 9: Sorting Data Alphabetically and Numerically
- Lecture 10: Filtering Data to Show Specific Information
- Lecture 11: Using Tables to Structure Data
Module 5: Creating Simple Charts Turn data into visual insights using basic charting tools.
- Lecture 12: Choosing the Right Chart for Your Data
- Lecture 13: Creating and Customizing Bar and Pie Charts
Module 6: Saving, Printing, and Sharing Excel Files Wrap up your work professionally and collaborate with others.
- Lecture 14: Saving in Different Formats (Excel, PDF, CSV)
- Lecture 15: Printing Excel Sheets with Proper Formatting
- Lecture 16: Sharing Workbooks and Collaborating
Who This Course Is For?
- Absolute beginners who want a step-by-step introduction to Excel
- Students who need Excel for class assignments or research
- Professionals looking to build confidence with spreadsheets
- Anyone who wants to simplify data handling and reporting
Certificate of Completion
Once you complete all lectures and quizzes, you’ll receive a Certificate of Completion from Eduta. It’s a great way to show your Excel skills on your resume, LinkedIn, or freelance portfolio.
