Microsoft Excel Advanced Training - CPD Certified

Microsoft Excel Advanced Training
Microsoft Excel serves as an essential asset for global organisations. Known for its unparalleled versatility and cross-platform compatibility, Microsoft Excel is integral to data analysis and crucial business decisions.

Our Microsoft Excel Advanced Training comprises 339 targeted video lectures, totalling 33 hours of in-depth Microsoft Excel instruction.

Structured for maximum learner engagement, this Microsoft Excel course simplifies intricate subjects into concise sections and modules. Sharpen your Microsoft Excel competencies and drive data-informed decisions through our specialised Microsoft Excel training programme.

Learning Outcomes of This Microsoft Excel Advanced Training :

• Identify the core components of Microsoft Excel's interface.
• Apply values, references, and formulas in Microsoft Excel.
• Evaluate Microsoft Excel functions for specific tasks.
• Generate charts in Microsoft Excel to visualise data.
• Utilise Microsoft Excel database functions effectively.
• Implement data validation techniques in Microsoft Excel.
• Code simple VBA scripts in Microsoft Excel.
• Navigate large worksheets in Microsoft Excel efficiently.
• Formulate advanced data analysis methods using Microsoft Excel.
• Analyse data through Microsoft Excel PivotTables.

• Microsoft Excel Introduction 21:48

  • 1: Microsoft Excel : Excel from A-Z Course Intro Preview 03:20
  • 2: Microsoft Excel : What is Microsoft Excel 04:16
  • 3: Microsoft Excel : Who is This Course For 03:30
  • 4: Microsoft Excel : Microsoft Excel Marketplace 04:08
  • 5: Microsoft Excel : Excel Job Opportunities 02:43
  • 6: Microsoft Excel : Excel Job Types 03:51

• Getting Started with Microsoft Excel 21:13

  • 7: Microsoft Excel : Finding and Opening Excel 01:04
  • 8: Microsoft Excel : Excel_s Start Screen 03:15
  • 9: Microsoft Excel : Explaining the Excel Interface 02:43
  • 10: Microsoft Excel : Excel Interface Cont 01:25
  • 11: Microsoft Excel : Excel Workbook vs. Excel Worksheet 02:12
  • 12: Microsoft Excel : Saving an Excel Doc 03:33
  • 13: Microsoft Excel : Customizing the Quick Access Toolbar 02:15
  • 14: Microsoft Excel : Customizing the Excel Ribbon 03:03
  • 15: Microsoft Excel : Excel Shortcut Keys 01:43

• Values, Referencing and Formulas 30:49

  • 16: Microsoft Excel : Creating Excel Labels 02:32
  • 17: Microsoft Excel : Entering Numeric Data in Excel 03:25
  • 18: Microsoft Excel : Formatting Date Values in Excel 05:19
  • 19: Microsoft Excel : Building Basic Formulas in Excel 04:43
  • 20: Microsoft Excel : Order of Operation 06:27
  • 21: Microsoft Excel : Relative vs Absolute Cell References 07:23
  • 22: Care for a Feedback? 01:00

• Intro to Excel Functions 20:45

  • 23: Microsoft Excel : Excel Functions Explained 02:34
  • 24: Microsoft Excel : The SUM Function 07:31
  • 25: Microsoft Excel : The MIN and MAX Function 03:43
  • 26: Microsoft Excel : The AVERAGE Function 02:00
  • 27: Microsoft Excel : COUNT Functions 04:57

• Adjusting Excel Worksheets 35:01

  • 28: Microsoft Excel : Moving and Copying Data 06:45
  • 29: Microsoft Excel : Insert and Delete Rows and Columns 05:04
  • 30: Microsoft Excel : Adjusting the Width and Height of Cells 04:34
  • 31: Microsoft Excel : Hiding and Unhiding Excel Rows and Columns 04:28
  • 32: Microsoft Excel : Renaming Moving and Deleting Excel Worksheets 05:27
  • 33: Microsoft Excel : Adding Protection to Specific Cells 04:23
  • 34: Microsoft Excel : Protecting the Structure of a Workbook 02:11
  • 35: Microsoft Excel : Adding a Workbook Password to Open File 02:09

