Machine Learning Course

What You'll Learn in this Course

Earn an Accredited Certificate.

Simple Linear Regression

Multiple Linear Regression

Logistic Regression

Decision Tree

Skill Level: Beginner to Intermediate

Language: English

Lessons: 40

Skill Level: Beginner to Intermediate

Language: English

Lessons: 40

Videos: 10 hours and 2 minutes

Certificate: Get a certificate of completion that can be displayed on LinkedIn

Videos: 10 hours and 2 minutes

Certificate: Get a certificate of completion that can be displayed on LinkedIn

Course Modules

MODULE 1: SIMPLE LINEAR REGRESSION

1.1 Simple Linear Regression - Theory

1.2 Simple Linear Regression - Code

MODULE 2: MULTIPLE LINEAR REGRESSION

2.1 Multiple Linear Regression - Theory

2.2 Multiple Linear Regression - Code

2.3 Assumptions of Linear Regression - Theory

2.4 Curse of Dimensionality - Theory

2.5 Model Accuracy and Train Test Split - Code

MODULE 3: LOGISTIC REGRESSION

3.1 Logistic Regression - Theory

3.2 Logistic Regression - Code

MODULE 1: SIMPLE LINEAR REGRESSION

1.1 Simple Linear Regression - Theory

1.2 Simple Linear Regression - Code

MODULE 2: MULTIPLE LINEAR REGRESSION

2.1 Multiple Linear Regression - Theory

2.2 Multiple Linear Regression - Code

2.3 Assumptions of Linear Regression - Theory

2.4 Curse of Dimensionality - Theory

2.5 Model Accuracy and Train Test Split - Code

MODULE 3: LOGISTIC REGRESSION

3.1 Logistic Regression - Theory

3.2 Logistic Regression - Code

MODULE 4: DECISION TREE

4.1 Decision Tree - Theory

4.2 Cross-Validation & Hyperparameter Tuning - Theory

4.3 Decision Tree Classifier - Code

4.4 Decision Tree Classifier with Hyperparameter Tuning - Code

4.5 Decision Tree Regressor - Code

4.6 Decision Tree Regressor with Hyperparameter Tuning - Code

4.7 Decision Tree - Theory

4.8 Cross-Validation & Hyperparameter Tuning - Theory

4.9 Decision Tree Classifier - Code

4.10 Decision Tree Classifier with Hyperparameter Tuning - Code

4.11 Decision Tree Regressor - Code

4.12 Decision Tree Regressor with Hyperparameter Tuning - Code

MODULE 4: DECISION TREE

4.1 Decision Tree - Theory

4.2 Cross-Validation & Hyperparameter Tuning - Theory

4.3 Decision Tree Classifier - Code

4.4 Decision Tree Classifier with Hyperparameter Tuning - Code

4.5 Decision Tree Regressor - Code

4.6 Decision Tree Regressor with Hyperparameter Tuning - Code

4.7 Decision Tree - Theory

4.8 Cross-Validation & Hyperparameter Tuning - Theory

4.9 Decision Tree Classifier - Code

4.10 Decision Tree Classifier with Hyperparameter Tuning - Code

4.11 Decision Tree Regressor - Code

4.12 Decision Tree Regressor with Hyperparameter Tuning - Code

MODULE 5: RANDOM TREE

5.1 Random Forest - Theory

5.2 Random Forest Classifier - Code

5.3 Random Forest Classifier with Hyperparameter Tuning - Code

5.4 Random Forest Regressor - Code

5.5 Random Forest Regressor with Hyperparameter Tuning - Code

MODULE 6: MODEL ENSEMBLING & UNSUPERVISED LEARNING

6.1 Ensembling Models - Theory

6.2 Model Ensembling - Code

6.3 Unsupervised vs. Supervised Learning + Summary of NLP and Deep Learning - Theory

MODULE 5: RANDOM TREE

5.1 Random Forest - Theory

5.2 Random Forest Classifier - Code

5.3 Random Forest Classifier with Hyperparameter Tuning - Code

5.4 Random Forest Regressor - Code

5.5 Random Forest Regressor with Hyperparameter Tuning - Code

