1. The 80:20 principle & the paradox of choice
2. Introduction to Excel for professionals
3. Performance of Excel
4. Long boring lists
5. Long boring lists: Monthly Data
6. Small, Mid and Large Data sets
7. Locking down cells
8. Finding Information: VLOOKUP
9. Finding Information: INDEX & MATCH
10. OPTIONAL: Excel Tables & Slicers

1. Finding Information: Limit formulas
2. Getting Advanced with Lookups
3. Finding Information: putting it all together
4. Rule building with IF
5. More advanced logic building

1. Working with Text
2. Text Functions: PROPER, TRIM & CLEAN
3. Text Functions: LEN & SEARCH
4. Text Functions: LEFT, MID, RIGHT
5. Flash Fill
6. Text functions: Advanced Text analysis by building formulas
7. Text functions: Creating email addresses to build distribution lists
8. Creating character and word count limits

1. Introduction to summarising
2. Counting
3. Summing
5. Analysis walkthrough with summing and counting
6. Everything you need to know about Pivot Tables in under 15 minutes
7. Advanced list analysis: understanding Array formulas
8. OPTIONAL: Introduction to Array Formulas
9. OPTIONAL: Array Formulas for Multiple Criteria
10. OPTIONAL: Array Formulas for Multiple Occurrences
11. Advanced Modelling with Array formula lookups
12. Dashboard and reporting practice for professionals
13. Advanced Conditional formatting: Using formulas
14. Advanced Conditional formatting: Beyond Highlighting

1. Resource Analysis: Good practice for managing data
2. Dynamic Charts
3. Charting Actual vs Forecast
4. Segmenting for deeper MI
5. Meaningful Resource Analysis

1.Pivot Intro
2.Pivot Cache
3. Altering the Data Source
4. Unpivot data to a long boring list
5. Moving row and column
6. Expand and Collapse field

7. Format Error and Empty cells
8. Change Layout of Pivot Table
9. Place Pivot Table
10. Pivot Table Styles
11. Format Content in Pivot

12. Summarise Value by
13. Multiple Subtotal
14. Percentage of column total
15. Difference From value as percentage
16. Double click for detail
17. Running Total
18. Grouping Year Month Quarter
19. Sorting

20. Filtering – Part 1
21. Filtering – Part 2
22. Slicer – Insert Style Property
23. One Slicer connected to Multiple Pivots
24. Timeline Slicer

25. Calculated Field
26. Link Multiple Table into One Pivot – Part 1
27. Link Multiple Table into One Pivot – Part 2
28. Calculated Field with IF statement

29. Conditional Formatting in Pivot – Part 1
30. Conditional Formatting in Pivot – Part 2
31. PivotCharts Part 1
32. PivotCharts Part 2 – Linking and Slicers
33. PivotCharts Part 3 – Formatting
34. Dashboard 1 – What we will build
35. Dashboard 2 – Our Dataset
36. Dashboard 3 – Pie Chart
37. Dashboard 4 – Line Chart
38. Dashboard 5 – Bar Chart
39. Dashboard 6 – Map Chart
40. Dashboard 7 – Putting it all together
41. Outro

1. Business Budget
2. To Do List
3. Invoice
4. Flowchart
5. Organizational Chart
6. Inventory
7. Timesheet
8. Dashboard
9. Payroll
10. Purchase Order
11. Household Budget
12. Calendar
13. Expense Tracker
14. Balance Sheet
15. Income Statement
16. Cash Flow
17. Time Management
18. CRM
19. General Ledger

1. Resource Analysis: Good practice for managing data
2. Dynamic Charts
3. Charting Actual vs Forecast
4. Segmenting for deeper MI
5. Meaningful Resource Analysis
6. Interesting MI Aesthetics, automating folders and PDF files
7. Automate the creation of a PowerPoint slide deck
8. Combining PowerPoint with Information Gathering
9. Automating the production of a Project Summary front page in PowerPoint