• Visually Pleasing Cell Formatting 34:00

  • 36: Microsoft Excel : Formatting Fonts and Cell Background Color 04:54
  • 37: Microsoft Excel : Adding Cell Borders 04:47
  • 38: Microsoft Excel : Formatting Data Appropriately 05:20
  • 39: Microsoft Excel : The Magic Behind Excel_s Format Painter 03:29
  • 40: Microsoft Excel : Creating Styles for Formatting Efficiency 05:55
  • 41: Microsoft Excel : Merging Cells 03:26
  • 42: Microsoft Excel : The Power of Conditional Formatting 06:09

• How to insert Images and Shapes! 18:55

  • 43: Microsoft Excel : Grab Users Attention using Illustrations 08:38
  • 44: Microsoft Excel : Customizing Icons 04:41
  • 45: Microsoft Excel : Create Compelling Graphics with SmartArt 05:36

• Visualize Data with Charts 22:23

  • 46: Microsoft Excel : The Commonly Used Column Chart 02:45
  • 47: Microsoft Excel : Changing the Chart Design 01:58
  • 48: Microsoft Excel : Formatting Elements of a Chart 06:23
  • 49: Microsoft Excel : Modifying the Data Type and Location of a Chart 06:06
  • 50: Microsoft Excel : Little Slice of Pie Charts 05:11

• Excel's Printing Options 16:07

  • 51: Microsoft Excel : Print Preview Options 04:25
  • 52: Microsoft Excel : Excels Page Layout View 06:36
  • 53: Microsoft Excel : Printing a Specific Range of Cells 02:38
  • 54: Microsoft Excel : Converting Spreadsheets to PDF Files 02:28

• Benefits of Using Excel Templates 06:44

  • 55: Microsoft Excel : Why Create an Excel Template 01:22
  • 56: Microsoft Excel : How to Create an Excel Template 05:22

• Working with Excel Datasets 35:22

  • 57: Microsoft Excel : How to Prepare Data for Analysis 04:00
  • 58: Microsoft Excel : How to Sort Data in Excel 02:37
  • 59: Microsoft Excel : Multi Level Sorting 02:33
  • 60: Microsoft Excel : Custom Sorting Datasets in Excel 02:26
  • 61: Microsoft Excel : Applying Filters to Datasets 04:44
  • 62: Microsoft Excel : Creating Subtotals within a Dataset 05:38
  • 63: Microsoft Excel : Converting Datasets into Tables 05:55
  • 64: Microsoft Excel : Finding and Removing Duplicate Values 07:29

• Excel Database Functions 30:02

  • 65: Microsoft Excel : The SUMIF Function 08:41
  • 66: Microsoft Excel : The DSUM Function 07:47
  • 67: Microsoft Excel : The DSUM Function Cont 07:06
  • 68: Microsoft Excel : The SUBTOTAL Function 06:28

• Excel Data Validation 33:22

  • 69: Microsoft Excel : What is Excel Data Validation Preview 01:55
  • 70: Microsoft Excel : Creating a Drop Down List with Data Validation Preview 07:08
  • 71: Microsoft Excel : Different Types of Data Validation 05:39
  • 72: Microsoft Excel : Adding Custom Alerts to Data Validation 06:53
  • 73: Microsoft Excel : Creating a Dynamic Drop Down List 03:09
  • 74: Microsoft Excel : Dependent Drop Down List 08:38

• Excel PivotTables 27:35

  • 75: Microsoft Excel : Creating an Excel Pivot Table 05:30
  • 76: Microsoft Excel : Modifying Excel Pivot Tables 05:38
  • 77: Microsoft Excel : Grouping Filtering PivotTable Data 06:29
  • 78: Microsoft Excel : Drilling Down into PivotTable Data 01:59
  • 79: Microsoft Excel : Creating PivotCharts and Slicers 07:59

