What is Microsoft Excel | 02:29
How do I get Microsoft Excel | 03:58
How do I open Microsoft Excel | 02:13
Cell, Worksheets and Workbooks | 09:05
The Ribbon Toolbar | 09:30
Selecting Cells and The Name Box | 11:03
Altering Rows and Columns | 10:20
Borders | 09:06
Revision: Times Table Square | 08:07
Exploring Data Types | 11:47
Formatting Data | 14:49
Creating a Series | 07:52
Creating Formulae | 11:22
Formulae and Autofill (Relative Addressing) | 12:27
Resolving Relative Addressing Issues (Absolute Addressing) | 13:27
Formatting Cells | 09:55
Revision: Times Table Square | 07:49
Protecting Worksheets | 10:22
Restricting Data in Cells | 05:16
Creating Lists | 04:07
Adding and Deleting Rows and Columns | 05:21
Conditional Formatting | 10:05
Introducing Functions – MOD | 12:41
Revision: Times Table Square | 20:59
Introducing Battleships | 13:13
The IF Function | 10:00
The COUNTIF Function | 02:09
The COUNTA Function | 02:34
Nested IFs | 08:02
The SUM Function | 05:51
Named Ranges | 06:09
Revision: Battleships | 18:44
3D Formulae | 02:36
Shapes | 03:36
Images | 09:52
Revision: Battleships | 13:48
Revision: Battleships | 17:54
Using CSV files | 15:47
Exporting Data into a CSV file | 08:04
Issues with CSV files | 08:35
Importing CSV files Using the Legacy Wizard | 08:38
The AVERAGE Function | 14:42
The MEDIAN Function | 10:07
The MODE Function | 05:58
The MODE.SNGL Function | 03:01
The MODE.MULT function | 04:37
Revision: Gradebook | 14:29
The VLOOKUP Function | 11:32
The HLOOKUP Function | 04:49
The MAX and MIN Functions | 02:09
The RAND and RANDBETWEEN Functions | 07:26
The INDEX Function | 01:58
The MATCH Function | 05:00
Filters| 05:07
Revision: Gradebook | 11:51
The SUMIF Function | 03:15
The SUMIFS Function | 05:16
Working with Dates | 05:26
Working with Text | 03:45
Simple Bar Graphs | 06:14
Pie Charts | 03:50
Scattergraphs | 18:00
Scattergraphs 2 | 13:12
Manipulating Text | 12:23
More Manipulating Text | 17:00
Importing Data from the Web | 07:53
Creating Test Data Pt. 1 | 22:17
Creating Test Data Pt. 2 | 19:05
Developing a Budget Spreadsheet | 28:49
Continuing the Budget Spreadsheet | 21:56
Revision: Astronomical Modeling Pt. 1 | 21:24
Revision: Astronomical Modeling Pt. 2 | 23:39
Revision: Astronomical Modeling Pt. 3 | 27:56
Revision: Astronomical Modeling Pt. 4 | 05:32
UNIQUE and Spills | 09:07
The IFS Function | 08:58
The MAXIFS Function | 02:21
The MINIFS Function | 01:09
The SWITCH Function | 02:33
The SORT Function | 02:55
The XMATCH Function | 08:22
The LET Function | 03:30
The XLOOKUP Function | 04:20
The FILTER Function | 02:11
The SORTBY Function | 02:12
The SEQUENCE Function | 05:53
Revision: Combining Functions | 11:27
The RANDARRAY Function | 07:48
Text to Columns | 01:27
Zooms and Sheet Selections | 02:21
Logical Functions | 10:09
ODDs and EVENs | 06:47
Trigonometry | 10:06
Ceilings and Floors | 06:07
Reviewing all our Learning | 06:24
Welcome to Data Visualization | 00:47
Introduction to the Course | 03:07
Introducing Conditional Formatting | 07:52
Highlight Cell Rules | 19:08
Top/Bottom Rules | 09:52
Data Bars | 04:57
Colors Scales | 03:42
Icon Sets | 04:22
Create, Clear or Manage Rules | 08:44
Revision | 07:19
Practice Project A: Academic Report | 26:19
Introducing Charts & Graphs | 07:39
Tables vs Charts & Graphs | 16:32
Sparklines | 21:37
Mini Charts | 11:44
Revision | 05:42
Practice Project B: Gantt Chart | 26:13
Understanding the Need | 09:06
Chart Area | 07:10
Plot Area | 04:38
Axes | 13:14
Axes Titles | 06:37
Chart Title | 04:01
Data Labels | 08:01
Data Table | 06:31
Error Bars | 13:11
Gridlines | 05:38
Legend | 08:32
Trendlines | 09:24
Altering Styles | 04:18
Altering Colors | 02:56
Data Sources | 08:18
Data Series | 06:08
Revision | 10:18
Quick Quiz A: 10 MCQs | 09:58
Column or Bar Charts (Comparisons) | 30:57
Line or Area Charts (Trends) | 24:12
Pie or Doughnut Charts (Proportions) | 22:04
Scatter or Bubble Chart (Relationships) | 29:29
Histograms or Box & Whisker (Statistical Analysis) | 30:33
Treemap or Sunburst (Hierarchies) | 29:11
Revision | 15:53
Practice Project C: Daily Activity Tracker | 36:52
Combo Charts (Mixed Data) | 25:38
Waterfall (Popular Demand) | 15:42
Funnel (Stages of a Process) | 21:33
Stock (Fluctuations) | 18:03
Surface (Multidimensional Data) | 17:15
Radar (Skewness) | 11:40
Revision | 16:50
Quick Quiz B: 10 MCQs | 10:17
Choosing the Right Rules | 17:30
Choosing the Right Charts | 14:25
Revision | 05:52
Quick Quiz C: 10 MCQs | 09:44
The Concept | 07:32
Pivot Tables | 13:37
Pivot Charts | 07:59
Slicers & Timelines | 11:50
Dashboard Design Decisions | 05:59
Revision | 10:42
Practice Project D: KPI Dashboard | 30:45
Practice Project E: Investment Dashboard | 44:38
2D or Filled Maps | 16:22
3D Maps | 48:28
Revision | 10:52
Quick Quiz D: 10 MCQs | 09:50
Permissions | 06:59
Bing Maps | 05:19
Viso Data Visualizer | 13:52
People Graph | 07:01
QR4 Office | 09:32
Mini Calendar & Date Picker | 12:00
Web Video Player | 10:22
Colorizer | 10:53
Places | 06:25
Revision | 16:55
Quick Quiz E: 10 MCQs | 09:54
The Big Picture | 04:48
Cell References | 10:02
Naming Cells | 07:47
Adjusting Cell Width & Height | 04:48
Freezing or Spliting Panes | 10:01
Grouping Data | 09:26
Drop Downs | 09:30
Adjusting Chart Location & Position | 09:10
Adjusting Chart & Cell Connections | 08:01
Switching Views | 05:10
Linking Data between Sheets | 05:49
Printing Options | 21:18
Sharing | 07:19
Exporting | 09:20
Revision | 08:01
Practice Project F: Web Analytics Report | 08:26
Quick Quiz F: 5 MCQs | 05:46
Welcome to Data Analysis | 00:54
Introduction to the Course | 10:31
Instructor’s Introduction | 01:51
Table Organization | 22:58
Primary Keys | 14:53
Conditioning Data | 31:21
Checking Data Through Functions | 30:59
Nesting Formulas | 24:25
Array Formulas | 25:30
Introduction of Overarching Dataset and Setting a Framework | 16:53
Data Analysis Framework | 26:54
Baseline Analysis | 01:10:51
Overarching Project Introduction | 22:38
Introduction to Pivot Tables | 08:57
Pivot Table Functions and Basic Pivots | 24:30
Pivot Tables with Overarching Project | 40:45
Pivot Practice | 15:20
Introduction to Power Query | 17:48
Using Power Query | 50:04
Power Query with Overarching Project | 27:36
Power Query Practice | 18:33
Introduction to Power Pivot | 08:52
Using Power Pivot | 01:06:10
Power Pivot with Overarching Project | 01:01:46
Power Pivot Practice | 23:05
Introduction to Dynamic Array Formulas | 19:49
Using Dynamic Array Formulas | 02:20:38
Dynamic Array Formulas with Overarching Project | 43:08
Dynamic Array Formulas Practice | 51:23
Introduction and Preparation for Predictive Analysis | 07:40
Using Predictive Analysis | 36:13
Excel’s Predictive Shortcuts | 12:57
Gcode Extraction | 18:46
House Budgeting with Power Pivot | 55:16
Budgeting with Power Pivot | 01:10:08
Budgeting with Power Query | 53:00
Analysis and Logic Trap Exercise | 01:16:54
Capstone Project Introduction | 07:30
Capstone Project by Formulas | 01:01:00
Capstone Project by Pivot Tables | 48:07
Capstone Project by Power Query | 02:23:46
Capstone Project by Power Pivot | 38:10
Capstone Project by Dynamic Array Formulas | 55:24
Course Conclusion | 01:03
Welcome to Excel Programming | 00:54
Introduction | 00:55
What is Programming and VBA? | 17:26
Object Oriented Programming | 04:03
Introduction to Recording Macros | 26:18
Introduction | 00:30
Drop-Down Menus in VBA Part I | 13:17
Drop-Down Menus in VBA Part II | 34:54
Introduction | 00:40
MsgBox, Introduction to Workbook and Worksheet | 21:45
Workbooks.Open Statements | 22:57
Workbooks.Save and Worksheets | 21:19
Customize Toolbar and Ribbons | 08:54
What is a Variable | 18:01
Using Variables to Perform Basic Math Functions | 21:11
Introduction to Additional Data Types | 13:33
VBA Tips and Tricks Part I | 19:12
VBA Tips and Tricks Part II | 13:10
Data Types Additional Information | 23:24
Variables Continued | 14:14
Call Procedure | 16:23
Workbooks.Name, Workbook.Clear and Workbook.Close | 11:38
Public and Private Procedures | 07:03
Introduction to Constants | 12:41
Row.Offset and Exit Sub | 13:24
Data Types Additional Information | 23:24
Variables Continued | 14:14
Application Object Part I | 12:08
Application Object Part II | 08:29
Object.Count, .Path and more VBA Tips and Tricks | 08:49
Workbooks.Add, Workbooks.Close | 36:13
Workbook.Activate, .Open and .Close | 18:04
Worksheet.Visible, .Copy, .Delete | 20:59
Last Words | 00:31