1. Cells and Ranges
2. Copy And Paste
3. Controlling Fonts And Colouring Cells
4. Multiple Lines, Clearing And Column Widths
5. Building Logic With If
6. Building Logic With Select Case
7. The Importance Of Loops
8. Introduction To Automation
9. Loops And Selecting Ranges
10. Maneuvering And Macros
11. Constants And Variables
12. The Most Important Line In VBA You Need To Know!
13. Putting Together Everything So Far To Demonstrate Automation

1. Macro File Formats
2. Developer Tab And Macro Security
3. Modules, Macros And Relative References
4. A First Look At Buttons
5. Charting Driven By Macros
6. Why Macros Can Go Wrong And What To Do About It
7. Handling Errors And Sheet Issues
8. Dynamic Charting: Part 1
9. Dynamic Charting: Part 2
10. Dynamic Charting: Part 3
11. End With
12. Controlling Autofilters
13. Controlling Formulas

1. 5 Levels Of Looping Part 1
2. 5 Levels Of Looping Part 2
3. 5 Levels Of Looping Part 3
4. 5 Levels Of Looping Part 4
5. 5 Levels Of Looping Part 5
6. VBA Alternative: Gathering Data With Power Query

1. Introduction
2. Creating An Input Sheet Template
3. Mass Producing Input Sheets 1: Set The Scene
4. Mass Producing Input Sheets 2: Worksheet Variables
5. Mass Producing Input Sheets 3: Autofilter Revisited And Paste special
6. Mass Producing Input Sheets 4: Manipulating Filter Criteria
7. Mass Producing Input Sheets 5 Creating A Unique List To Prepare For Looping
8. Mass Producing Input Sheets 6 Instantly Creating 25 Unique Input Excel Files

1.  Starting The New Process
2.  Open Up One File And Copy Data
3. Introduction To The Do While Loop
4.  Looping Through All Files In A Folder And Copying Data
5.  Setting Up New Data Before We Bring Into Our Long Boring List
6.  Looking Up Latest Data Manually Into Our Long Boring List
7.  Looking Up Latest Data Automatically Into Our Long Boring List
8.  Putting It All Together

1. Why PowerPoint?
2. Introduction to the Object Model
3. Programming in PowerPoint 1: Basics
4. Programming in PowerPoint 1: Shapes
5. Programming in PowerPoint 1: Tables
6. Opening PowerPoint from Excel
7. Pasting an Excel range as an Image in PowerPoint
8. Translating Excel data into a table in PowerPoint 1
9. Translating Excel data into a table in PowerPoint 2: Multiple Slides
10. Drawing Shapes in Excel
11. Translating Excel data into Shapes in PowerPoint

1. Introduction and Creating an MS Word Invoice from Excel
2. Gathering Data from MS Word docs in to Excel (Change Control Form)
3. Purchase order system: part 1 – Excel to word
4. Purchase order system: part 2 – The word template
5. Purchase order system: part 3 – Save & print button
6. Purchase order system: part 4 – Excel to word

1. Resource Analysis: Good practice for managing data
2. Dynamic Charts
3. Charting Actual vs Forecast
4. Segmenting for deeper MI
5. Meaningful Resource Analysis
6. Interesting MI Aesthetics, automating folders and PDF files
7. Automate the creation of a PowerPoint slide deck
8. Combining PowerPoint with Information Gathering
9. Automating the production of a Project Summary front page in PowerPoint

1.1 Introduction to Power Query
1.2 Getting Familiar with the Power Query Editor
1.3 First Data Clean Up for a Pivot Table
1.4 Tweaking our Query until the data is correct
1.5 Rounding data
1.6 Altering Data Types
1.7 Filtering out data before we load it
1.8 Advanced Calculated Columns
1.9 Grouping Columns
1.10 Using Columns From Examples

2.2 Pre-preparing messy data
2.3 Appropriating our data with Transpose
2.4 Un-Pivoting Data
2.5 Pivoting Data
2.6 Creating a Pivot Chart

3.1 Appending data
3.2 Introduction to Merging data
3.3 Left Outer Join
3.4 Right Outer Join
3.5 Full Outer Join
3.6 Inner Join
3.7 Left Anti Join
3.8 Right Anti Join
3.9 More appending with bigger data sets
3.10 Going deeper with Merging data