• Excel's PowerPivot Add-In 24:36

  • 80: Microsoft Excel : What is PowerPivot 03:45
  • 81: Microsoft Excel : Activating the Excel PowerPivot AddIn 01:33
  • 82: Microsoft Excel : Creating Relationships between Data Tables 06:22
  • 83: Microsoft Excel : Using Data Models to Create PivotTables 04:30
  • 84: Microsoft Excel : How to Create PowerPivot KPIs 08:26

• Excel's Conditional Functions 31:31

  • 85: Microsoft Excel : Excels IF Function 05:16
  • 86: Microsoft Excel : IF AND Function 05:23
  • 87: Microsoft Excel : IF OR Function 05:13
  • 88: Microsoft Excel : Nesting Multiple IF Functions 07:23
  • 89: Microsoft Excel : The COUNTIF Function 04:06
  • 90: Microsoft Excel : Key Benefits of Using Named Ranges 04:10

• Excel's Lookup Functions 38:09

  • 91: Microsoft Excel : The VLOOKUP Function 08:59
  • 92: Microsoft Excel : The Beauty of Excels IFERROR Function 03:55
  • 93: Microsoft Excel : The HLOOKUP Function 06:21
  • 94: Microsoft Excel : The INDEX Function 04:42
  • 95: Microsoft Excel : The MATCH Function 04:55
  • 96: Microsoft Excel : INDEX and MATCH Combined 05:08
  • 97: Microsoft Excel : Two Way Lookup with INDEX and MATCH 04:09

• Text Based Functions in Excel 31:45

  • 98: Microsoft Excel : LEFT RIGHT MID Function 07:08
  • 99: Microsoft Excel : Extracting Specific Text using LEN and SEARCH 12:44
  • 100: Microsoft Excel : Combining Text with CONCATENATE 06:05
  • 101: Microsoft Excel : Quick Tips and Other Text Based Functions 05:48

• Auditing Formulas & Custom Views in Excel 19:45

  • 102: Microsoft Excel : Tracing Precedents and Dependents in Formulas 04:27
  • 103: Microsoft Excel : Showing Formulas 01:53
  • 104: Microsoft Excel : Grouping Data 02:42
  • 105: Microsoft Excel : 3D Referencing in Formulas 05:04
  • 106: Microsoft Excel : Utilizing the Watch Window in Excel 02:44
  • 107: Microsoft Excel : How to Freeze Panes in Excel 02:55

• Excel’s “What If?” Tools 27:32

  • 108: Microsoft Excel : Excels Scenario Manager Tool 05:55
  • 109: Microsoft Excel : Goal Seek in Excel 06:15
  • 110: Microsoft Excel : Compare Results with Excel Data Tables 04:23
  • 111: Microsoft Excel : Solver Tool 10:59

• Welcome to Excel VBA! 17:55

  • 112: Microsoft Excel : The Power Behind Excel VBA 02:35
  • 113: Microsoft Excel : A Look Inside the Visual Basic Editor 03:56
  • 114: Microsoft Excel : Recording a Macro 09:11
  • 115: Microsoft Excel : Saving and Opening a Macro Enabled Workbook 02:13

• The VBA Language in Microsoft Excel 17:09

  • 116: Microsoft Excel : Modules and Procedures 06:33
  • 117: Microsoft Excel : Object Methods and Properties 05:58
  • 118: Microsoft Excel : Excel VBA Variables 04:38

• Writing VBA Code 56:54

  • 119: Microsoft Excel : Referencing a Range 13:30
  • 120: Microsoft Excel : InputBox and MsgBox 05:32
  • 121: Microsoft Excel : Using Variables in VBA Code 04:32
  • 122: Microsoft Excel : If Then Else Statement 10:22
  • 123: Microsoft Excel : Worksheet Functions inside VBA 07:32
  • 124: Microsoft Excel : Creating User Defined Functions 09:18
  • 125: Microsoft Excel : User Defined Functions within VBA Scripts 06:08

