Publisher Course

We worked with the highly experienced corporate professional and trainer 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 Publisher in a few hours. 

The trainer will take you step by step from the very basics of setting up Publisher with personalisations and preferences through to designing and publishing a booklet. Along the way you will learn how to maximise your efforts with tips and tricks to speed up your work. You will see how to create mail merges that can distribute your publications at the click of a button. Claudia will also show you how to find and personalise templates for business cards and much, much more. 

OneDrive Course

OneDrive is the cloud storage service developed by Microsoft that allows you to store all your important files securely in one place and then access them virtually anywhere. Also, OneDrive makes it easy to share content with other people and collaborate in real-time using the Microsoft 365 integration.  

Whether you intend using OneDrive for personal or business use this crash course brought to you by  

Earn and Excel will teach you everything you need to know to understand the difference between them. You will be taught by the highly experienced corporate professional and trainer Claudia, who shares her many years of using Office in some of the biggest, most high-profile Global companies.  

By the end of this course you will fully understand how to use OneDrive and get the best out of it. 

Success Mindset & Productivity

Putting skills to one side, what else does it take for a professional to get career success? Sohail Anwar will take you through the techniques and strategies he used with the help of his own mentors to become a six figure professional. These are not the same rehashed ideas you read everywhere, they are some of the most powerful mindset and productivity strategies you will learn. Our students who have implemented these ideas have achieved major career breakthroughs.

MODULE  1 : MINDSET: BUILD A BETTER OPERATING SYSTEM

1.1 Introduction to Mentor

1.2 The single MOST important number in your career

1.3 The worst quality you can have (eliminate immediately)

1.4 How to use Excel to progress your career

1.5 Building Confidence

1.6 You need to do this in everything you do

1.7 The importance of flirting with the job market

1.8 Why you need a millionaire mindset to succeed

1.9 Excel Keyboard Shortcuts are bad for your career

1.10 Opportunity Cost

1.11 The Paradox of Choice

1.12 Your Personal RAID Log

1.13 Asset Based Thinking

1.14 Dopamine and Decision Making

1.15 Why you must place restrictions on your time

1.16 Consumer Vs. Producer

1.17 Priming yourself to do great work

Course Curriculum

LinkedIn Mastery Course

We can no longer ignore the fact that LinkedIn is now the go to resource used by recruiters to find candidates for new roles. We enlisted the no.1 LinkedIn Trainer in the world Mark Williams who uses not only his deep knowledge of LinkedIn but taps into his 20+ year career as a senior recruiter to give you insights you won’t find anywhere else. This is a 3-hour training he did exclusively for Earn and Excel students.

MODULE  1 : OVERVIEW, RECRUITERS AND THE PERFECT LINKEDIN PROFILE

1.1 LinkedIn overview

1.2 How Recruiters use LinkedIn

1.3 Profile completion & optimisation

MODULE  2 : BUILDING A NETWORK

2.1 Profile: Experience, Skills and Endorsements

2.2 Why you should create an ‘All Star’ level profile

2.3 Should you get recommendations

2.4 Is it worth paying for LinkedIn premium?

2.5 Best practice on accepting invitations

2.6 The best strategy for building your network

Course Curriculum

Win Your Next Job

Win Your Next Job is a course which will guide you in managing your career and breaking the six figure salary mark that t is geared towards professionals or aspiring professionals (working in Financial Services, Pharmaceuticals, Energy, Retail, Government sectors and more)who do a lot of analytical work especially with Excel, there is guidance in here that does not exist in other books or courses.

MODULE  1 : NEW RULES OF CAREER MANAGEMENT

1.1 Introduction to 'Selling You'

1.2 Managing Your career in the 21st Century

1.3 Modus Operandi: How and why you work the way you do

1.4 The Six principles that should govern how you should manage your career

1.5 The greatest investment that you can make in your career

1.6 See my Salary over my career and how Excel skills improved it

1.7 Diminishing returns of Excel skills

1.8 Excel careers that can earn you six figures

1.9 Problem Solvers vs Excel Experts

