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 knowledge required
- A computer with internet access
- Eagerness to learn
Who This Course is For
- Anyone interested in becoming a proficient Excel and Google Sheet user.
Your Instructor
Experienced Instructor
Professional Educator
An experienced instructor with expertise in this field and a passion for teaching.
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Limited Time
MS Excel Masterclass for Job Seekers Accounting Success
A Comprehensive Masterclass for Job Seekers Focused on Accounting, Data Analysis, and Essential Exc…
Free 100% Off
Today
Limited Time
Microsoft Excel Training - Beginner to Expert Level in Hindi
Master Microsoft Excel, including logical statements, advanced functions, data formatting, VBA macr…
17.99$ None% Off
Today
Limited Time
Google Cloud Productivity: Docs, Forms, Sheets and Slides
Boost productivity with Google Cloud: Master Docs, Forms, Sheets, and Slides in this all-in-one ess…
Free 100% Off
Today
Limited Time
Mastering Microsoft PowerPoint: Create Stunning Presentation
Create Stunning Presentation with PowerPoint- Utilize Charts, Graphs, and SmartArt to Present Data …
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.