• Important VBA Tools and Logic 27:08

  • 126: Microsoft Excel : Find Last Row of Data 05:45
  • 127: Microsoft Excel : Find Last Column of Data 03:12
  • 128: Microsoft Excel : With Statement 04:51
  • 129: Microsoft Excel : Debugging and Error Handling 06:36
  • 130: Microsoft Excel : Debugging and Error Handling Cont 06:44

• Excel VBA Loops 18:51

  • 131: Microsoft Excel : For Next Loop 09:12
  • 132: Microsoft Excel : Do Until Loop 06:03
  • 133: Microsoft Excel : For Each Loop 03:36

• Triggering Macros 24:53

  • 134: Microsoft Excel : Assigning Macros to Shapes 03:32
  • 135: Microsoft Excel : Form Controls vs Active X Controls 07:50
  • 136: Microsoft Excel : Worksheet Events 03:43
  • 137: Microsoft Excel : Workbook Events 02:54
  • 138: Microsoft Excel : Fun with VBA Events 06:54

• Excel User Forms 47:09

  • 139: Microsoft Excel : Creating an Excel UserForm 03:15
  • 140: Microsoft Excel : Adding Controls to UserForms 10:00
  • 141: Microsoft Excel : How to Show an UserForm 03:01
  • 142: Microsoft Excel : Passing TextBox Values to Desired Cells 06:36
  • 143: Microsoft Excel : Passing Option Buttons Values to Desired Cells 06:50
  • 144: Microsoft Excel : UserForm ComboBoxes 08:08
  • 145: Microsoft Excel : Clearing Values from UserForm Controls 03:06
  • 146: Microsoft Excel : How to Close an UserForm 01:33
  • 147: Microsoft Excel : UserForms and Protected Sheets 04:40

• Starting a Career in Excel 44:47

  • 148: Microsoft Excel : Creating an Excel Resume 04:51
  • 149: Microsoft Excel : Getting Started with Freelancing 06:15
  • 150: Microsoft Excel : Top Freelance Sites 05:12
  • 151: Microsoft Excel : Personal Branding 1 06:47
  • 152: Microsoft Excel : Networking Do’s and Don’ts 04:21
  • 153: Microsoft Excel : Importance of Website 04:24
  • 154: Microsoft Excel : How to Become an Excel Freelancer 05:12
  • 155: Microsoft Excel : Getting Your First Client 07:45

• Resource Section - Microsoft excel 01:00

  • 156: Resources File 01:00

• Ultimate Microsoft Excel Introduction 03:13

  • 157: Microsoft Excel : introduction_to_the_ultimate_excel_course.mp4 (720p) 03:13

• Working with Large Worksheets 23:57

  • 158: Microsoft Excel : Keeping your Headings Visible as you Scroll 03:50
  • 159: Microsoft Excel : Splitting a Worksheet to Reference Two Different Areas 03:50
  • 160: Microsoft Excel : Hiding and Unhiding Columns 02:47
  • 161: Microsoft Excel : Sorting a Large List - Including a Super Shortcut 06:20
  • 162: Microsoft Excel : Filtering a List - One of the Most Useful Excel Skills 07:10

• 5 Essential Tricks for Printing Spreadsheets 19:37

  • 163: Microsoft Excel : Scaling a Print to Fit onto Fewer Pages 05:26
  • 164: Microsoft Excel : Repeating your Headers Across Multiple P 03:06
  • 165: Microsoft Excel : Printing a Selected Range and Setting a 04:06
  • 166: Microsoft Excel : Aligning a Print on a Page 02:30
  • 167: Microsoft Excel : Using Page Breaks to Logically Break Up 04:29

• Getting Started with Excel Formulas 1:07:09

  • 168: Microsoft Excel : Introduction to Formulas - Writing your First Exc 07:50
  • 169: Microsoft Excel : The Order Of Calculation-BODMAS 03:13
  • 170: Microsoft Excel : Calculating Percentages 07:54
  • 171: Microsoft Excel : Unleash the Power of Excel Functions 08:44
  • 172: Microsoft Excel : Referencing Other Sheets and Workbooks 11:45
  • 173: Microsoft Excel : Calculating Date Difference including Working Day 08:09
  • 174: Microsoft Excel : understand Absolute Cell Addresses 06:22
  • 175: Microsoft Excel : The COUNTIF Function-An Incredibly Useful Function 13:12

