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,765 Reviews
168,522 Students
34 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Expires in 3 days
SAP MM Public Cloud Stock Transfer E2E Process
A Complete Guide to Stock Transfers and Stock Transport Orders in SAP MM Public Cloud
Free 100% Off
Yesterday
Expires in 3 days
Complete Microsoft Office Word Excel PowerPoint Google Sheet
All in One Microsoft Office and Google Sheets Course Learn Word, Excel, PowerPoint and Google Sheet…
Free 100% Off
Yesterday
Expires today
Associate Professional Risk Manager APRM Certificate
Risks, Risk Management, Definitions and Concepts, Strategic, Financial, Operational, Compliance, an…
Free 100% Off
Yesterday
Expires in 2 days
Microsoft Excel - The Complete Excel Data Analysis Course
Microsoft Excel - The Complete Excel Data Analysis. Learn Basic to Advanced Excel Data Analysis & V…
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.