MODULE 6: MODEL ENSEMBLING & UNSUPERVISED LEARNING

6.1 Ensembling Models - Theory

6.2 Model Ensembling - Code

6.3 Unsupervised vs. Supervised Learning + Summary of NLP and Deep Learning - Theory

Whether you are a complete beginner or even at an intermediate level, this course will rapidly build your skills and confidence and have you doing your work in machine learning very quickly and productively.

You can go through the course with the confidence that it's taught by a highly experienced professional from the UK who has used Excel for over 15 years.

When you sign up, you get immediate access to the course. You can log into the lessons any time and there is no hurry to start as you have LIFETIME access!

You can go through the course with the confidence that it's taught by a highly experienced professional from the UK who has used Excel for over 15 years.

When you sign up, you get immediate access to the course. You can log into the lessons any time and there is no hurry to start as you have LIFETIME access!

Random Tree

About this course

This course is jam-packed with everything you need to get started with machine learning. We will look at various algorithm types, such as linear regression, logistic regression, decision trees, random forest, ensembled models, and beyond. Each model type will have lectures devoted to conceptualizing its mechanics, with some easy-to-follow math as well. In addition to conceptual lectures, there will be accompanying videos on key data science theory to improve accuracy and avoid common model pitfalls. Finally, each model type will have a coding video in Python to demonstrate the algorithm in action. We will also discuss common tips and tricks for cleaning data in preparation for machine learning, as well as an overview of machine learning in R.

What our Students say

“This course is excellent. The skills I have developed have given me the confidence to tackle advanced problems in an Investment Banking environment. Unlike other courses, the tutorials are practical, to the point and are relevant to professionals. I would highly recommend this course.”

Revin Melanis

Investment Banking PMO, London

Revin Melanis

Investment Banking PMO, London

“The VBA course has been a game changer as the ability to automate was something I longed for in order to be more efficient and more effective as a professional. This course is the complete package, I would recommend this course 100%”

Mike Doubek

InProject Manager, United Stated

Mike Doubek

InProject Manager, United Stated

“I applied many of the skills I learnt through your Excel course to automate many aspects of my work and it has been a huge help. My next step is to improve my VBA skills!”

Kiran Arian

Senior Financial Adviser, Canada

“I applied many of the skills I learnt through your Excel course to automate many aspects of my work and it has been a huge help. My next step is to improve my VBA skills!”

Kiran Arian

Senior Financial Adviser, Canada

Some of the Companies Our Students Work At

We are accredited by the CPD Standards Office

Frequently Asked Questions

How do you deliver your courses?

Once you have signed up then we will send you an email with a link to access our training dashboard, you can access all of our courses from this dashboard. All courses consist of video lessons that can be viewed on your device of choice and also to truly enhance your learning you will access lots of exercise files relevant to the lessons.

Are you certified by a governing body? *

We are fully accredited by the CPD (Continuing Professional Development) governing body. The CPD Certification Service is the independent CPD accreditation center working across all sectors, disciplines and further learning applications in the UK.

There are many options these days to learn, why go with your courses?

Great question, well frankly we make the best courses because all of our trainers have spent 10+ years using these skills in the real world! True knowledge is passed on from people who have been in the trenches, putting in long hours, solving real problems creatively. Our mission is to empower you with the very best of what works and more importantly, leave out what is unnecessary and thus a waste of your precious time.

How long will it take to learn these skills?

It depends on your level of commitment. Our students have seen incredible results from as little as 30 minutes a day. But remember the magic is in applying the skills as much as learning them. Our courses are designed with this in mind. On the very practical end we have students who squeeze in a few mins here and there on their commute and some do dedicated 2-3 hour weekend sessions. One of our most successful students Jayne managed to get up at 4am to do her learning! This paid off massively as it landed her a six figure analyst job in a bank!

Can my employer pay for my training?

Yes, this is quite common since we focus on helping actual corporate employees. Note that for teams we offer bulk discounts. However, this needs to be done with a corporate credit/debit card. We don’t accept transfer/remittances. Get in touch if you have any specific questions.

Do you have a refund policy?