MODULE  2 : SET UP FOR CAREER SUCCESS

2.1 Finding work: The ‘Market’ vs your Network

2.2 Why you need to strongly consider contracting

2.3 How to transition in to contracting

2.4 Research: The why’s and how’s of setting yourself apart from everyone else

2.5 Research: How a company’s Finances affect your opportunities

2.6 How to win with Recruiters

2.7 How to search the market for work online

MODULE  3 : HOW TO PRESENT YOURSELF FOR SUCCESSFUL OUTCOMES

3.1 Narrative will make or break you

3.2 My entire process for constructing a narrative for Resume and Interview use

3.3 The art and importance of embellishing

3.4 Dealing with gaps on your CV/Resume

MODULE 4 : MASTERING CVS/RESUMES

4.1 Introduction to CV/Resume Structure: Generic Template

4.2 Improving narrative on a Resume

4.3 Bringing out Excel skills in a Resume

4.4 What my £200K ($300K) Resume looks like

5.5 Cover Letters Templates to use

Course Curriculum

Python for Web Development - Build the game Snake Online Course

In this course we will be building the classic game Snake with Python! We have found that even for experienced professionals, learning in a fun and engaging way like this will keep you motivated as you navigate through the challenge of learning a new coding language.

MODULE 1

Drawing to the screen

MODULE 2

Movement based on keyboard input

MODULE 3  

Increase snake length when eating and adjusting speed

Course Curriculum

Full Stack Web Developer: Build a Twitter Clone Online Course

The video course will instruct beginners on how to build a website similar to twitter. Where the user can tweet character limited messages, follow users and have a timeline.

The course will be broken up by topic and will offer viewers the ability to jump between videos if they wish to focus more on a given topic, such as the database or HTML / CSS

The chosen technologies will be simple and pure. We want to teach users the basics and not bury them in a list of frameworks.

Machine Learning 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.

R Programming Course

To be a well-rounded data scientist, it is imperative to know the ins and outs of both Python and R, the latter of which we will discuss in this course. In addition to all the primary coding functionality, we will learn more about what makes R unique, diving into how R leverages vectors and matrices to read in and work with data.

Additionally, we will discuss the mechanics of the powerful dplyr library, which allows extreme ease in manipulating datasets. We will then discuss data visualization, highlighting the advantages of the highly customizable ggplot2 library, which powers some of the most intricate graphs seen in data journalism and research today.

Finally, we will go through basic statistics and discuss the statistical tools within R, such as constructing confidence intervals, hypothesis testing, and ANOVA testing.

Python Programming Course

In this course, we will have a full overview of Python programming. We will start with fundamental Python functionality such as arithmetic, conditional statements, and working with basic data structures. We will then expand upon our working knowledge of data structures to work with full-blown datasets in the Pandas package. Within Pandas, we will be able to extract CSVs and Excel files of data, manipulate columns and rows, filter data, group together categories, and much more. Finally, once we’re able to tweak and transform datasets for analysis, we will discuss making basic visualizations in Python, which will allow us to take our insights and analysis to the next level.

Course Curriculum

Facebook Advertising Course

Facebook Ads are here to stay! The platform is large and capable enough to reach pretty much any audience which makes it perfect for businesses of all sizes. We worked with Angeles Jonske, a highly experienced Facebook Advertising expert with a broad spectrum of clients to create a training that will not just introduce you to Ads but have you implementing advanced strategies by the end of it!

MODULE 1 : BUSINESS MANAGER SET UP, TOUR AND TOOLS 

1.1 Business Manager Set Up

1.2 Business Settings Tour

1.3 Business Manager Tools

MODULE 2 : INTRO TO AUDIENCES - TOUR, CUSTOM AND LOOKALIKE AUDIENCES 

2.1 Audiences Tour and How to Use

2.2 Custom Audiences

2.3 Saved Audiences

2.4 Lookalike Audiences

MODULE 3 : AUDIENCE AND PIXELS

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

