522.7K
MOMohim now offers live Excel classes from beginner to advanced levels, designed to help you elevate your career. It's more than just learning a new skill; it's about gaining a competitive advantage. Your CV will stand out with all the completed projects. These classes will also improve your communication skills, expand your knowledge, and equip you to confidently take on more challenging roles.
It's strange how only 1% of people will benefit from this opportunity
Course Structure
Duration: 1 Month (october)
Frequency: Saturdays and Sundays
Class Duration: 3-4 hours per day
Week 1: Excel Basics
♥️Saturday:
Introduction to Excel Interface: Ribbon, Tabs, Groups
Cell References: Relative, Absolute, Mixed
Data Entry and Editing: Formatting, AutoFill, Flash Fill
Basic Formulas: SUM, AVERAGE, COUNT, MIN, MAX
♥️Sunday:
Functions: IF, VLOOKUP, HLOOKUP
Data Validation: Drop-down lists, Data Entry Restrictions
Charts: Basic Chart Types, Customization
Week 2: Intermediate Excel
♥️Saturday:
PivotTables: Creating, Analyzing Data
Conditional Formatting: Highlight Cells, Data Bars, Color Scales
Data Sorting and Filtering: Advanced Filters, Sorting Options
♥️Sunday:
Lookup Functions: INDEX, MATCH, XLOOKUP
Data Analysis ToolPak: Descriptive Statistics, Regression
Week 3: Advanced Excel
♥️Saturday:
Macros: Recording, Editing, Running Macros
Power Query: Data Cleaning, Transformation, Loading
Data Modeling: Creating Relationships, Measures
♥️Sunday:
Power Pivot: Building Data Models, Creating Calculations
Power BI Integration: Connecting Excel to Power BI
Week 4: Excel Projects and Review
♥️Saturday:
Project 1: Sales Analysis Dashboard (using PivotTables, Charts, Conditional Formatting)
Project 2: Inventory Management System (using VLOOKUP, Data Validation)
♥️Sunday:
Project 3: Financial Forecasting (using Data Analysis ToolPak,
#dataanalytics #accounting #business #girlboss #hustle #success #excel #microsoft #learningathome #free #education #microsoft #microsoftexcel #microsoftword
@mominarahim20
