Excel 2016 Advanced Tutorial

Excel 2016 Advanced Tutorial

For ad free training and certificates please join Learnit Anytime:
https://www.learnitanytime.com

For Private Group Trainings please visit:
https://www.learnit.com/private-group...

Join our online community! - https://www.offsitebylearnit.com

Exercise Files: https://bit.ly/2S67Byv

Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password

Start 0:00
Named Ranges 0:03
Creating Named Ranges from Selection  5:24
Named Ranges (Continued) 8:31
IF Functions 11:15
Formula Auditing Tools 19:26
IF Functions (Continued) 26:05
Nesting Functions 30:51
VLOOKUP 38:42:19
Autofill VLOOKUP & IFERROR 47:20
VLOOKUP Range 54:01
VLOOKUP Range with Nested Functions 59:31
HLOOKUP 1:07:27
SUMIF 1:11:17
AVERAGEIF 1:19:20
SUMIFS 1:23:12
Date Functions 1:27:47
Text Functions 1:34:27
Consolidating Data 1:41:00
Consolidating Data Without Structure 1:45:28
Complex Solver Tool 1:48:27
Solver Tool 1:54:09
Scenario Manager 2:02:11
Data Table 2:09:38
Turning on the Developer Tab 2:16:08
Recording Macros 2:18:18
Editing Macros in VBA & Recording a Second Macro 2:23:46
Adding Macros to the QA Toolbar 2:31:27
Adding Macro Buttons to the Worksheet 2:33:46
Conclusion 2:36:52

#Excel