Yes, we do, we will dust it off if you need it because it rarely happens! You have 30 days to let us know that the training isn’t right for you and we will happily refund.

How much does it cost to take your courses?

You can either purchase access to one course or all of our courses, which are listed above. What we have done in a post COVID-19 world is to keep our prices low to accommodate as many ambitious people from all over the world who are looking to upskill through our high level courses without the burden of high expense.

How much does it cost to take your courses?

Model Ensembling & Unsupervised Learning

Data Cleaning

Additional Machine Learning in R

MODULE 7: DATA CLEANING

7.1 Stepwise Selection - Theory

7.2 Stepwise Selection - Code

7.3 Label Encoding - Theory

7.4 Label Encoding - Code

7.5 Dummification - Theory

7.6 Dummification - Code

7.7 KNN - Theory

7.8 KNN - Code

7.9 Data Cleaning Walkthrough 1 (Housing Prices) - Code

7.10 Data Cleaning Walkthrough 2 (Titanic) - Code

MODULE 7: DATA CLEANING

7.1 Stepwise Selection - Theory

7.2 Stepwise Selection - Code

7.3 Label Encoding - Theory

7.4 Label Encoding - Code

7.5 Dummification - Theory

7.6 Dummification - Code

7.7 KNN - Theory

7.8 KNN - Code

7.9 Data Cleaning Walkthrough 1 (Housing Prices) - Code

7.10 Data Cleaning Walkthrough 2 (Titanic) - Code

MODULE 8: ADDITIONAL MACHINE LEARNING IN R

8.1 Simple Linear Regression in R - Code

8.2 Multiple Linear Regression in R - Code

8.3 Logistic Regression in R - Code

8.4 Decision Tree in R - Code

8.5 Random Forest in R - Code

8.6 R Data Cleaning Example Part 1 - Code

8.7 R Data Cleaning Example Part 2 - Code

MODULE 8: ADDITIONAL MACHINE LEARNING IN R

8.1 Simple Linear Regression in R - Code

8.2 Multiple Linear Regression in R - Code

8.3 Logistic Regression in R - Code

8.4 Decision Tree in R - Code

8.5 Random Forest in R - Code

8.6 R Data Cleaning Example Part 1 - Code

8.7 R Data Cleaning Example Part 2 - Code

Buy Now for $13 $69 80% OFF

Offer expires in

Microsoft Outlook Course

Outlook is one of the most fundamental tools used in the business world, it is the bedrock of communication whether by email or meeting and so we enlisted a highly experienced corporate professional and trainer to teach this. Her background working in high profile Global companies has given her an edge in understanding how to get the most out of Outlook and in the space of a few hours you will know more about Outlook than 90% of users!

MODULE 1: INTRODUCTION

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

MODULE 2: RULES, FORMATTING & FOLDERS

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

MODULE 3: PRINTING, SEARCHING & ATTACHMENTS

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

MODULE 1: INTRODUCTION

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

MODULE 2: RULES, FORMATTING & FOLDERS

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

MODULE 3: PRINTING, SEARCHING & ATTACHMENTS

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

MODULE 4: IN-EMAIL FUNCTIONALITY

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

MODULE 5: RECURRING TASKS & MEETINGS

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

MODULE 6: MORE MEETINGS & CALENDARS

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

MODULE 4: IN-EMAIL FUNCTIONALITY

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

MODULE 5: RECURRING TASKS & MEETINGS

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

MODULE 6: MORE MEETINGS & CALENDARS

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

Microsoft Powerpoint Course

We worked with a highly experienced corporate professional and trainer who brought many years of using Office in some of the biggest, most high profile Global companies and created an incredible training course which will have you mastering PowerPoint in a few hours.

MODULE 1: INTRO & BASICS

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

MODULE 2: SHAPES

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

MODULE 3: SMARTART, ORG CHART & ARROW DIAGRAM

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

MODULE 4: GUIDES, RULERS, GRIDLINES AND FORMATTING

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

MODULE 5: SECTIONS, SLIDE MASTER AND DEFAULT STYLES

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

MODULE 1: INTRO & BASICS

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

MODULE 2: SHAPES

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

