Microsoft-Excel-Online-Training-Courses-for-Beginners-and-Professionals_

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.

Course Curriculum

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

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.

Course Curriculum

(Click for details)

INTRO TO 80:20 EXCEL AND FINDING THE RIGHT INFORMATION

ADVANCED LOOKUPS & LOGIC TO CREATE POWERFUL SOLUTIONS

DEALING WITH NON-NUMERICAL DATA

MASTERING THE ART OF SUMMARISING YOUR WORK

DEEPER INTO BUILDING WORLD CLASS REPORTS AND SOLUTIONS

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.

Course Curriculum

(Click for details)

MODULE 1: INTRODUCTION & DATA PREPARATION

MODULE 2: LAYOUT AND FORMATS

MODULE 3: CORE PIVOT TABLE ANALYSIS

MODULE 4: FILTERS AND SLICERS

MODULE 5: ADVANCED ANALYSIS

MODULE 6: VISUALS AND REPORTS

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!

List of Tools & Templates

Everyday Excel Tools & Templates

Advanced Corporate Excel VBA Tools, Reports & Solutions

Excel VBA Course

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!

Course Curriculum

(Click for details)

Module 1: INTRODUCTION TO VBA & MACROS

Module 2: AUTOMATING THE WORKSHEET

Module 3: GOING DEEPER INTO LOOPING

Module 4: AUTO-CREATE EXCEL FILES & TEMPLATES

Module 5: AUTOMATE DATA COLLATION & ANALYSIS

Module 6: CONTROLLING POWERPOINT FROM EXCEL

Module 7: CONTROLLING WORD FROM EXCEL

Bonus Module: THE VBA TOOLS & TEMPLATES VAULT

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.

Course Curriculum

(Click for details)

MODULE 1: GETTING STARTED WITH POWER QUERY

MODULE 2: TRANSPOSE, PIVOT AND UN-PIVOT

MODULE 3: COMBINING DATA FROM TWO OR MORE DATA SETS

MODULE: 4.DUPLICATION AND PARAMETERS

MODULE 5: STEPS, GROUPS AND DEPENDENCIES

PowerPivot 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

(Click for details)

MODULE 1: Getting Started With Power Pivot

MODULE 2: Loading Data

MODULE 3: Pivot Tables And Refresh

MODULE 4: Introduction To Measures

MODULE 5: Hierarchies And Related Columns

MODULE 6: Deeper Into DAX

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

(Click for details)

MODULE 1: INTRODUCTION TO POWER BI

MODULE 2: WORKING WITH DATA IN POWER BI

MODULE 3: DATA ANALYSIS WITH POWER BI

MODULE 4: POWER BI DASHBOARDS

MODULE 5: SHARING AND PUBLISHING POWER BI

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

Course Curriculum

(Click for details)

MODULE 1: Data Preparation

MODULE 2: Advanced DAX

MODULE 3: Formatting and Design

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!

Course Curriculum

(Click for details)

Module 1: Creating Tables

Module 2: Creating Queries

Module 3: Action Queries

Module 4: Linking Tables

Module 5: Creating Forms

Module 6: Creating SubForms

Module 7: Creating SplitForms

Module 8: Creating Reports

Module 9: Exporting Data

Module 10: Importing Data

Module 11: Building VBA/Macros

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

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
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
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

Course Curriculum

(Click for details)

MODULE 1: INTRODUCTION TO SQL SERVER

MODULE 2: TABLE STRUCTURES

MODULE 3: DATABASES

MODULE 4: JOINS

MODULE 5: ADVANCED FEATURES

Microsoft Word Course

We worked with the highly experienced corporate professional and trainer Claudia Carrozzo 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.

Course Curriculum

(Click for details)

MODULE 1

MODULE 2

MODULE 3

MODULE 4

MODULE 5

MODULE 6

MODULE 7

MODULE 8

MODULE 9

MODULE 10

MODULE 11

Advanced Microsoft Word Course

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

Course Curriculum

(Click for details)

MODULE 1

MODULE 2

MODULE 3

MODULE 4

MODULE 5

Microsoft PowerPoint Course

Course Curriculum

(Click for details)

MODULE 1 - INTRO & BASICS

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 6 - EXCEL AND WORD IN POWERPOINT

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

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 the highly experienced corporate professional and trainer Claudia Carrozzo to teach this. Claudia's background working in high profile Global companies has given her an edge in understanding how to lget the most out of Outlook and in the space of a few hours you will know more about Outlook than 90% of users!

Course Curriculum

(Click for details)

MODULE 1: INTRODUCTION

MODULE 2: RULES, FORMATTING & FOLDERS

MODULE 3: PRINTING, SEARCHING & ATTACHMENTS

MODULE 4; IN-EMAIL FUNCTIONALITY