• Logical Functions: The Decision Making Formulas of Excel 36:55

  • 176: Microsoft Excel : IF Function 1 04:22
  • 177: Microsoft Excel : IF Function 2 03:52
  • 178: Microsoft Excel : IF Function 3 04:06
  • 179: Microsoft Excel : Nested IFS 04:50
  • 180: Microsoft Excel : AND and OR Functions 06:35
  • 181: Microsoft Excel : TNo More Nested IFS 04:10
  • 182: Microsoft Excel : The Switch Function 09:00

• Conditional Formatting 50:14

  • 183: Microsoft Excel : Create your First Conditional Fo 07:02
  • 184: Microsoft Excel : Managing Multiple Rules 07:09
  • 185: Highlight Expired And Due Dates 07:23
  • 186: Microsoft Excel : Applying Data Bars 06:21
  • 187: Microsoft Excel : Create a Heat Map 03:02
  • 188: Microsoft Excel : Using Icon Sets 08:04
  • 189: Microsoft Excel : Entire Row 04:31
  • 190: Microsoft Excel : Testing Multiple Conditions 06:42

• Dynamic Array Functions 1:06:08

  • 191: Microsoft Excel : Introduction to dynamic Arrays 11:54
  • 192: Microsoft Excel : The UNIQUE Function 08:20
  • 193: Microsoft Excel : The SORT Function 08:25
  • 194: Microsoft Excel : The SORTBY Function 06:53
  • 195: Microsoft Excel : The FILTER Function 20:03
  • 196: Microsoft Excel : The SEQUENCE Function 10:33

• Lookup Functions 1:03:04

  • 197: Microsoft Excel : The VLOOKUP Function Expl 07:00
  • 198: Microsoft Excel : Using VLOOKUP for a Range 05:09
  • 199: Microsoft Excel : Advanced VLOOKUP 08:59
  • 200: Microsoft Excel : Handling Error Messages 05:24
  • 201: Microsoft Excel : The INDEX and MATCH Comb 06:19
  • 202: Microsoft Excel : INDEX and MATCH 04:15
  • 203: Microsoft Excel : Return Non Adjacent Column 06:19
  • 204: Microsoft Excel : XLOOKUP Function 11:38
  • 205: Microsoft Excel : Multi-Column Lookup 03:20
  • 206: Microsoft Excel : Two-Way Lookup 04:41

• Validating and Protecting Excel Data 37:56

  • 207: Microsoft Excel : Number Of Characters 02:23
  • 208: Microsoft Excel : Create Date Validation Rules 02:23
  • 209: Microsoft Excel : Drop Down Lists 04:35
  • 210: Microsoft Excel : Dependent Lists 05:25
  • 211: Microsoft Excel : Data Validation Messages 06:46
  • 212: Microsoft Excel : Encrypt a File 02:48
  • 213: Microsoft Excel : Protect Workbook 05:46
  • 214: Microsoft Excel : Protect Worksheet 07:50

• Advanced Formulas for Analysing Data 41:43

  • 215: Microsoft Excel : Using SUMIF, COUNTIF and AVERAGEIF 08:00
  • 216: Microsoft Excel : Summing the Values between Two Dates 05:44
  • 217: Microsoft Excel : Advanced Sum Formula with SUMPRODUCT 05:53
  • 218: Microsoft Excel : SUMPRODUCT Example 2 09:37
  • 219: Microsoft Excel : Secret AGGREGATE Function 07:38
  • 220: Microsoft Excel : Advanced AGGREGATE 04:51