4.1 Duplicating Queries
4.2 Speeding up query editing with duplication
4.3 Filtering duplicated queries
4.4 Working with References
4.5 Parameters

5.1 Functions
5.2 Dealing with Errors
5.3 Steps Part 1: Troubleshooting Queries
5.4 Steps Part 2
5.5 Queries and Groups
5.6 Advanced Query Editor
5.7 Query Refresh
5.8 Dependencies
5.9 Revisiting Combining Queries

Lesson 1.1 Introduction to Power Pivot
Lesson 1.2 Data Model Familiarisation
Lesson 1.3 Data Modelling Concepts
Lesson 1.4 Introduction to Data Types

Lesson 2.1 Loading data with PowerQuery
Lesson 2.2 Loading Data from Excel tables
Lesson 2.3 Introduction to using with Pivot Tables
Lesson 2.4 Other data load options
Lesson 2.5 Loading Data from an external database

Lesson 3.1 More on Pivot Tables
Lesson 3.2 Pivot  Tables and Relationships
Lesson 3.3 Introduction to Refreshing Data
Lesson 3.4 Refreshing Data via Connections
Lesson 3.5 Refreshing Data from an external database

Lesson 4.1 Calculated Columns
Lesson 4.2 Introduction to measures
Lesson 4.3 Adding explicit measures with Autosum
Lesson 4.4 Adding implicit measures
Lesson 4.5 Adding explicit measures in Power Pivot menu

Lesson 5.1 Introduction
Lesson 5.2 Adding a hierarchy
Lesson 5.3 Using hierarchies in a Pivot Table
Lesson 5.4 Drill paths
Lesson 5.5 Introduction to Related Columns
Lesson 5.6 Related Columns in a hierarchy
Lesson 5.7 Best practices with hierarchies
Lesson 5.8 Editing hierarchies

Lesson 6.1 DAX Syntax and Operators
Lesson 6.2 Some Useful DAX Functions part 1
Lesson 6.3 Some Useful DAX Functions part 2
Lesson 6.4 Some Useful DAX Functions part 3
Lesson 6.5 Introduction to Iterator Functions
Lesson 6.6 Expressions in Iterator Functions
Lesson 6.7 Table functions in Iterator Functions (RELATEDTABLE)
Lesson 6.8 Table functions in Iterator Functions (TOPN)
Lesson 6.9 Other Iterator Functions
Lesson 6.10 Introduction to Context
Lesson 6.11 Examples of Context
Lesson 6.12 Filter Context in Pivot Tables
Lesson 6.13 Introduction to Filter Functions
Lesson 6.14 Example of a Filter Function
Lesson 6.15 Using Filters in a Filter Function
Lesson 6.16 Using the ALL Filter Function
Lesson 6.17 Using the ALLSELECTED Filter Function
Lesson 6.18 Introduction to Parent-Child Functions
Lesson 6.19 Using Parent-Child Functions
Lesson 6.20 Using Parent-Child Functions for a Hierarchy
Lesson 6.21 Time Intelligence Functions Part 1
Lesson 6.22 Time Intelligence Functions Part 2
Lesson 6.23 Time Intelligence Functions Part 3
Lesson 6.24 Time Intelligence Functions Part 4

1.1 The Power BI Interface
1.2 The Three main views in Power BI
1.3 Getting Familiar with Power BI

2.1 Connecting to Excel Data
2.2 Getting familiar with Power Query
2.3 Building & Cleaning a Date Table

3.1 Understanding relationships
3.2 Introduction to calculations
3.3 Working with measures
3.4 Measure for total profit
3.5 Measure for previous year profit
3.6 Using a slicer to filter dates

4.1 Sales Summary: Dashboard set up
4.2 Sales Summary: Line Chart
4.3 Sales Summary: Donut Chart
4.4 Sales Summary: Optional-More Donut Charts
4.5 Profit Summary: Tweaking an Existing Dashboard
4.6 Geography Summary: Introduction
4.7 Geography Summary: Stacked Bar Chart
4.8 Geography Summary: Maps
4.9 Product Summary: Introduction
4.1 Product Summary: Scatter Plot
4.11 Product Summary: Tree Diagram
4.12 Employee Summary: Introduction
4.13 Employee Summary: Stacked Column Chart
4.14 Employee Summary: Combination Chart
4.15 Employee Summary: Waterfall Chart
4.16 Employee Summary: OPTIONAL- Donut Chart

