What You'll Learn
- Understanding Excel & Google sheet Formulas & Functions
- User Interface Overview
- Basic Arithmetic Operations
- Using Cell References: Relative, Absolute, Mixed
- SUM, AVERAGE, MIN, MAX
- COUNT and COUNTA Functions
- CONCATENATE and TEXTJOIN Functions
- Formatting Dates and Times
- VLOOKUP and HLOOKUP Functions
- INDEX and MATCH Functions
- Using Named Ranges for Enhanced Readability
- Statistical Analysis with Functions: MEDIAN, MODE, STDEV, etc.
- Analyzing Data Distributions and Variability
- Nested Functions and Formula Nesting
- Array Formulas for Complex Calculations
- Financial Functions: PV, FV, NPV, IRR
- Summarizing Data with PivotTables
- Filtering and Analyzing Data with Slicers
- Introduction to Power Query for Data Transformation
- Integrating Power Query Results with Excel Functions
- Error Checking and Correction Techniques
- Utilizing Keyboard Shortcuts for Formula Writing
Requirements
- No Prior Excel and Google Sheets Knowledge is Needed.
Who This Course is For
- Anyone interested in becoming a proficient Excel and Google Sheet user.
Your Instructor
Click Learning
Instructor at Udemy
4.1 Instructor Rating
4,443 Reviews
158,395 Students
34 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Yesterday
Limited Time
Office Productivity
English
Excel Data Analysis With Pivot Tables & Pivot Charts - 2025
Data analysis excel, data analysis, Pivot Chart, Microsoft excel, advanced excel, ms excel, Data An…
Free 100% Off
Yesterday
Limited Time
Office Productivity
English
Google Sheets at work : Impress Your Boss with Smart Works
MS Excel, Spread sheets , Microsoft Excel , G sheets , google spreadsheet, Google Workspace (G Suit…
Free 100% Off
Yesterday
Expires in 3 days
Office Productivity
Arabic
Microsoft Project from Zero to Pro بروجكت من الصفر للاحتراف
كورس مايكروسوفت بروجكت الكامل بالعربية
Free 100% Off
Yesterday
Expires in 3 days
Office Productivity
English
Mastering Power BI Report Design - Beginner to Advanced
A Full Guide to Creating Insightful Reports, Interactive Dashboards, and Effective Data Storytellin…
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.