Learn Advanced Excel Techniques - Data Analysis and Reporting Made Easy
What you'll learn Cell formatting Working with sheets Functions - structure & most used Graphs Analysis Pivot table & pivot graph Ordering, Filtering, Advanced filter Subtotals Scenario, Data table, Sum of the scenario Verification & Control Import Macro - record and use
Requirements No programming experience needed
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/1 - Introduction/1 - Introduction.mp4
33.1 MB
~Get Your Files Here !/1 - Introduction/2 - Info.html
171 B
~Get Your Files Here !/2 - Starting/10 - Text orientation.mp4
20.8 MB
~Get Your Files Here !/2 - Starting/11 - Simple graph.mp4
65 MB
~Get Your Files Here !/2 - Starting/12 - Page formatting.mp4
71.5 MB
~Get Your Files Here !/2 - Starting/13 - Repeat header when printing.mp4
31.3 MB
~Get Your Files Here !/2 - Starting/14 - Conditional formatting.mp4
85.6 MB
~Get Your Files Here !/2 - Starting/15 - Split hide.mp4
58.4 MB
~Get Your Files Here !/2 - Starting/3 - Adding highlighting.mp4
30.1 MB
~Get Your Files Here !/2 - Starting/4 - Mass insertion.mp4
32.9 MB
~Get Your Files Here !/2 - Starting/5 - Adding cols rows freezing.mp4
71.7 MB
~Get Your Files Here !/2 - Starting/6 - Basic formatting.mp4
21.4 MB
~Get Your Files Here !/2 - Starting/7 - Basic functions.mp4
96.7 MB
~Get Your Files Here !/2 - Starting/8 - Own formulas with relative addressing.mp4
74.5 MB
~Get Your Files Here !/2 - Starting/9 - Absolute Addressing.mp4
107.9 MB
~Get Your Files Here !/3 - Functions/16 - Dates.mp4
63.7 MB
~Get Your Files Here !/3 - Functions/17 - Math Rounding.mp4
73 MB
~Get Your Files Here !/3 - Functions/18 - Statistic count if blank.mp4
110.9 MB
~Get Your Files Here !/3 - Functions/19 - Ranking.mp4
89.5 MB
~Get Your Files Here !/3 - Functions/20 - Text.mp4
126.5 MB
~Get Your Files Here !/3 - Functions/21 - Finance.mp4
64.8 MB
~Get Your Files Here !/3 - Functions/22 - Finance 2.mp4
60.8 MB
~Get Your Files Here !/3 - Functions/23 - Finance 3 Monthly payment Interest.mp4
73.5 MB
~Get Your Files Here !/3 - Functions/24 - Lookup.mp4
39.4 MB
~Get Your Files Here !/3 - Functions/25 - Database.mp4
103.7 MB
~Get Your Files Here !/3 - Functions/26 - Logical.mp4
57.4 MB
~Get Your Files Here !/3 - Functions/27 - Logical statement.html
352 B
~Get Your Files Here !/3 - Functions/28 - Nested.mp4
74.6 MB
~Get Your Files Here !/3 - Functions/29 - Calculate between sheets.mp4
20.5 MB
~Get Your Files Here !/4 - Analysis/30 - Graph type formatting.mp4
152.4 MB
~Get Your Files Here !/4 - Analysis/31 - Pivot table.mp4
77.3 MB
~Get Your Files Here !/4 - Analysis/32 - Pivot chart.mp4
25.6 MB
~Get Your Files Here !/4 - Analysis/33 - Data table.mp4
48.4 MB
~Get Your Files Here !/4 - Analysis/34 - Advanced sorting.mp4
53.9 MB
~Get Your Files Here !/4 - Analysis/35 - Subtotals.mp4
50.9 MB
~Get Your Files Here !/4 - Analysis/36 - Scenarios.mp4
74 MB
~Get Your Files Here !/5 - Increase Productivity/37 - Data validation.mp4
38.7 MB
~Get Your Files Here !/5 - Increase Productivity/38 - Error checking comment.mp4
53.8 MB
~Get Your Files Here !/5 - Increase Productivity/39 - Naming cells.mp4
44.8 MB
~Get Your Files Here !/5 - Increase Productivity/40 - Paste special.mp4
46.6 MB
~Get Your Files Here !/5 - Increase Productivity/41 - Import.mp4
20 MB
~Get Your Files Here !/5 - Increase Productivity/42 - Macro CreateRecord Use.mp4
35.7 MB
~Get Your Files Here !/5 - Increase Productivity/43 - Sharing adding password.mp4
20.2 MB
~Get Your Files Here !/5 - Increase Productivity/44 - Password required to edit.mp4
20.1 MB
~Get Your Files Here !/6 - Files tricks/45 - Book1.xlsx
12.3 KB
~Get Your Files Here !/6 - Files tricks/45 - First Excel Workbook.html
53 B
~Get Your Files Here !/6 - Files tricks/46 - Excel Workbook to calculate between more sheets.html
61 B
~Get Your Files Here !/6 - Files tricks/46 - SecondSample.xlsx
13.5 KB
~Get Your Files Here !/6 - Files tricks/47 - MySample.xlsx
90.6 KB
~Get Your Files Here !/6 - Files tricks/47 - Third MySample.html
47 B
~Get Your Files Here !/6 - Files tricks/48 - mySampleData.txt
361 B
~Get Your Files Here !/6 - Files tricks/48 - Text file To convert.html