5.1 Introduction to Sharing & Publishing Dashboards
5.2 Building Dashboards in Myworkspace
5.3 Refreshing Data sources
5.4 The benefits of reports
5.5 Pinning a Dashboard
5.6 Sharing your Dashboard
5.7 The Power BI Community
5.8 Outro and next steps

1.1 Clean Data in Query Editor
1.2 Power BI Data Types and Formatting
1.3 Transform Your Data with Custom Columns
1.4 Duplicate and Merge Queries
1.5 Date Correction
1.6 Erroneous Data

2.1 Intro to Time Intelligence
2.2 Year Over Year Analysis and Day Analysis
2.3 Last 30 Days Analysis
2.4 Running Sum
2.5 Variables and Measures within Variables
2.6 DAX Development Best Practices
2.7 Pareto Chart
2.8 Moving Average
2.9 Switch Function

3.1 Basic Report Formatting Tips
3.2 Custom Themes
3.3 Conditional Formatting
3.4 Drillthrough (Same Report)
3.5 Drillthrough (Cross Report)
3.6 Sync Slicers
3.7 Edit Interactions

1.1 Clean Data in Query Editor
1.2 Power BI Data Types and Formatting
1.3 Transform Your Data with Custom Columns
1.4 Duplicate and Merge Queries
1.5 Date Correction
1.6 Erroneous Data

2.1 Intro to Time Intelligence
2.2 Year Over Year Analysis and Day Analysis
2.3 Last 30 Days Analysis
2.4 Running Sum
2.5 Variables and Measures within Variables
2.6 DAX Development Best Practices
2.7 Pareto Chart
2.8 Moving Average
2.9 Switch Function

1.1 Opening a new blank document
1.2 New blank doc 3 ways
1.3 Highlighting and adding text
1.4 Revealing formatting marks
1.5 Customising the QAT (quick access toolbar)
1.6 Changing the ribbon
1.7 Help menu and Search bar
1.8 Save and close doc

2.1 Formatting big docs at a glance and applying headings
2.2 Explanation of headings
2.3 Spell check
2.4 Spell check cont'd
2.5 Removing extra paragraph and bullet spaces
2.6 Follow up formatting removing bulleted list spaces

3.1 Inserting a page break
3.2 Creating a table and entering data-text
3.3 Creating a table and entering data-text cont'd
3.4 Creating a table from scratch
3.5 Creating a table from scratch cont'd
3.6 Creating a table – borders and shading
3.7 Creating a table - text direction and shading

4.1 Preset margins
4.2 Orientation
4.3 Alignments and indenting
4.4 Margins manual adjustment
4.5 Formatting underline and bold
4.6 Cut and paste
4.7 Copy and paste

5.1 Applying bullets and picture bullets
5.2 Numbered list
5.3 Basic multilevel list
5.4 Paragraph numbering
5.5 Multilevel list with headings
5.6 Inserting a cover page

6.1 Convert text to table
6.2 Inserting and deleting rows and columns
6.3 Convert text to table with tabs
6.4 Working with text boxes
6.5 Working with text boxes cont’d
6.6 Linking text boxes

7.1 Building block explanation
7.2 Creating a building block from scratch
7.3 Delete a building block
7.4 Insert automatic date and time + update field
7.5 Section breaks
7.6 Text flow options

8.1 Insert header with building blocks
8.2 Insert footer with building blocks
8.3 Inserting page numbers and modifying where it starts
8.4 Insert header manually
8.5 Insert footer manually
8.6 All different views within Word

9.1 Find and replace
9.2 Creating shapes with fill and gradients
9.3 Adding text to shapes
9.4 Enter text with text box and group to objects
9.5 Grouping and resizing shapes

