Skip to content

Home
About
Courses
Blog

Log in Get started

Search for:

Kmacims EAT

Home
About
Courses
Services
Blog
Contact

Log in Get started

Course: Microsoft Excel Foundations: From Zero to Spreadsheet Hero

Course content

📄 Conclusion

▶ What is Microsoft Excel? Its uses and new features

📄 Getting Started with Excel

▶ Checking for Spelling Errors

▶ Understanding the Purpose of Different Chart Types (Bar, Pie, Line)

▶ Inserting, Deleting, Renaming, Moving, and Hiding Worksheets

▶ Creating Basic Formulas: Addition, Subtraction, Multiplication, Division

▶ Entering and Editing Data: Text, Numbers, and Dates

▶ Opening Excel Workbook

📄 Capstone Project 1: Comprehensive Sales & Expense Dashboard

▶ Using Autofill and the Fill Handle to Populate Data Quickly

▶ Understanding Operator Precedence (BODMAS)

▶ Modifying Column Width and Row Height

▶ Creating a Basic Chart from Your Data

▶ Setting the Print Area and Using Page Layout View

📄 Entering and Formatting Data

📄 Performing Essential Calculations

📄 Module 6 Activity: Preparing a Client Report for Printing

▶ Simple Chart Customization: Adding Chart Titles and Data Labels

▶ Basic Data Management: Sorting Data and Applying Simple Filters

▶ Applying Number Formats (Currency, Percentage, Accounting)

📄 Capstone Project 2: Employee Performance Tracker

▶ Navigating the Excel Interface: The Ribbon, Formula Bar, and Quick Access Toolbar

▶ Using Core Functions: SUM, AVERAGE, COUNT, MIN, MAX

▶ Understanding Workbooks, Worksheets, Cells, Rows, and Columns

▶ Formatting Cells: Fonts, Colors, Borders, and Alignment

▶ Understanding Relative and Absolute Cell References

▶ Using Find and Replace

▶ Moving and Resizing Charts within Your Worksheet

📄 Managing Worksheets and Data

▶ Creating, Opening, and Saving Your First Excel Workbook

📄 Visualizing Data with Charts

▶ Using Merge & Center and Wrap Text for a Better Presentation

📄 Module 5 Activity: Creating Sales Performance Dashboards

📄 Module 4 Activity: Managing an Inventory List and Filtering Orders

📄 Module 3 Activity: Analyzing Monthly Sales Data

📄 Module 1 Activity: Setting Up Your First Departmental Budget

▶ Applying Styles using Format as Table

📄 Finalizing and Printing Your Work

📄 Module 2 Activity: Creating an Employee Contact List

📄 Conclusion

Managing Worksheets and Data

Please log in to access this lesson.

Log in

Ready to grow your skills or business?

Join thousands of students and clients who trust Kmacims EAT.

Browse courses Hire us

Learn. Build. Transform.

About
Terms of Service
Privacy Policy

Turn Your Ambition Into Action — Let’s Make It Happen.

Quick links

Our courses

Learn Python for Young Minds: A Fun Coding Quest to Build Games and Apps
Python Mastery: Interactive Coding Adventure for Beginners
Scratch Programming Tutorial: Visual Block Coding for Kids and Beginners
Microsoft Word for Beginners: From Blank Page to Polished Document
Microsoft Excel Foundations: From Zero to Spreadsheet Hero
View all courses →

Services

Web development
Data analysis
Online courses
Marketplace
Contact us

Stay in the loop

Get course updates, new articles, and exclusive offers.

Email address

Privacy policy
Terms of use
Cookies