MODULE 4 : RUNNING SUCCESSFUL ADVERTISING CAMPAIGNS 

4.1 Introduction to Ads Manager

4.2 Columns

4.3 CBO vs ABO

4.4 Types of Campaigns

Course Curriculum

Introduction to Google Ads Course

Google Ads is the gold standard in online advertising. With a focus on search oriented advertising such as keyword, video and display as well as remarketing.

In this very brief course, in under 60 seconds we will get you up and running with your first google ads campaign. This training complements our marketing analytics training where it is very useful for the analyst to understand the mechanics of search advertising.

MODULE 1  

Getting Started

MODULE 2  

Campaign Creation

MODULE 3  

Search Campaigns

MODULE 4  

Display Campaigns

Course Curriculum

Google Analytics Course

Google Analytics is the most popular Web Analytics tool. It’s seamless integration with other Google products such as Google Ads and Google Data Studio make it a perfect tool in the arsenal for Analytical tracking and performance of your company’s online presence.

We work with highly experienced Agency Analyst Guido Hummel to build out a very practical hands on training to get you leveraging the best of Google Analytics.

MODULE 1 : INTRODUCTION TO GOOGLE ANALYTICS

1.1 Introduction to the course

1.2 What is Google Analytics?

1.2 Why Google Analytics?

MODULE 2 : INSTALLATION OF GOOGLE ANALYTICS

2.1 Installing the GA’s code

2.2 Verifying the installation of the GA’s code

MODULE 3 : REAL TIME, AUDIENCE, ACQUISITION, BEHAVIOUR AND CONVERSIONS

3.1 Real time, Audience, Acquisition

3.2 Behaviour

3.3 Conversions

MODULE 4 : DIMENSIONS, METRICS, DATA, HITS AND SCOPES

4.1 Dimensions and Metrics

4.2 How Google Analytics receives data

4.3 Hits and Scopes

Course Curriculum

Marketing Analytics with Google Data Studio Course

With each day, the breadth and depth of available Marketing Data grows and with that your skills and toolsets need to improve in order to keep up with the growing demand for Marketing Analytics work. We asked highly experienced Data scientist and Analytics consultant Jhony Chu, who has worked for large Global organisations to put together this course to teach you how to set up an Analytics Dashboard in Google Data Studio and use the data to help make your manager/executive make key strategic Marketing/Sales decisions. This course is perfect for those who come from a Sales/Marketing background and wish to make a transition to more analytical work or conversely, existing Analysts who would like to work in Marketing teams will greatly benefit from the course.

QuickBooks Online Course

QuickBooks is one of the best accounting applications available for small and medium sized companies. We asked highly experienced Accounting professional Janice England who works with QBO on a near daily basis to create a training course which will quickly get you using the application whilst utilising best practices.

MODULE 1 : INTRODUCTION TO QUICKBOOKS

1.1 Introduction to QuickBooks Online

1.2 Overview of Modules

1.3 Creating Your QuickBooks Online Log in

1.4 Signing into QuickBooks Online

1.5 The Dashboard – Restricted Access

1.6 The Dashboard – Regular Users – overview of Setup

1.7 Introduction to Connecting the Bank to QuickBooks Online

MODULE 2 : BANK ACCOUNTS

2.1 Create and Connect Your Bank Accounts

2.2 Introduction to Categorising Transactions

2.3 Categorising Transaction and Creating New Accounts

2.4 How to reconcile the Bank - Basic

MODULE 3 : QUICKBOOKS PHONE APP

3.1 Introduction to QuickBooks Phone App

3.2 Creating a quick sales invoice using QuickBooks phone App

3.3 Applying a payment to a sales invoice in QuickBooks App

3.4 How to edit customer details using QuickBooks phone App

3.5 How to use ReceiptSnap in QuickBooks phone App

Course Curriculum

Microsoft Sharepoint Course

As the corporate world adopts more remote working practices, the role of SharePoint as not just a document management tool but as a full collaboration tool is evolving. More than ever, SharePoint is playing a significant role in the success of companies managing their everyday work. Several of us experienced professionals at Earn and Excel collaborated and created a very practical and powerful training for SharePoint that will have you making the most of this brilliant tool for your team's needs.