MODULE 5: RECURRING TASKS & MEETINGS

MODULE 6: MORE MEETINGS & CALENDARS

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 the highly experienced corporate professional and trainer Claudia Carrozzo to teach this. Claudia'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.

Course Curriculum

(Click for details)

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

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

MODULE 3: SECTIONS, SUBPAGES, SECTION GROUPS, TEMPLATES

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

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

MODULE 6: SCREEN CLIPPING, INSERTING PICTURES & SYMBOLS, SEND TO ONENOTE, TEXT TO INK.

MODULE 7: VIEW TAB, SIDE PANES, TAGS, AUDIO RECORDING.

MODULE 8: RESEARCH, LINKS, TOC, PEN & HIGHLIGHTER, SHAPES.

MODULE 9: EQUATIONS, MATH, SENDING & EXPORTING, LINKING CONTACTS & APPOINTMENTS.

MODULE 10: BACKUPS, RESTORES, PASSWORD PROTECTING.

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.

Course Curriculum

(Click for details)

MODULE 1. Starting Excel

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 8. Managing Text and Working with Formulas and Functions

MODULE 9. Charts

10. Pivot tables, Power Query and Dashboards

MODULE 11. Macros

MODULE 12. Intro to VBE and VBA

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.

What you'll learn:

Navigation - Overview
Task Dependencies
Calenders
Costs
Resource Management - Overallocation
Constraints & Deadlines
Baselines
Reports
Project Templates

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.

Course Curriculum

(Click for details)

Module 1: VISIO INTRODUCTION

Module 2: VISIO ESSENTIALS

Module 3: VISIO ESSENTIAL DIAGRAM SKILLS

Module 4: INSERTING AND FORMATTING TEXT IN VISIO

Module 5: UNDERSTANDING AND WORKING WITH CONNECTORS

Module 6: VISIO CONNECTORS IN-DEPTH

Module 7: WORKING WITH LAYERS

Module 8: CREATING FLOWCHARTS ORG CHARTS, SWIMLANE DIAGRAMS AND APPLYING THEMES

Module 9: ORGANISING PAGES, UNDERSTANDING AUTOSIZE AND APPLYING BACKGROUNDS

Module 10: WORKING WITH VISIO SHAPE DATA

Module 11: CREATING AND EDITING VISIO SHAPE DATA REPORT

Module 12: TIME SAVING TRICKS IN ALIGNING AND REPOSITIONING SHAPES IN CHARTS AND DIAGRAMS

Module 13: WORKING WITH CONTAINERS AND CALLOUTS

Module 14: LINKING EXTERNAL DATA TO VISIO DIAGRAMS

Module 15: INTRODUCTION TO ADVANCED DIAGRAMS

Module 16: COLLABORATING WITH PEOPLE BY USING VISIO

Module 17: EXPORTING VISIO DRAWINGS

Module 18: MORE TRICKS AND TIPS AND HOW TO TRULY SPEED UP WORK BY CREATING YOUR OWN STENCILS

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!

Course Curriculum

(Click for details)

MODULE 1. Introduction and Overview

MODULE 2. Creating and Managing Teams

MODULE 3. Channels and Team Navigation

MODULE 4. Chats, Conversations and Notifications

MODULE 5. Audio and Video Calls and Meetings

MODULE 6. Working with Files

MODULE 7. Apps, Wikis and Guest Access

MODULE 8. Whiteboard, Search, Enhancements and Shifts

MODULE 9. Behind the Scenes

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.

Course Curriculum

(Click for details)

MODULE 1: Introduction to SharePoint

MODULE 2: Apps List and Libraries

MODULE 3: Working with SharePoint Libraries

MODULE 4: List Views and Calendar

MODULE 5: Working with Site Pages

MODULE 6: Syncing with OneDrive

MODULE 7: Site Columns and Content Types

MODULE 8: Managing Sub Sites and User Permissions:

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

(Click for details)

MODULE 1: PowerApps Introduction

MODULE 2: Create Mobile App and Customise SharePoint List Form

MODULE 3: Templates

MODULE 4: Flow Set Reminder and Sign Off

MODULE 5: SharePoint List Item, Flow Mobile Button and BI

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.

Course Curriculum

(Click for details)

MODULE 1. Introduction to QuickBooks

MODULE 2. Bank Accounts

MODULE 3. QuickBooks Phone App

MODULE 4. Processing Receipts and Invoices

MODULE 5. Other Functions in QuickBooks Online

Microsoft Xero Course

Xero is one of the accounting industry’s best applications available for small and medium sized companies.

We asked highly experienced Accounting professional Janice England who works with Xero on a near daily basis to create a training course which will quickly get you using the application whilst utilising best practices.

Course Curriculum