MODULE 3: SMARTART, ORG CHART & ARROW DIAGRAM

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

MODULE 4: GUIDES, RULERS, GRIDLINES AND FORMATTING

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

MODULE 5: SECTIONS, SLIDE MASTER AND DEFAULT STYLES

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

MODULE 6: EXCEL AND WORD IN POWERPOINT

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

MODULE 7: SLIDE NUMBERS, M&A PRESENTATION AND MORE SHAPES

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

MODULE 8: FOOTNOTES, CONSISTENCY, REVIEWING & TABLES

8.1 How to add footnotes

8.2 How to check for consistency

8.3 Reviewing slides with markups

8.4 Inserting tables

MODULE 9: LOGO SLIDES, DESIGN IDEAS, SPELL CHECK, ADD NOTES & PRINTING

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

MODULE 6: EXCEL AND WORD IN POWERPOINT

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

MODULE 7: SLIDE NUMBERS, M&A PRESENTATION AND MORE SHAPES

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

MODULE 8: FOOTNOTES, CONSISTENCY, REVIEWING & TABLES

8.1 How to add footnotes

8.2 How to check for consistency

8.3 Reviewing slides with markups

8.4 Inserting tables

MODULE 9: LOGO SLIDES, DESIGN IDEAS, SPELL CHECK, ADD NOTES & PRINTING

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

Advanced Microsoft Word Course

Building on from our previous Word course, our instructor takes you through a much more advanced curriculum for Word users with more serious needs such as Legal resources, Office Managers, PA's and Business Analysts among others with advanced needs.

MODULE 1

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

MODULE 2

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

MODULE 3

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

3.7 Marking legal citations and creating TA

MODULE 1

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

MODULE 2

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

MODULE 3

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

3.7 Marking legal citations and creating TA

MODULE 4

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

MODULE 5

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

MODULE 4

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

MODULE 5

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

Microsoft Excel Course

Although we have produce some of the most effective Excel courses for professionals, there are still many people who don't use Excel as much and don't need to be experts in the application. For those people we highly recommend this course created by the very experienced accounting professional Andrew Dove. It also serves as a refresher course as well as for those with an interview coming up shortly and requiring a brush up of their Excel skills.

MODULE 1. Starting Excel

1.1 Introduction

1.2 Overview

MODULE 2. What You Can Enter Into Excel

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

MODULE 3. Sheets, Rows and Columns

3.1 Copy and Drag

3.2 Working with rows and columns

3.3 Working with sheets

MODULE 4. Functions, Ranges and Shortcuts

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

MODULE 5. Formatting and Conditional Formatting

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

MODULE 6. Printing

6.1 Icons Shapes and Formatting

6.2 Printing Page Layout

6.3 Printing Headers Footers

MODULE 7. Managing Data

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

MODULE 1. Starting Excel

1.1 Introduction

1.2 Overview

MODULE 2. What You Can Enter Into Excel

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

MODULE 3. Sheets, Rows and Columns

3.1 Copy and Drag

3.2 Working with rows and columns

3.3 Working with sheets

MODULE 4. Functions, Ranges and Shortcuts

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

MODULE 5. Formatting and Conditional Formatting

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

MODULE 6. Printing

6.1 Icons Shapes and Formatting

6.2 Printing Page Layout

6.3 Printing Headers Footers

MODULE 7. Managing Data

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

MODULE 8. Managing Text and Working with Formulas and Functions

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

MODULE 9. Charts

9.1 Chart Basics

9.2 Chart Series and Column Charts

9.3 Bar Charts

9.4 Pie Charts

9.5 Composite Charts

10. Pivot tables, Power Query and Dashboards

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

MODULE 11. Macros

11.1 What is a macro.

11.2 Recording a Macro

11.3 Relative and Absolute Macros

MODULE 12. Intro to VBE and VBA

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

MODULE 8. Managing Text and Working with Formulas and Functions

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

MODULE 9. Charts

9.1 Chart Basics

9.2 Chart Series and Column Charts

9.3 Bar Charts

9.4 Pie Charts

9.5 Composite Charts

10. Pivot tables, Power Query and Dashboards

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