MODULE 1 : INTRODUCTION TO SHAREPOINT

1.1 Set Up and Create Site

1.2 Settings and Navigation

1.3 News, Activity and Quick Links

1.4 Documents

MODULE 2 : APPS LIST AND LIBRARIES

2.1 Adding Data using Custom List

2.2 Views, Filters and Sorting

2.3 Site Contents and Document Libraries

MODULE 3 : WORKING WITH SHAREPOINT LIBRARIES

3.1 Summarise Value by

3.2 Multiple Subtotal

3.3 Percentage of column total

3.4 Difference From value as percentage

3.5 Double click for detail

3.6 Running Total

3.7 Grouping Year Month Quarter

3.8 Sorting

MODULE 4 : LIST VIEWS AND CALENDAR

4.1 List Views

4.2 Calendar - Part 1

4.3 Calendar - Part 2

4.4 Adding Calendar and Other Apps to Home Page

Course Curriculum

Microsoft Teams Course

Microsoft's collaboration tool: Teams has rapidly gained popularity since the most companies have been operating remotely. Companies are heavily reliant on it's ability to make the remote working experience more seamless. We worked with the highly experienced Microsoft specialist Henry Phillips in developing some outstanding training on using this tool, there is some solid best practice guidance as well more unconventional tips and strategies in getting the most out of it for, well, your team!

MODULE 1 : INTRODUCTION AND OVERVIEW

1.1 Introduction

1.2 Overview

MODULE 2 : CREATING AND MANAGING TEAMS

2.1 Creating Teams

2.2 Managing Teams

MODULE 3 : CHANNELS AND TEAM NAVIGATION

3.1 Channels

3.2 Channels and Teams Navigation

MODULE 4 : CHATS, CONVERSATIONS AND NOTIFICATIONS

4.1 Chats

4.2 Conversations and Notifications

MODULE 5 : AUDIO AND VIDEO CALLS AND MEETINGS 

5.1 Audio and Video Calls

5.2 Meetings

Course Curriculum

Microsoft Visio Course

Whether you need to map business processes, create floor layouts, build organisation charts, create swimlane diagrams or create any type of visual diagram, Visio is the industry standard for achieving this. We spent time with Process mappers, Architects, Engineers and numerous other professionals who actually use Visio to truly capture the key skills you need to leverage this powerful diagramming tool. You will be taught by the highly experienced corporate professional and trainer Claudia Carrozzo who shares her many years of using Office in some of the biggest, most high profile global companies. You will learn the basics of Visio and then build on that knowledge lesson by lesson until you have mastered the art of diagramming. We finish up by teaching you some tips and tricks to get the very best out of Visio.

Microsoft Project Course

It's a misconception that you need to spend many hours learning Microsoft Project. This is a tool to help you schedule and manage projects. So given our collective experience in Project Management within large global organisations, we have made a course that will get you up and running and working with best practice in a very short time frame.

We will teach you how to get the most out of Microsoft Project. Your tutor, Martin, has many years of Project Management, Planning, PMO and Scheduling in large global organisations and is ready to pass on to you what you really need to know to create and manage an efficient and effective project plan.

Whether you are a Project Manager, Product Manager, Planner, PMO, Business Analyst or any professional who needs to manage projects you will benefit from learning how to use Microsoft Project from us. Not only will we teach you the basic functions but more importantly we will teach you best practice. It's not all about what you should do but also what you should NOT do in order to have your project run smoothly. Your project may look neat and tidy on paper but if your resources are overallocated or your dependencies are wrongly set your project will likely run into trouble.

This course teaches you how to avoid the pitfalls and create a plan that is easily manageable regardless of size or complexity.

Microsoft PowerApps Course