10.1 Insert and format a picture
10.2 Applying page colour
10.3 Applying, viewing and removing a watermark
10.4 Finding pages
10.5 Design a table manually
10.6 Setting repeat header rows
10.7 Removing all formatting and selecting headings

11. 1 Creating and applying a new style
11.2 Remove style from gallery
11.3 Save Word doc as PDF file
11.4 Viewing recent docs
11.5 Creating a new folder
11.6 Using MS Word translator
11.7 Using a template
11.8 Find and replace font and formatting

1.1 Mail merge with wizard
1.2 Manual mail merge
1.3 Mail merge envelopes with wizard
1.4 Mail merge labels with wizard
1.5 Mail merge Word data source vs Excel data source
1.6 Mail merge basic sorting
1.7 Mail merge advanced filtering

2.1 Viewing the TOC in different view modes
2.2 Creating and running a macro
2.3 Assigning shortcut key to macro 3
2.4 Deleting a macro
2.5 Working in outline view
2.6 Inserting indexes and creating bookmarks
2.7 Deleting indexes
2.8 Deleting bookmarks

3.1 Working with master docs
3.2 Inserting and deleting sub docs
3.3 Entering footnotes
3.4 Inserting captions and labels
3.5 Entering cross references
3.6 Creating modifying deleting citations placeholders and bibliography
Marking legal citations and creating TA

4.1 Removing hyperlinks
4.2 Inserting and modifying TOF
4.3 Inserting and managing content control fields
4.4 Protect forms
4.5 Working and proof read with track changes
4.6 Comparing docs

5.1 Viewing and amending properties
5.2 Removing hidden properties
5.3 Making a document as final
5.4 Adding and removing password to protect a doc
5.5 Restrict editing a doc
5.6 Inserting MS digital signature
5.7 Inserting non MS digital signature not secured
5.8 Changing style and automating captions

1.1 Introduction to PowerPoint Ribbon Tabs & Groups
1.2 Ribbon Options
1.3 Customise the Quick Address Toolbar
1.4 Moving through and deleting slides

2.1 Shapes filled with pictures
2.2 Arranging Shapes 1
2.3 Arranging Shapes 2
2.4 Aligning, grouping and resizing shapes
2.5 How to use shapes
2.6 Merging vs Grouping
2.7 Shapes - all merging options
2.8 Creating customised shapes

3.1 Working with SmartArt 1
3.2 Working with SmartArt 2
3.3 Organisational chart - Manual vs SmartArt
3.4 Organisational chart - more tips
3.5 Arrow diagram

4.1 Guides, Rulers & Gridlines
4.2 Smart Guides and shapes
4.3 Smart Guides and text boxes
4.4 Inserting and formatting text plus setting up tabs
4.5 Changing margins within shapes
4.6 Working with bullets

5.1 Working with sections
5.2 Creating a Slide Master 1
5.3 Creating a Slide Master 2
5.4 Slide Master placeholders
5.5 Slide Master change placeholder shape
5.6 Slide Master change placeholder points
5.7 Changing default style to shapes and text boxes

6.1 How to insert Excel data within PowerPoint
6.2 How to insert Excel chart within PowerPoint
6.3 How to create a chart within PowerPoint
6.4 Animating Excel Charts in PowerPoint
6.5 Adding Elements to Excel Charts in PowerPoint
6.6 Working with Word in PowerPoint
6.7 Word outline in PowerPoint

7.1 How to add slide numbers
7.2 Mergers and Acquisitions presentation
7.3 Shapes with gradient fill
7.4 Shapes – copy format and edit points
7.5 Shapes – formatting lines and arrows

8.1 How to add footnotes
8.2 How to check for consistency
8.3 Reviewing slides with markups
8.4 Inserting tables

9.1 How to create a logo slide
9.2 Design Ideas on and off
9.3 Spell check
9.4 Adding notes and printing slides and handouts

1. 1 Introduction to Outlook
1.1a Introduction to Outlook follow up
1.2 Linking an email
1.3 Creating and formatting email and inserting picture
1.4 Creating email signature
1.5 Pasting in Outlook from Word PPT and Excel

