Master Excel & Google Sheets: Formulas & Functions Pro 2024
Focused View
3:44:17
1 -Understanding Formulas and Functions.mp4
05:14
1 -Basic Arithmetic Operations.mp4
04:42
2 -Writing and Editing Formulas.mp4
03:40
3 -Using Cell References Relative, Absolute, Mixed.mp4
04:18
4 -SUM, AVERAGE, MIN, MAX.mp4
04:03
5 -COUNT and COUNTA Functions.mp4
03:05
6 -IF Function and Conditional Logic.mp4
07:33
7 -CONCATENATE and TEXTJOIN Functions.mp4
04:59
8 -LEFT, RIGHT, MID Functions.mp4
07:37
9 -DATE, TODAY, and NOW Functions.mp4
03:05
10 -Formatting Dates and Times.mp4
03:24
11 -VLOOKUP and HLOOKUP Functions.mp4
07:15
12 -INDEX and MATCH Functions.mp4
06:02
13 -Using Named Ranges for Enhanced Readability.mp4
07:10
14 -SUMIF, SUMIFS, COUNTIF, COUNTIFS.mp4
07:13
15 -Statistical Analysis with Functions MEDIAN, MODE, STDEV, etc.mp4
06:07
16 -Analyzing Data Distributions and Variability.mp4
04:14
17 -Nested Functions and Formula Nesting.mp4
04:41
18 -Array Formulas for Complex Calculations.mp4
05:48
19 -Financial Functions PV, FV, NPV, IRR.mp4
08:31
20 -Summarizing Data with PivotTables.mp4
04:56
21 -Filtering and Analyzing Data with Slicers.mp4
06:57
22 -Introduction to Power Query for Data Transformation.mp4
04:49
23 -Integrating Power Query Results with Excel Functions.mp4
06:18
24 -Formula Auditing and Error Handling.mp4
07:15
25 -Using Trace Precedents and Dependents.mp4
04:46
26 -Error Checking and Correction Techniques.mp4
03:01
27 -Optimizing Formulas for Performance.mp4
09:23
28 -Using Excels Formula AutoComplete Feature.mp4
04:52
29 -Utilizing Keyboard Shortcuts for Formula Writing.mp4
07:32
30 -Customizing Excels Calculation Options.mp4
05:42
1 -Math Functions (SUM, AVERAGE, MAX, MIN, COUNT ).mp4
05:29
2 -Logical Functions (AND, OR IF).mp4
05:26
3 -Text Functions (LOWER, UPPER, CONCATENATE, PROPER).mp4
05:20
4 -Left and Right (LEFT, RIGHT).mp4
03:40
5 -Line, Area, Bar & Pie Charts in Google Sheets.mp4
04:54
6 -VLOOKUP & HLOOKUP.mp4
05:28
7 -XLOOKUP.mp4
07:41
8 -Data Import (Web and HTML Table).mp4
06:28
9 -Macros.mp4
05:39
More details
Course Overview
Become proficient in Excel and Google Sheets by mastering essential formulas, functions, and data analysis techniques to enhance productivity and gain valuable insights from your data.
What You'll Learn
- Master key formulas like VLOOKUP, INDEX-MATCH, and financial functions
- Analyze data with PivotTables, statistical functions, and array formulas
- Automate workflows using Power Query, macros, and advanced nesting
Who This Is For
- Beginners looking to build strong spreadsheet skills
- Professionals aiming to boost productivity
- Analysts seeking advanced data manipulation techniques
Key Benefits
- Save hours with faster calculations and automation
- Make data-driven decisions with confidence
- Master both Excel and Google Sheets workflows
Curriculum Highlights
- Core functions: SUM, COUNTIFS, text manipulation
- Advanced lookup methods and named ranges
- Data visualization and Power Query integration
Focused display
Category
- language english
- Training sessions 40
- duration 3:44:17
- Release Date 2025/05/12