1. Xero Introduction

2.Xero Set Up Creating Your Xero Log In

4. Xero Overview

5. Set Up Overview

6. Connecting your Bank Account to Xero

7. Connecting the Bank Feed

8.Introduction to the Chart of Accounts

9. Categorising Bank Transactions and Simple Bank Reconciliation

10. Introduction to the Xero Phone App

11. Create A Sales Invoice Using the Phone App

12. Allocate a customer's payment using the App

13. Creating a contact using the App

14. Entering a Receipt using the Xero App

15. Entering a Bill Using the Xero App

16. Entering a suppliers invoice

17. Paying a Bill

18. Bank Reconciliation Revisited

19. Other features available in Xero

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

(Click for details)

Module 1: Python Fundamentals

Module 2: Data Structures, Conditionals and Loops

Module 3: Pandas

Module 4: Data Visualization

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.

Course Curriculum

(Click for details)

Module 1: R Fundamentals

Module 2: Working with Data:Dplyr

Module 3: Data Visualization in R

Module 4: Statistics

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.

Course Curriculum

(Click for details)

Module 1: Simple Linear Regression

Module 2: Multiple Linear Regression

Module 3: Logistic Regression

Module 4: Decision Tree

Module 5: Random Tree

Module 6: Model Ensembling & Unsupervised Learning

Module 7: Data Cleaning

Module 8: Additional Machine Learning in R

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.

Course Curriculum

(Click for details)

Module 1: Introduction & Reporting

Module 2: Understanding your Audience

Module 3: Performance

Module 4: Marketing Channels

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.

Course Curriculum

(Click for details)

Module 1: Introduction to Google Analytics

Module 2: Installation of Google Analytics

Module 3: Real time, Audience, Acquisition, Behaviour and Conversions

Module 4: Dimensions, Metrics, Data, Hits and Scopes

Module 5: Segmentations, Basic and Advanced Reports

Module 6: Hierarchical organization of GA, Goals and Outro

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.

Course Curriculum:

1. Getting Started

2. Campaign Creation

3. Search Campaigns

4. Display Campaigns

5. Smart Campaigns

6. Video Campaigns

7. Remarketing Campaigns

8. Maintenance & Optimization

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!

Course Curriculum

(Click for details)

MODULE 1. Business Manager Set Up, Tour and Tools

MODULE 2. Intro to Audiences - Tour, Custom and Lookalike Audiences

MODULE 3. Audience and Pixels

MODULE 4. Running Successful Advertising Campaigns

MODULE 5. Setting up an Ad

MODULE 6. Scaling, Optimizing and Strategies

MODULE 7. Course Notes, Tools and Troubleshooting

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.

Course Curriculum

(Click for details)

MODULE 1: New rules of Career Management

MODULE 2: Set up for Career Success

MODULE 3: How to Present Yourself For Successful Outcomes

MODULE 4: Mastering CVs/Resumes

MODULE 5: Mastering Interviews & Negotiation

MODULE 6: How to go from Good to Great

MODULE 7: The Earn & Excel Career Productivity System

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.

Course Curriculum

(Click for details)

MODULE 1: Overview, Recruiters and the perfect LinkedIn Profile

MODULE 2: Building a Network

MODULE 3:Job Searching Techniques

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.

Course Curriculum

(Click for details)

excel | data analysis | Business intelligence | Microsoft office | accounting | data science | Digital marketing

Learn Skills That Will Make You Invaluable To Your Company

Click Each Category To See Our Range Of Courses

Excel Courses & Templates

Data Analysis & Business Intelligence Courses

Microsoft Office Courses

Accounting Courses

Data Science Courses

Digital Marketing Courses

Career Courses (Premium)

Student Success!

A. Saleem

Investment Banking PMO, London

James Barton-Ginger

Senior Project Manager, New Zealand

Kiran Arain

Senior Financial Analyst, Canada

Mike Doubek

Project Manager, US

Learn skills that will...

Earn you the respect of your team

Earn you a greater salary

Earn and Excel

Some Of The Companies Our Students Work At

Some of our in-depth free content

Excel: Beginner To Intermediate Course

Excel Expert Course

INTRO TO 80:20 EXCEL AND FINDING THE RIGHT INFORMATION

ADVANCED LOOKUPS & LOGIC TO CREATE POWERFUL SOLUTIONS

DEALING WITH NON-NUMERICAL DATA

MASTERING THE ART OF SUMMARISING YOUR WORK

DEEPER INTO BUILDING WORLD CLASS REPORTS AND SOLUTIONS

Ultimate Pivot Tables Course

​MODULE 1: INTRODUCTION & DATA PREPARATION

​MODULE 2: LAYOUT AND FORMATS

​MODULE 3: CORE PIVOT TABLE ANALYSIS