2.1 Send email, show sent folders and receiver email
2.2 Creating rules
2.3 Conditional formatting
2.4 Different view panes settings
2.5 More about view settings
2.6 Understanding different folders

3.1 Printing an email
3.2 Creating subfolder within new folder
3.3 Sending attachments
3.4 Using categories with Exchange, IMAP and POP email accounts
3.5 Tags and searching for emails
3.6 Using the search folder

4.1 Flagging emails
4.2 Automatic out of office reply with Exchange server
4.3 Automatic out of office reply with IMAP email account
4.4 Deleting automatic reply in IMAP account
4.5 Using voting buttons
4.6 Creating a distribution list

5.1 Auto archiving and manually archiving emails-folders
5.2 Creating and assigning recurring tasks
5.3 Creating, linking new calendar, meetings, signature within outlook
5.4 Setting up recurring meetings
5.5 Categorising events - colour coding

6.1 Meetings - Change and propose new time
6.2 Creating meetings from email and making them private
6.3 Printing calendar or event
6.4 Searching the calendar
6.5 Modifying working hours and days
6.6 What reminders look like

1.1 Introduction to OneNote
1.2 OneNote Introduction to the ribbon
1.3 Organise QAT
1.4 Organise QAT Part 2
1.5 Inserting notes

2.1 Copy cut text and split and merge containers
2.2 Deleting and inserting time stamp
2.3 Adding and deleting pages
2.4 Formatting text applying styles and using the format painter
2.5 Creating bulleted and numbered lists
2.6 Inserting and removing spaces between containers

3.1 Adding and organising sections
3.2 Creating subpages
3.3 Creating section groups
3.4 Applying OneNote templates
3.5 Creating customised templates

4.1 Working with different page versions
4.2 The History tab – recycle bin etc
4.3 Using Quick Notes
4.4 Change default location of Quick Notes
4.5 Using dock to desktop
4.6 Using Linked Notes

5.1 Inserting printouts and attachments
5.2 Inserting Excel part 1
5.3. Inserting Excel part 2
5.4 Inserting tables
5.5 Formatting tables
5.6 Sorting data within a table

6.1 Screen clipping
6.2 Inserting pictures
6.3 Using the Optical Character Recognition - OCR
6.4 Inserting symbols
6.5 Using Send to OneNote
6.6 Converting handwritten ink to text

7.1 The View tab options
7.2 Customising the side panes
7.3 Applying tags
7.4 Searching tags
7.5 Audio recording part 1
7.6 Audio recording part 2

8.1 Using research option within the View tab
8.2 Creating links between notebooks sections and pages
8.3 Creating a TOC
8.4 Setting up the pen and highlighting text
8.5 Inserting and formatting shapes
8.6 Rearranging shapes
8.7 Using the pointer

9.1 Inserting Equations
9.2 Inserting handwritten Equations
9.3 Calculating simple math
9.4 Sending OneNote pages via email
9.5 Exporting OneNote
9.6 Linking Outlook Contacts in OneNote
9.7 Linking Outlook 365 appointments in OneNote
9.8 Using Outlook tasks in OneNote

10.1 Using Backups to restore sections
10.2 Restoring deleted pages and sections
10.3 Password protecting sections

1.1 Introduction
1.2 Overview

2.1 Combined What you can enter in a cell
2.2 Relative and Absolute Cell Referencing
2.3 Entering Formula
2.4 Order of Operations
2.5 Date Serial Numbers 

3.1 Copy and Drag
3.2 Working with rows and columns
3.3 Working with sheets 

4.1 Functions
4.2 SUM Function
4.3 Copy and Drag Formula
4.4 more basic functions
4.5 Named Ranges
4.6 Names Constants and Formula
4.7 Shortcuts
4.8 More Shortcuts 

5.1 Formatting Font
5.2 Formatting Alignment
5.3 Formatting Borders
5.4 Formatting Numbers
5.5 Conditional Formatting PreConfigured
5.6 Conditional Formatting with Formula
5.7 Conditional Formatting Dialogue Box Formula Trick 

6.1 Icons Shapes and Formatting
6.2 Printing Page Layout
6.3 Printing Headers Footers  