Microsoft’s PowerApps hasn’t gained the popularity it deserves but it has the potential to be a gamechanger for companies. Without any coding knowledge, you are able to make your very own mobile apps that sync with Microsoft's tools. We asked the highly experienced Microsoft specialist Henry Phillips to create this training which will walk you through the capabilities of PowerApps and with a focus particularly on SharePoint and Power AUtomate (previously known as MS Flow) to automate lots of crucial every day work tasks with PowerApps in developing some outstanding training on using this tool, there is some solid best practice guidance as well more unconventional tips and strategies in getting the most out of it for, well, your team!

Course Curriculum

Microsoft OneNote Course

You would be mistaken for thinking OneNote is just about note taking, it's more than that, it's a productivity problem solver and so we enlisted a highly experienced corporate professional and trainer to teach this. The trainer's background working in high profile Global companies has given her an edge in understanding how to leverage OneNote and in the space of a few hours you will learn how to use this tool to become highly productive.

MODULE 1 : GETTING STARTED, INTRO, QAT, INSERTING NOTES.

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

MODULE 2 : CONTAINERS, TIME STAMP, PAGES, FORMATTING, BULLETS AND NUMBERS, SPACES

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

MODULE 3 : SECTIONS, SUBPAGES, SECTION GROUPS, TEMPLATES 

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

MODULE 4 : PAGE VERSIONS, HISTORY, QUICK NOTES, DOCK TO DESKTOP, LINKED NOTES.

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

MODULE 5 : INSERTING PRINTOUTS, ATTACHMENTS, EXCEL, TABLES.

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

Course Curriculum

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

Course Curriculum

Microsoft PowerPoint Course

We worked with a highly experienced corporate professional and trainer 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 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

Course Curriculum

Advanced Microsoft Word Course

Building on from our previous Word course, the trainer 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

Course Curriculum

Microsoft Word Course

We worked with a highly experienced corporate professional and trainer 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

Course Curriculum

SQL Server Course

There is far too much data in your company, and you have outgrown Excel, management is talking about bringing in a data expert but with our Excel to SQL course, it’s your time to shine as you take this challenge on

THIS COURSE IS FOR THREE TYPES OF PROFESSIONALS

1.You’ve been working with Excel and your companies’ data volumes have grown to the point where you need a more robust solution to handle the higher volume of data

2.You’ve started working in a company or a new project that already has SQL server and you need to get up to scratch to start querying it to create analysis and reports

3.Finally, you are a project manager or business analyst who won’t be building or querying a database but you need to understand databases so you can be a better bridge between IT and the business

Microsoft Access Course

Access has been around for over two decades and it’s not going anywhere due to it’s ability to be ‘up and running’ very quickly! Sure, big companies like big databases that serve the company needs on an enterprise level but the value of access is about what can be done at a local level, in small teams and on smaller or temporary projects.

For example if you are working in a small company and you want to be able to manage your data whether that be some kind of sales data, expenses, marketing information or project focus data and you need to get up and running quickly with a database to handle it, well Access is definitely the tool for you. You can be up and running in an afternoon with no need to get IT permissions or ask for a big budget! That’s why Access is known as a self-serving or end-user tool.

Given that is how Access is now used we have built a course with exactly that in mind, to teach you how to use Access for it to be a great end-user tool that you can get up and running quickly but also give your Database more advanced capability if you wish to.

In order to build the right course for you, we worked with Guy Vaccaro, who has been building Databases, including Access Databases for over two decades. Rather than build an unnecessarily long training, Guy has condensed his two decades of mastery in under 6.5 very focused hours, not learning unnecessary functionality so you can get up and running and maintaining your database in a very quick time frame!

Power BI: Advanced Course

Building on from our Intermediate level course, we are going to go deeper in to more advanced concepts and really leverage Power BI for high value report creation

MODULE 1: DATA PREPARATION

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

MODULE 2: ADVANCED DAX

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

MODULE 3: FORMATTING AND DESIGN

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

Course Curriculum

Power BI Course