​MODULE 4: FILTERS AND SLICERS

​MODULE 5: ADVANCED ANALYSIS

MODULE 6: VISUALS AND REPORTS

Excel: Tools & Templates

Everyday Excel Tools & Templates

Advanced Corporate Excel VBA Tools, Reports & Solutions

Excel VBA Course

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

Module 2: AUTOMATING THE WORKSHEET

Module 3: GOING DEEPER INTO LOOPING

Module 4: AUTO-CREATE EXCEL FILES & TEMPLATES

Module 5: AUTOMATE DATA COLLATION & ANALYSIS

Module 6: CONTROLLING POWERPOINT FROM EXCEL

Module 7: CONTROLLING WORD FROM EXCEL

Bonus Module: THE VBA TOOLS & TEMPLATES VAULT

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

​MODULE 2: TRANSPOSE, PIVOT AND UN-PIVOT

​MODULE 3: COMBINING DATA FROM TWO OR MORE DATA SETS

​MODULE: 4.DUPLICATION AND PARAMETERS

​MODULE 5: STEPS, GROUPS AND DEPENDENCIES

PowerPivot 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.

MODULE 1: Getting Started With Power Pivot

​MODULE 2: ​Loading Data

MODULE 3: Pivot Tables And Refresh

MODULE 4: Introduction To Measures

MODULE 5: Hierarchies And Related Columns

MODULE 6: Deeper Into DAX

Power BI Course

​MODULE 1: INTRODUCTION TO POWER BI

​MODULE 2: WORKING WITH DATA IN POWER BI

​MODULE 3: DATA ANALYSIS WITH POWER BI

​MODULE 4: POWER BI DASHBOARDS

​MODULE 5: SHARING AND PUBLISHING POWER BI

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

MODULE 2: Advanced DAX

​MODULE 3: ​Formatting and Design

Microsoft Access Course

Module 1: Creating Tables

MODULE 1: INTRODUCTION & DATA PREPARATION

MODULE 2: LAYOUT AND FORMATS

MODULE 3: CORE PIVOT TABLE ANALYSIS

MODULE 4: FILTERS AND SLICERS

MODULE 5: ADVANCED ANALYSIS

MODULE 1: GETTING STARTED WITH POWER QUERY

MODULE 2: TRANSPOSE, PIVOT AND UN-PIVOT

MODULE 3: COMBINING DATA FROM TWO OR MORE DATA SETS

MODULE: 4.DUPLICATION AND PARAMETERS

MODULE 5: STEPS, GROUPS AND DEPENDENCIES

MODULE 2: Loading Data

MODULE 1: INTRODUCTION TO POWER BI

MODULE 2: WORKING WITH DATA IN POWER BI

MODULE 3: DATA ANALYSIS WITH POWER BI

MODULE 4: POWER BI DASHBOARDS

MODULE 5: SHARING AND PUBLISHING POWER BI

MODULE 3: Formatting and Design

MODULE 1: INTRODUCTION TO SQL SERVER

MODULE 2: TABLE STRUCTURES

MODULE 3: DATABASES

MODULE 4: JOINS

MODULE 5: ADVANCED FEATURES

MODULE 1

MODULE 2

MODULE 3

MODULE 4

MODULE 5

MODULE 1

MODULE 2

MODULE 3

MODULE 4

MODULE 5

MODULE 1 - INTRO & BASICS

MODULE 2 - SHAPES

MODULE 3 - SMARTART, ORG CHART & ARROW DIAGRAM

MODULE 5 - SECTIONS, SLIDE MASTER AND DEFAULT STYLES

MODULE 6 - EXCEL AND WORD IN POWERPOINT

MODULE 8 - FOOTNOTES, CONSISTENCY, REVIEWING & TABLES

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

MODULE 1: INTRODUCTION

MODULE 2: RULES, FORMATTING & FOLDERS

MODULE 3: PRINTING, SEARCHING & ATTACHMENTS

MODULE 6: MORE MEETINGS & CALENDARS

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

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

MODULE 3: SECTIONS, SUBPAGES, SECTION GROUPS, TEMPLATES

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

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

MODULE 6: SCREEN CLIPPING, INSERTING PICTURES & SYMBOLS, SEND TO ONENOTE, TEXT TO INK.

MODULE 7: VIEW TAB, SIDE PANES, TAGS, AUDIO RECORDING.

MODULE 8: RESEARCH, LINKS, TOC, PEN & HIGHLIGHTER, SHAPES.

MODULE 9: EQUATIONS, MATH, SENDING & EXPORTING, LINKING CONTACTS & APPOINTMENTS.

MODULE 10: BACKUPS, RESTORES, PASSWORD PROTECTING.

MODULE 1. Starting Excel