• Charts - Simple and Effective Data Presentation 1:06:56

  • 221: Microsoft Excel : First-Charts 07:35
  • 222: Microsoft Excel : Chart-Elements 05:23
  • 223: Microsoft Excel : Formatting Charts 06:42
  • 224: Microsoft Excel : Modidy the Charts Axis 07:22
  • 225: Microsoft Excel : Chart Templates 04:35
  • 226: Microsoft Excel : Combo Charts 06:19
  • 227: Microsoft Excel : Chart-Filters 02:29
  • 228: Microsoft Excel : Interactive Charts 08:03
  • 229: Microsoft Excel : Using Cell Values for Chart Labels 04:27
  • 230: Microsoft Excel : Conditional-Formatting with Charts 07:58
  • 231: Microsoft Excel : Sparklines 06:03

• Manipulating Text in Excel 56:12

  • 232: Microsoft Excel : Splitting Text across Multiple Columns 07:25
  • 233: Microsoft Excel : Concat and Concatenate Functions 06:28
  • 234: Microsoft Excel : The TEXTJOIN Function 04:10
  • 235: Microsoft Excel : Extracting Text from a Cell 09:34
  • 236: Microsoft Excel : MID and FIND Functions 07:23
  • 237: Microsoft Excel : Value Function 03:34
  • 238: Microsoft Excel : Substitute Function 07:31
  • 239: Microsoft Excel : Flash Fill Tool 10:07

• Formatting your Data Ranges as Tables for Easier Management 25:03

  • 240: Microsoft Excel : Formatting as a Table 04:00
  • 241: Microsoft Excel : Benefits of Using Table 07:50
  • 242: Microsoft Excel : Creating Table Style 04:42
  • 243: Microsoft Excel : Formulas Using a Tables 06:51
  • 244: Microsoft Excel : Back to a Normal Range 01:40

• Master PivotTables for Powerful Analysis and Reporting 1:04:23

  • 245: Microsoft Excel : Creating a PivotTable 08:09
  • 246: Microsoft Excel : Values Function 03:19
  • 247: Microsoft Excel : Formatting Values 02:20
  • 248: Microsoft Excel : PivotTable Style 05:10
  • 249: Microsoft Excel : Sorting PivotTable 02:37
  • 250: Microsoft Excel : Grouping Data 04:55
  • 251: Microsoft Excel : Showing Values 05:11
  • 252: Microsoft Excel : Conditional Formatting 03:41
  • 253: Microsoft Excel : Filtering PivotTable Data 03:59
  • 254: Microsoft Excel : Refreshing a PivotTable 04:49
  • 255: Microsoft Excel : Creating a Pivotchart 05:22
  • 256: Microsoft Excel : Slicers 11:56
  • 257: Microsoft Excel : Timeline 02:55

• Getting and Transforming Data with Power Query 1:36:23

  • 258: Microsoft Excel : What is Power Query 03:09
  • 259: Microsoft Excel : Merge-Queries-2 06:15
  • 260: Microsoft Excel : Messy Data 21:26
  • 261: Microsoft Excel : Unpivot 07:01
  • 262: Microsoft Excel : Merge Queries-1 10:03
  • 263: Microsoft Excel : Combine and Append 10:32
  • 264: Microsoft Excel : Setting Locales 10:04
  • 265: Microsoft Excel : Multiple Files From Folder 15:07
  • 266: Microsoft Excel : Importing Data From web 12:46

• Working with the Data Model and PowerPivot 44:34

  • 267: Microsoft Excel : Introduction PowerPivot 07:00
  • 268: Microsoft Excel : Creating Relationships 07:46
  • 269: Microsoft Excel : Creating PivotTable 05:51
  • 270: Microsoft Excel : PowerPivot Adding 01:12
  • 271: Microsoft Excel : PowerPivot Window 04:39
  • 272: Microsoft Excel : Calculated columns 07:37
  • 273: Microsoft Excel : Measures 10:29

• Resource Section - Ultimate Excel 01:00

  • 274: Resource File 01:00

• Advanced Microsoft Excel Introduction 02:33

  • 275: Microsoft Excel : Introduction and What to Expect 02:33