Power BI is Microsoft’s play into the growing Business Intelligence reporting space, and they have created an incredible tool worthy of your attention. If your reporting requirements are more serious, that is you work with larger volumes of data, your data updates frequently, you create external facing reports/dashboards and need to share/publish your data online or via company intranets then Power BI may be your best option for building robust MI. We asked highly experienced BI Consultant, Andrew Ward to create this course and to bring you to an intermediate level of expertise. Andrew will guide you step by step and help you to create high value dashboards and reports by the end of this course

Course Curriculum

Power Pivot Course

PowerPivot helps you to deal with large volumes of data without resorting to the use of a Database. Ross Hughes shows you how to use PowerPivot to manage large volumes of data (Up to 1 million+ rows) with ease. You will learn about Data Modelling, DAX formulas, Measures and KPIs.

Course Curriculum

MODULE 1: GETTING STARTED WITH POWER PIVOT

1.1 Introduction to Power Pivot

1.2 Data Model Familiarisation

1.3 Data Modelling Concepts

1.4 Introduction to Data Types

MODULE 2: LOADING DATA

2.1 Loading data with PowerQuery

2.2 Loading Data from Excel tables

2.3 Introduction to using with Pivot Tables

2.4 Other data load options

2.5 Loading Data from an external database

MODULE 3: PIVOT TABLES AND REFRESH

3.1 More on Pivot Tables

3.2 Pivot  Tables and Relationships

3.3 Introduction to Refreshing Data

3.4 Refreshing Data via Connections

3.5 Refreshing Data from an external database

MODULE 4: INTRODUCTION TO MEASURES

4.1 Calculated Columns

4.2 Introduction to measures

4.3 Adding explicit measures with Autosum

4.4 Adding implicit measures

4.5 Adding explicit measures in Power Pivot menu

MODULE 5: HIERARCHIES AND RELATED COLUMNS

5.1 Introduction

5.2 Adding a hierarchy

5.3 Using hierarchies in a Pivot Table

5.4 Drill paths

5.5 Introduction to Related Columns

5.6 Related Columns in a hierarchy

5.7 Best practices with hierarchies

5.8 Editing hierarchies

Power Query Course

In this course, Ross Hughes leans on 30+ years of working with data to teach you the amazing Power Query Tool. It starts easy but soon goes deep into using Power Query to gather and transform your data with joins, un-pivoting and M-language which will make your analysis & reporting much easier.

MODULE 1: GETTING STARTED WITH POWER QUERY

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

MODULE 2: TRANSPOSE, PIVOT AND UN-PIVOT

2.1 Pre-preparing messy data

2.2 Appropriating our data with Transpose

2.3 Un-Pivoting Data

2.4 Pivoting Data

2.5 Creating a Pivot Chart

Course Curriculum

Excel VBA

If you are working in Excel on a daily basis, then we will teach you VBA and Macros skills that will help you win back at least half of your precious time!

MODULE 1: INTRODUCTION TO VBA & MACROS

1.1 Cells and Ranges

1.2 Copy And Paste

1.3 Controlling Fonts And Colouring Cells

1.4 Multiple Lines, Clearing And Column Widths

1.5 Building Logic With If

1.6 Building Logic With Select Case

1.7 The Importance Of Loops

1.8 Introduction To Automation

1.9 Loops And Selecting Ranges

1.10 Maneuvering And Macros

1.11 Constants And Variables

1.12 The Most Important Line In VBA You Need To Know!

1.13 Putting Together Everything So Far To Demonstrate Automation

MODULE 2:  AUTOMATING THE WORKSHEET

2.1 Macro File Formats

2.2 Developer Tab And Macro Security

2.3 Modules, Macros And Relative References

2.4 A First Look At Buttons

2.5 Charting Driven By Macros

2.6 Why Macros Can Go Wrong And What To Do About It

2.7 Handling Errors And Sheet Issues

2.8 Dynamic Charting: Part 1

2.9 Dynamic Charting: Part 2

2.10 Dynamic Charting: Part 3

2.11 End With

2.12 Controlling Autofilters

2.13 Controlling Formulas

MODULE 3: GOING DEEPER INTO LOOPING

3.1 5 Levels Of Looping Part 1