MODULE 11. Macros

11.1 What is a macro.

11.2 Recording a Macro

11.3 Relative and Absolute Macros

MODULE 12. Intro to VBE and VBA

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

Microsoft Word Course

Our trainer is highly experienced corporate professional who brought her many years of using Office in some of the biggest, most high profile Global companies and created an incredible training course which will have you mastering Word in a few hours.

MODULE 1

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

MODULE 2

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

MODULE 3

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

MODULE 4

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

MODULE 5

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

MODULE 6

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

MODULE 1

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

MODULE 2

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

MODULE 3

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

MODULE 4

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

MODULE 5

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

MODULE 6

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

MODULE 7

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

MODULE 8

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

MODULE 9

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

MODULE 10

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

MODULE 11

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

MODULE 7

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

MODULE 8

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

MODULE 9

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

MODULE 10

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

MODULE 11

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

What You'll Learn in this Course

What You'll Learn in this Course

Earn an Accredited Certificate.

Earn an Accredited Certificate.

About this course

About this course

What our Students say

What our Students say

MODULE 2: RULES, FORMATTING & FOLDERS

MODULE 3: PRINTING, SEARCHING & ATTACHMENTS

MODULE 2: RULES, FORMATTING & FOLDERS

MODULE 3: PRINTING, SEARCHING & ATTACHMENTS

MODULE 5: RECURRING TASKS & MEETINGS

MODULE 6: MORE MEETINGS & CALENDARS

MODULE 5: RECURRING TASKS & MEETINGS

MODULE 6: MORE MEETINGS & CALENDARS

MODULE 2: SHAPES

MODULE 3: SMARTART, ORG CHART & ARROW DIAGRAM

MODULE 4: GUIDES, RULERS, GRIDLINES AND FORMATTING

MODULE 5: SECTIONS, SLIDE MASTER AND DEFAULT STYLES

MODULE 2: SHAPES

MODULE 3: SMARTART, ORG CHART & ARROW DIAGRAM

MODULE 4: GUIDES, RULERS, GRIDLINES AND FORMATTING

MODULE 5: SECTIONS, SLIDE MASTER AND DEFAULT STYLES

MODULE 7: SLIDE NUMBERS, M&A PRESENTATION AND MORE SHAPES

MODULE 8: FOOTNOTES, CONSISTENCY, REVIEWING & TABLES

MODULE 9: LOGO SLIDES, DESIGN IDEAS, SPELL CHECK, ADD NOTES & PRINTING

MODULE 7: SLIDE NUMBERS, M&A PRESENTATION AND MORE SHAPES

MODULE 8: FOOTNOTES, CONSISTENCY, REVIEWING & TABLES

MODULE 9: LOGO SLIDES, DESIGN IDEAS, SPELL CHECK, ADD NOTES & PRINTING

MODULE 2

MODULE 3

MODULE 2

MODULE 3

MODULE 5

MODULE 5

MODULE 2. What You Can Enter Into Excel

MODULE 3. Sheets, Rows and Columns

MODULE 4. Functions, Ranges and Shortcuts

MODULE 5. Formatting and Conditional Formatting

MODULE 6. Printing

MODULE 7. Managing Data

MODULE 2. What You Can Enter Into Excel

MODULE 3. Sheets, Rows and Columns

MODULE 4. Functions, Ranges and Shortcuts

MODULE 5. Formatting and Conditional Formatting

MODULE 6. Printing

MODULE 7. Managing Data

MODULE 9. Charts

10. Pivot tables, Power Query and Dashboards

MODULE 11. Macros

MODULE 12. Intro to VBE and VBA

MODULE 9. Charts

10. Pivot tables, Power Query and Dashboards

MODULE 11. Macros

MODULE 12. Intro to VBE and VBA

MODULE 2

MODULE 3

MODULE 4

MODULE 5

MODULE 6

MODULE 2

MODULE 3

MODULE 4

MODULE 5

MODULE 6

MODULE 8

MODULE 9

MODULE 10

MODULE 11

MODULE 8

MODULE 9

MODULE 10

MODULE 11

Nom nom! Cookies!