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

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

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!

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