7.1 Data Sort
7.2 Filtering
7.3 Tables
7.4 Text to Columns
7.5 Flash Fill
7.6 Data Validation
7.7 Group and Outline
7.8 Freeze Panes 

8.1 Relative and Absolute Referencing
8.2 VLOOKUP
8.3 Index Match
8.4 IF
8.5 Nested If
8.6 Countif Countifs
8.7 SUMIF SUMIFS
8.8 LEN
8.9 RIGHT LEFT MID
8.10 SEARCH
8.11 Common Error Types
8.12 IFERROR 

9.1 Chart Basics
9.2 Chart Series and Column Charts
9.3 Bar Charts
9.4 Pie Charts
9.5 Composite Charts 

10.1 Power Query Intro
10.2 Power Query Consolidation
10.3 Pivot Tables
10.4 Setting up a Pivot Table
10.5 Pivot Table Field Settings
10.6 Pivot Table Calculated Fields
10.7 Pivot Table Groupings
10.8 Pivot Table Slicers and Timelines
10.9.1 Dashboards Part 1
10.9.2 Dashboards Part 2 

11.1 What is a macro.
11.2 Recording a Macro
11.3 Relative and Absolute Macros 

12.1 Introduction to VBE
12.2 Object Model
12.3 Module Worksheets Classes
12.4 Variables and Constants
12.5 vba Formatting
12.6a If Statement
12.6b Select Case
12.7a For Loop
12.7b DoWhile DoUntil Loop
12.7c ForEach Loop
12.8a Errors
12.8b Errors
12.9 consolidate 

1.1 Introduction
1.2 Overview

2.1 Creating Teams
2.2 Managing Teams

3.1 Channels
3.2 Channels and Teams Navigation

4.1 Chats
4.2 Conversations and Notifications

5.1 Audio and Video Calls
5.2 Meetings

6.1 Working with Files Part 1
6.2 Working with Files Part 2

7.1 Mobile App
7.2 Wikis
7.3 Apps
7.4 Guest Access

8.1 Whiteboard
8.2 Search
8.3 Enhancements
8.4 Shifts

9.1 Behind the Scenes

1. Introduction to QuickBooks Online
2. Overview of Modules
3. Creating Your QuickBooks Online Log in
4. Signing into QuickBooks Online
5. The Dashboard – Restricted Access
6. The Dashboard – Regular Users – overview of Setup
7. Introduction to Connecting the Bank to QuickBooks Online

8. Create and Connect Your Bank Accounts
9. Introduction to Categorising Transactions
10. Categorising Transaction and Creating New Accounts
11. How to reconcile the Bank - Basic

12. Introduction to QuickBooks Phone App
13. Creating a quick sales invoice using QuickBooks phone App
14. Applying a payment to a sales invoice in QuickBooks App
15. How to edit customer details using QuickBooks phone App
16. How to use ReceiptSnap in QuickBooks phone App

17. Review and Action Receipts in QuickBooks Online
18. Reviewing the receipts and creating a bill
19. How to enter a purchase invoice (Bill) in QuickBooks Online
20. Entering a suppliers invoice and allocating the payment
21. Bank Reconciliation: Matching and Processing

22. Other Menus including VAT
23. Creating Reports
24. Using The Search Function
25. Optional Services and Apps in QuickBooks Online
26. Conclusion and what's next

1.1 Business Manager Set Up
1.2 Business Settings Tour
1.3 Business Manager Tools

2.1 Audiences Tour and How to Use
2.2 Custom Audiences
2.3 Saved Audiences
2.4 Lookalike Audiences

3.1 Pixels - What is a Pixel?
3.2 How to create a Pixel and Custom Event
3.3 How to create Custom Conversions
3.4 Ad Quality

4.1 Introduction to Ads Manager
4.2 Columns
4.3 CBO vs ABO
4.4 Types of Campaigns

5.1 Setting up an Ad - Traffic Ads
5.2 Conversion and Video Views Ads
5.3 Engagement + Reach Ads

6.1 Scaling
6.2 Optimizing
6.3 Strategies