• Neat Tricks to Supercharge your Productivity 55:21

  • 276: Microsoft Excel : 10 Paste Special Tricks used by the Pros 11:35
  • 277: Microsoft Excel : Excel's Best kept secret and 3 ways to Use It 06:59
  • 278: Microsoft Excel : The Unsung Hero of Excel for Cleaning Messy Data 11:08
  • 279: Microsoft Excel : Edit Multiple Sheets at the Same Time with Ease 04:19
  • 280: Microsoft Excel : 5 Reasons your Excel Formulas are not Calculating 05:53
  • 281: Microsoft Excel : TOP SECRET - How to Make Sheets VERY Hidden 04:54
  • 282: Microsoft Excel : My Favourite Excel Shortcuts 10:33

• Using Wildcards with Formulas in Microsoft Excel 10:22

  • 283: Microsoft Excel : Using Wildcards with VLOOKUP 04:05
  • 284: Microsoft Excel : Using wildcards with COUNTIF and SUMIF 02:26
  • 285: Microsoft Excel : Validate that Text is a Specific Number of Characters 03:51

• The Awesome SUMPRODUCT Function 29:29

  • 286: Microsoft Excel : The Definitive Guide to the SUMPR 08:01
  • 287: Microsoft Excel : Example 1-Count and Sum the Sales 06:22
  • 288: Microsoft Excel : Example 2 - Count the Occurrences 04:18
  • 289: Microsoft Excel : Example 3-Count the Unique Values 03:25
  • 290: Microsoft Excel : Example 4 - Sum the Top 3 Values 03:05
  • 291: Microsoft Excel : Example 5-Two Way Lookup Formula 04:18

• Advanced PivotTable Tricks for Microsoft Excel 1:27:26

  • 292: Microsoft Excel : Two Reasons your PivotTable Counts instead of Sums 06:06
  • 293: Microsoft Excel : You Must Do this One Thing 06:47
  • 294: Microsoft Excel : Grouping Dates and Times 09:20
  • 295: Microsoft Excel : Using the GETPIVOTDATA Function to Pull Data from a PivotTable 09:21
  • 296: Microsoft Excel : Going Beyond the Sum-3 More PivotTable Calculations 09:42
  • 297: Microsoft Excel : Calculating the Difference to Previous YearsMonthsWeeks 05:15
  • 298: Microsoft Excel : Create Your Own Calculated Fields 03:40
  • 299: Microsoft Excel : Using Conditional Formatting with PivotTables 06:20
  • 300: Microsoft Excel : Show Top Ten Results 03:20
  • 301: Microsoft Excel : Five Useful PivotTable Settings 08:15
  • 302: Microsoft Excel : The Power of Slicers 10:28
  • 303: Microsoft Excel : 7 Slicer Settings you Will Want to Change 08:52

• The Hidden Power of the MOD Function 16:52

  • 304: Microsoft Excel : An Introduction to the MOD Function 01:53
  • 305: Microsoft Excel : Example 1- Extracting the Time from a Date-Time Cell 02:21
  • 306: Microsoft Excel : Example 2 - Prevent the Entry of Odd Numbers in a Range 02:44
  • 307: Microsoft Excel : Example 3- Calculate Total Balls Bowled from Overs in Cricket 03:47
  • 308: Microsoft Excel : Example 4 - Sum Every 3rd Row in a List 06:07

• The Magic of the INDIRECT Function 17:21

  • 309: Microsoft Excel : Example 1 - INDIRECT with Named Ranges 02:49
  • 310: Microsoft Excel : Example 2 - Referencing other sheets with Indirect 04:27
  • 311: Microsoft Excel : Example 3 - Return the Last Value from a Row 04:24
  • 312: Microsoft Excel : Example 4 - INDIRECT with VLOOKUP 02:27
  • 313: Microsoft Excel : Example 5 - Create Dependent Drop Down Lists 03:14

• The Incredible INDEX Function in Microsoft Excel 44:46

  • 314: Microsoft Excel : Example 1 - Using INDEX and MATCH for an Advanced Lookup 11:08
  • 315: Microsoft Excel : Lecture 48 Example 2 - Create a Picture Lookup 08:00
  • 316: Microsoft Excel : Example 3 - Return the Value from the Last Row 02:50
  • 317: Microsoft Excel : Example 4 - Create a Dynamic Named Range 12:09
  • 318: Microsoft Excel : Example 5 - Sum the Last 6 Values Only 04:41
  • 319: Microsoft Excel : Example 6 - Retrieve a Range from a List of Ranges 05:58