3.2 5 Levels Of Looping Part 2

3.3 5 Levels Of Looping Part 3

3.4 5 Levels Of Looping Part 4

3.5 5 Levels Of Looping Part 5

3.6 VBA Alternative: Gathering Data With Power Query

MODULE 4: AUTO-CREATE EXCEL FILES & TEMPLATES

4.1 Introduction

4.2 Creating An Input Sheet Template

4.3 Mass Producing Input Sheets 1: Set The Scene

4.4 Mass Producing Input Sheets 2: Worksheet Variables

4.5 Mass Producing Input Sheets 3: Autofilter Revisited And Paste special

4.6 Mass Producing Input Sheets 4: Manipulating Filter Criteria

4.7 Mass Producing Input Sheets 5 Creating A Unique List To Prepare For Looping

4.8 Mass Producing Input Sheets 6 Instantly Creating 25 Unique Input Excel Files

Course Curriculum

Excel Tools & Templates

In this section, we give you access to some of the best Excel and VBA solutions we have built in our professional careers and walk you through them in detail. Not the usual generic solutions that are found on the internet, these  templates, reports and solutions have played a huge in the professional success of it's creators. These will make your life a great deal easier!

EVERYDAY EXCEL TOOLS & TEMPLATES

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

Course Curriculum

Ultimate Pivot Tables Course

For some people that work with Excel, Pivot Tables present a great opportunity to seamlessly deal with Data analysis and reporting. The training has been created by our founder in conjunction with highly experienced corporate analysts who use Pivot Tables on a daily basis in a corporate environment and at just over two hours you will be using this training immediately.

MODULE 1: INTRODUCTION & DATA PREPARATION

1.1.Pivot Intro

1.2.Pivot Cache

1.3. Altering the Data Source

1.4. Unpivot data to a long boring list

1.5. Moving row and column

1.6. Expand and Collapse field

MODULE 2: LAYOUT AND FORMATS

2.1 Format Error and Empty cells

2.2 Change Layout of Pivot Table

2.3 Place Pivot Table

2.4 Pivot Table Styles

2.5 Format Content in Pivot

MODULE 3: CORE PIVOT TABLE ANALYSIS

3.1 Summarise Value by

3.2 Multiple Subtotal

3.3 Percentage of column total

3.4 Difference From value as percentage

3.5 Double click for detail

3.6 Running Total

3.7 Grouping Year Month Quarter

3.8 Sorting

Course Curriculum

Excel Expert Course 

There is no other Excel course like this on this out there. You will learn directly from a professional who has used Excel to further his career from junior to senior levels. This is not a study of everything that Excel has to offer, in fact you will learn how most of Excel’s functions are distracting and with the instructors experience you will learn only the best Excel formulas, functions and tools you need to do great work.

INTRO TO 80:20 EXCEL AND FINDING THE RIGHT INFORMATION

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

ADVANCED LOOKUPS & LOGIC TO CREATE POWERFUL SOLUTIONS

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

DEALING WITH NON-NUMERICAL DATA

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

Course Curriculum

Excel: Beginner To Intermediate Course

This concise course is perfect for getting complete beginners comfortable with Excel as well as those who have been away from Excel for a long time. In fact, I recommend all students at the very least work through this once to ensure you are prepared for the more advanced material to come. By the end of this approximate 90mins of training, you will be at an Intermediate level of understanding Excel.

1. Navigating around Excel

2. Entering Information

3. Navigating without the Mouse

4. Basic Formatting

5. Dragging & Autofill

6. Copy & Paste

7. Clearing cells

8. Inserting & Deleting

9. Date Basics

10. Introduction to Formulas

11. Introduction to Formulas: Part 2

12. Introduction to Formulas: Autosum

13. More on Worksheets

14. More Borders

15. Printing considerations

16. Conditional Formatting

17. Charts

18. Autofilter

19. Sorting Data

20. Introduction to Text Data

21. Named Ranges

22. Data Validation

23. Advanced Data Formatting

Course Curriculum