7.1 Facebook Ads Course Notes
7.2 Social Media Toolbox
7.3 HLM Facebook Optimization
7.4 Customer Avatar Creation
7.5 Lead Generation Ad Formats
7.6 VA FB Ad Optimization Troubleshooting

1 Introduction to 'Selling You'
2 Managing Your career in the 21st Century
3 Modus Operandi: How and why you work the way you do
4 The Six principles that should govern how you should manage your career
5 The greatest investment that you can make in your career
6 See my Salary over my career and how Excel skills improved it
7 Diminishing returns of Excel skills
8 Excel careers that can earn you six figures
9 Problem Solvers vs Excel Experts

1 Finding work: The ‘Market’ vs your Network
2 Why you need to strongly consider contracting
3 How to transition in to contracting
4 Research: The why’s and how’s of setting yourself apart from everyone else
5 Research: How a company’s Finances affect your opportunities
6 How to win with Recruiters
7 How to search the market for work online

1 Narrative will make or break you
2 My entire process for constructing a narrative for Resume and Interview use
3 The art and importance of embellishing
4 Dealing with gaps on your CV/Resume

1 Introduction to CV/Resume Structure: Generic Template
2 Improving narrative on a Resume
3 Bringing out Excel skills in a Resume
4 What my £200K ($300K) Resume looks like
5 5 Cover Letters Templates to use

1 Interviews: Three things you MUST do
2 Interviews: Own your Psychology
3 Most common interview questions
4 Interviews: Examples of Interview preparation
5 Interviews: Demonstrate your way to success
6 Negotiating
7 Negotiating: High risk high reward techniques

1 The most effective ways to use LinkedIn for career Marketing
2 How Value Networking will define your success
3 Value Networking: Pitching yourself to an internal influencer
4 Value Networking: Secrets of success
5 Career Secrets 1: Campaign to pry your way into an unknown influencer’s radar
6 Career Secrets  2: Rules for Communicating with Influencers
7 Career Secrets  3: What kind of value should you provide to an influencer
8 Career Secrets 4: Putting it all together with a walkthrough example
9 Recap: The ‘You business’ process
10 Outro and goodbye

1 Introduction
2 Why Motivation will kill your success
3 How to be incredibly Productive: Strategy
4 How to be incredibly Productive: Tactics
5 How to be incredibly Productive: Sleep
6 Systems and Habits
7 A System for Growth of the ‘You’ Business
8 Systems and Habits 1: Sales
9 Systems and Habits 2: Development
10 Allocating Time
11 Recap: A Macro View of Success

•LinkedIn overview
•How Recruiters use LinkedIn
•Profile completion & optimisation

•Profile: Experience, Skills and Endorsements
•Why you should create an ‘All Star’ level profile
•Should you get recommendations
•Is it worth paying for LinkedIn premium?
•Best practice on accepting invitations
•The best strategy for building your network

•How Mark helped someone get his dream job by combining LinkedIn and networking techniques (Must watch!)
•6 ways to find advertised jobs on LinkedIn
•Your objectives to get the most out of LinkedIn
•Student questions answered

1.Introduction to Mentor
2.The single MOST important number in your career
3.The worst quality you can have (eliminate immediately)
4.How to use Excel to progress your career
5.Building Confidence
6.You need to do this in everything you do
7.The importance of flirting with the job market
8.Why you need a millionaire mindset to succeed
9.Excel Keyboard Shortcuts are bad for your career
10.Opportunity Cost
11.The Paradox of Choice
12.Your Personal RAID Log
13.Asset Based Thinking
14.Dopamine and Decision Making
15.Why you must place restrictions on your time
16.Consumer Vs. Producer
17.Priming yourself to do great work

1. Introduction​
2. Why Motivation will kill your success
3. How to be incredibly Productive: Strategy
4. How to be incredibly Productive: Tactics
5. How to be incredibly Productive: Sleep
6. Systems and Habits
7. A System for Growth of the ‘You’ Business​
8. Systems and Habits 1: Sales
9. Systems and Habits 2: Development
10. Allocating Time
11. Recap: A Macro View of Success