• COUNTIF Function 29:11

  • 320: Microsoft Excel : Using Cell Values with COUNTIF 04:57
  • 321: Microsoft Excel : Count values Between Two Dates 02:57
  • 322: Microsoft Excel : Prevent Duplicates in a Range 04:11
  • 323: Microsoft Excel : Compare Two Lists to Identify Missing Items 04:23
  • 324: Microsoft Excel : VLOOKUP for the Last Match in a List 07:39
  • 325: Microsoft Excel : Uniquely Rank Items 05:04

• Introducing Custom Number Formatting 16:02

  • 326: Microsoft Excel : Combine Text and Numbers in a Cell 03:50
  • 327: Microsoft Excel : Show the Weekday of a Date 02:50
  • 328: Microsoft Excel : Keep the Leading Zeroes of a Value 03:08
  • 329: Microsoft Excel : Display Negative Values in Red 03:27
  • 330: Microsoft Excel : Show Zero Values as Blank Cells 02:47

• Advanced Custom Formatting 16:50

  • 331: Microsoft Excel : Display Symbols 07:14
  • 332: Microsoft Excel : Conditional Colour 05:24
  • 333: Microsoft Excel : Setting Thresholds 04:12

• Advanced Chart Tricks for Dynamic Interactive Charts 1:04:28

  • 334: Microsoft Excel : The Easiest Way to Create a Dynamic Data 04:26
  • 335: Microsoft Excel : Drop Down Menu to Select a Chart 06:59
  • 336: Microsoft Excel : Get Creative by Building a Dynamic Chart Title 07:25
  • 337: Microsoft Excel : Highlight the Max and Min Values Differently 07:12
  • 338: Microsoft Excel : Create a Scrollable Chart 14:05
  • 339: Microsoft Excel : Use Cell Values for Data Labels to Show 04:47
  • 340: Microsoft Excel : Rolling Chart for the Last 6 Months Only 10:00
  • 341: Microsoft Excel : Visualise Targets v's Actuals 03:06
  • 342: Microsoft Excel : Using Check boxes to ShowHide Chart Data 05:28
  • 343: Thank You ! 01:00

• Resource Section - Advance Excel 01:00

  • 344: Resource File 01:00

Microsoft Excel Advanced Training
Unlock the full potential of Microsoft Excel with our comprehensive Advanced Training Bundle. Dive into Microsoft Excel's essential features, from basic navigation to values, referencing, and formulas.

Master Microsoft Excel database functions and elevate your data visualisation capabilities with impactful Microsoft Excel charts. Implement data validation techniques to ensure data integrity in Microsoft Excel.

Unveil the power of Microsoft Excel VBA for effective automation. Conquer large datasets with ease and become a data wizard, transforming raw data into actionable insights through Microsoft Excel PivotTables.

To get a professional qualification, you can enrol in the following courses:

• Level 2 Award in Microsoft Excel (2023)
• Level 3 Award in Microsoft Excel (2023)
• Level 3 Diploma in Microsoft Excel (2023)
• Level 2 Award in Microsoft Excel (2023)
• Level 3 Award in Microsoft Excel (2023)
• Level 3 Diploma in Microsoft Excel (2023)
• Level 2 Award in Microsoft Excel (2023)
• Level 3 Award in Microsoft Excel (2023)
• Level 3 Diploma in Microsoft Excel (2023)

This Microsoft Excel Advanced Training does not have any prerequisites or formal requirements.

This Microsoft Excel Advanced Training will assist you to get your desired job in the relevant field.

• Excel Cost Estimator
• Excel Project Manager
• Data Analyst
• Business Analyst
• Accountant
• Office Administrator

Currently there are no Q&As for this course. Be the first to ask a question.

CPDQE Certificate on Microsoft Excel

Digital certificate - Included

Reed courses certificate of completion

Digital certificate - Included