Google Sheets Masterclass The Power of Excel and Analysis

Files Included :

1 - Introduction.mp4 (21.21 MB)
MP4
2 - Getting started on Windows macOS Android and IOS.mp4 (6.76 MB)
MP4
3 - How to ask great questions.mp4 (7.38 MB)
MP4
4 - FAQs.mp4 (6.46 MB)
MP4
50 - Collaboration and Sharing files.mp4 (62.19 MB)
MP4
51 - Publishing Sheet or chart to Link in a web page.mp4 (38.08 MB)
MP4
52 - Publishing Sheet or chart to Embedding in a web page.mp4 (38.44 MB)
MP4
53 - Email Google Sheets or chart.mp4 (26.49 MB)
MP4
54 - Prepare for Print or PDF with page breaks.mp4 (37.87 MB)
MP4
55 - Protect a sheet or range.mp4 (38.44 MB)
MP4
56 - Use Google Forms to collect realtime data.mp4 (43.14 MB)
MP4
57 - Exercise and Solution for PDF layout.mp4 (37.37 MB)
MP4
58 - Chart Basics Column and Line Charts.mp4 (31.25 MB)
MP4
59 - Aggregating Data in Charts Bar and Pie Charts.mp4 (46.22 MB)
MP4
60 - Combo charts.mp4 (22.95 MB)
MP4
61 - Gauge chart.mp4 (48.5 MB)
MP4
62 - Table chart.mp4 (23.03 MB)
MP4
63 - Scorecard chart for KPI Dashboards.mp4 (18.67 MB)
MP4
64 - Adding Slicers to charts.mp4 (28.19 MB)
MP4
65 - Sparklines chart.mp4 (43.93 MB)
MP4
66 - Sparklines for Stock and Currency.mp4 (29.99 MB)
MP4
67 - Geo charts.mp4 (23.38 MB)
MP4
68 - Explore Pivot Features in Google Sheets.mp4 (44.45 MB)
MP4
69 - Pivot Table Basics in Google Sheets.mp4 (28.33 MB)
MP4
70 - Use Filters and Slicers for Dynamic Pivot Tables.mp4 (36.19 MB)
MP4
71 - Grouping items and datesMonthYear.mp4 (36.59 MB)
MP4
72 - Custom Formulas in Pivot Tables.mp4 (28.76 MB)
MP4
73 - INDEX MATCH for complex lookups.mp4 (27.97 MB)
MP4
74 - ARRAYFORMULA function.mp4 (30.12 MB)
MP4
75 - Create your own Arrays and Make totals.mp4 (16.98 MB)
MP4
76 - INDIRECT Function Lookup.mp4 (19.28 MB)
MP4
77 - Create Random Data and Text.mp4 (11.93 MB)
MP4
78 - SEQUENCE Function.mp4 (23.19 MB)
MP4
79 - QUERY Function Basics.mp4 (39.69 MB)
MP4
80 - QUERY Function using Select and Where.mp4 (71.99 MB)
MP4
81 - QUERY Function for Aggregation.mp4 (33.7 MB)
MP4
82 - Group By Multiple Columns.mp4 (41.54 MB)
MP4
83 - Transform Distinct Values using PivotQuery Function.mp4 (20.86 MB)
MP4
84 - Aggregates and Sorting using Order by clause.mp4 (31.21 MB)
MP4
85 - QUERY Function for Dynamic Totals.mp4 (45.4 MB)
MP4
86 - QUERY Function to Combine Data from Multiple Sheets.mp4 (28.27 MB)
MP4
87 - QUERY Function with IMPORTRANGE to Combine External Sheets.mp4 (36.46 MB)
MP4
88 - Import Tables from the WebIMPORTHTML.mp4 (34.76 MB)
MP4
89 - Import any structured data from WebIMPORTXML.mp4 (21.25 MB)
MP4
90 - Insert Image on Google Sheets.mp4 (28.28 MB)
MP4
91 - Generate QR Code on Required data.mp4 (36.16 MB)
MP4
10 - Language and Spreadsheet settings.mp4 (57.43 MB)
MP4
11 - Version recovery and edit History.mp4 (18.23 MB)
MP4
5 - Sheets Basics to start.mp4 (79.7 MB)
MP4
6 - Cells Rows and Columns.mp4 (48.4 MB)
MP4
7 - Productivity Tips and File Sharing.mp4 (51.33 MB)
MP4
8 - Menu and Toolbar options.mp4 (47.18 MB)
MP4
9 - Save and print in Sheets.mp4 (19.54 MB)
MP4
12 - Data Types.mp4 (40.36 MB)
MP4
13 - Data Entry.mp4 (37.05 MB)
MP4
14 - Autofill in sheets.mp4 (25 MB)
MP4
15 - Data handling basics copy cut and paste.mp4 (29.18 MB)
MP4
16 - Common functionalities in sheets.mp4 (37.64 MB)
MP4
17 - Regular Functions in Google Sheets sum average counta and countunique.mp4 (88.07 MB)
MP4
18 - Relative Vs Absolute referencing.mp4 (40.87 MB)
MP4
19 - Useful tools and Report design.mp4 (18.02 MB)
MP4
20 - Split Text into columns.mp4 (25.2 MB)
MP4
21 - Conditional formatting.mp4 (33.32 MB)
MP4
22 - Create Dropdown lists from data.mp4 (36.38 MB)
MP4
23 - Data Validations.mp4 (37.12 MB)
MP4
24 - Importing TXT data files into Google Sheets.mp4 (62.74 MB)
MP4
25 - Importing CSV data files into Google Sheets.mp4 (44.66 MB)
MP4
26 - Getting Data from Other Google Sheets.mp4 (30.74 MB)
MP4
27 - Sort Features.mp4 (26.64 MB)
MP4
28 - Filter and Filter view in Sheets.mp4 (39.13 MB)
MP4
29 - Filtered ResultsSubTotal.mp4 (39.79 MB)
MP4
30 - Remove Duplicates.mp4 (33.26 MB)
MP4
31 - Trim White Spaces.mp4 (36.46 MB)
MP4
32 - Find and Replace Data.mp4 (36.53 MB)
MP4
33 - Unique and Sort Functions.mp4 (45.92 MB)
MP4
34 - SUMIFS applying on COUNTMIN MAX.mp4 (113.76 MB)
MP4
35 - Logical Functions.mp4 (52.42 MB)
MP4
36 - IF Function IF Then.mp4 (34.67 MB)
MP4
37 - Nested IF and IFS Functions.mp4 (67.12 MB)
MP4
38 - Named Ranges.mp4 (27.56 MB)
MP4
39 - Rounding Values.mp4 (21.11 MB)
MP4
40 - VLOOKUP Function.mp4 (42.88 MB)
MP4
41 - HLOOKUP Function.mp4 (25.53 MB)
MP4
42 - HLOOKUP Match formula.mp4 (44.24 MB)
MP4
43 - XLOOKUP Function.mp4 (32.43 MB)
MP4
44 - Handling NA and Approximates match in XLOOKUP.mp4 (42.08 MB)
MP4
45 - Basic Text Functions.mp4 (44.04 MB)
MP4
46 - Split and Join Data from multiple columns.mp4 (25.69 MB)
MP4
47 - Search and SUBSTITUTE.mp4 (44.11 MB)
MP4
48 - Date Time Functions.mp4 (32.37 MB)
MP4
49 - Time Calculationsworked hours.mp4 (28.86 MB)
MP4