Get $1 credit for every $25 spent!

The Premium Microsoft Office & Data Apps Certification Bundle

Ending In:
Add to Cart - $39.99
Add to Cart ($39.99)
$1,782
97% off
wishlist
Courses
18
Lessons
810
Enrolled
450

What's Included

Product Details

Access
Lifetime
Content
6.0 hours
Lessons
84

Microsoft Excel (365): Crash Course

Speed Up Your Data Work with Beginner to Advanced Content on Excel

By Earn and Excel | in Online Courses

It is a perfect course for you if you are about to start a new role or project, or perhaps you are preparing for or a fairly in-depth interview in the next few days and you want to spend a few evenings or the weekend to bolster your Excel skills! The course is presented by the highly experienced Andrew Dove an accounting professional from the UK and covers the most important Excel topics that professionals need to be accomplished in. This course will help you get the best out of Excel.

4.3/5 average rating: ★ ★ ★ ★

  • Access 84 lectures & 6 hours of content 24/7
  • Learn introductory topics such as the Excel interface, sheets, rows, columns & data types
  • Get comfortable with Functions (Basic, Copying Functions, Named Ranges)
  • Format the sheet, numbers, rows, cells & more
  • Sort, filter, & validate data
  • Learn advanced functions such as VLOOKUPS, INDEX, MATCH, IF, & more
  • Consolidate data with Power Query
  • Speed up your work by recording and tweaking Macros
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel

Course Outline

  • Your First Program
  • 1 Starting Excel
    • Course Materials
    • 1.1 Starting Excel - 1:29
    • 1.2 Understanding Excel Interface - 4:29
    • 1.3 Getting Familiar with The Excel Workbook and Worksheets - 1:33
    • 1.4 Explaining the Ribbon - 5:45
    • 1.5 Saving an Excel File - 2:54
  • 2 What you can enter
    • 2.1 Combined What you can enter in a cell - 7:42
    • 2.2 Relative and Absolute Cell Referencing - 3:12
    • 2.3 Entering Formula - 1:56
    • 2.4 Order of Operations - 2:59
    • 2.5 Date Serial Numbers - 4:24
  • 3 Sheets, rows and columns
    • 3.1 Copy and Drag - 1:41
    • 3.2 Working with rows and columns - 10:18
    • 3.3 Working with sheets - 5:27
  • 4 Functions, ranges and shortcuts
    • 4.1 Functions - 3:49
    • 4.2 SUM Function - 3:23
    • 4.3 Copy and Drag Formula - 4:56
    • 4.4 More basic functions - 2:48
    • 4.5 Named Ranges - 8:42
    • 4.6 Names Constants and Formula - 3:52
    • 4.7 Shortcuts - 3:43
    • 4.8 More Shortcuts - 6:49
  • 5 Formatting and conditional formatting
    • Course Materials
    • 5.1 Formatting Font - 4:57
    • 5.2 Formatting Alignment - 2:59
    • 5.3 Formatting Borders - 2:42
    • 5.4 Formatting Numbers - 3:17
    • 5.5 Conditional Formatting PreConfigured - 4:45
    • 5.6 Conditional Formatting with Formula - 11:04
    • 5.7 Conditional Formatting Dialogue Box Formula Trick - 3:15
  • 6 Printing
    • 6.1 Icons Shapes and Formatting - 8:52
    • 6.2 Printing Page Layout - 8:43
    • 6.3 Printing Headers Footers - 2:31
  • 7 Managing data
    • 7.1 Data Sort - 5:55
    • 7.2 Filtering - 5:35
    • 7.3 Tables - 6:43
    • 7.4 Text to Columns - 5:20
    • 7.5 Flash Fill - 2:53
    • 7.6 Data Validation - 5:22
    • 7.7 Group and Outline - 4:05
    • 7.8 Freeze Panes - 1:47
  • 8 Managing text and working with formulas and functions
    • 8.1 Relative and Absolute Referencing - 5:47
    • 8.2 VLOOKUP - 6:51
    • 8.3 Index Match - 6:35
    • 8.4 IF - 2:10
    • 8.5 Nested If - 3:18
    • 8.6 Countif Countifs - 6:56
    • 8.7 SUMIF SUMIFS - 5:25
    • 8.8 LEN - 1:59
    • 8.9 RIGHT LEFT MID - 5:07
    • 8.11 Common Error Types - 2:18
    • 8.10 SEARCH - 1:50
    • 8.12 IFERROR - 3:08
  • 9 Charts
    • 9.1 Chart Basics - 5:09
    • 9.2 Chart Series and Column Charts - 5:27
    • 9.3 Bar Charts - 5:16
    • 9.4 Pie Charts - 4:28
    • 9.5 Composite Charts - 3:17
  • 10 Pivot tables, Power Query and Dashboards
    • 10.1 Power Query Intro - 4:46
    • 10.2 Power Query Consolidation - 2:47
    • 10.3 Pivot Tables - 2:12
    • 10.4 Setting up a Pivot Table - 4:22
    • 10.5 Pivot Table Field Settings - 4:06
    • 10.6 Pivot Table Calculated Fields - 1:55
    • 10.7 Pivot Table Groupings - 2:10
    • 10.8 Pivot Table Slicers and Timelines - 4:52
    • 10.9.1 Dashboards Part 1 - 6:26
    • 10.9.2 Dashboards Part 2 - 7:45
  • 11 Macros
    • 11.1 What is a macro - 1:58
    • 11.2 Recording a Macro - 1:44
    • 11.3 Relative and Absolute Macros - 6:00
  • 12 Intro to VBE and VBA
    • 12.1 Introduction to VBE - 8:19
    • 12.2 Object Model - 9:11
    • 12.3 Module Worksheets Classes - 7:50
    • 12.4 Variables and Constants - 10:23
    • 12.5 Vba Formatting - 10:38
    • 12.6a If Statement - 7:08
    • 12.6b Select Case - 6:25
    • 12.7a For Loop - 10:13
    • 12.7b DoWhile DoUntil Loop - 2:47
    • 12.7c ForEach Loop - 4:54
    • 12.8a Errors - 6:00
    • 12.8b Errors - 4:24
    • 12.9 Consolidate - 6:33

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
11

Microsoft PowerApps

Create Mobile Apps Without Coding

By Earn and Excel | in Online Courses

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 can make your very own mobile apps that sync with Microsoft's tools. This course will walk you through the capabilities of PowerApps and focus particularly on SharePoint and Power Automate to automate lots of crucial everyday work tasks with PowerApps in developing some outstanding training on using this tool. There are some solid best practice guidance and more unconventional tips and strategies in getting the most out of it for, well, your team!

4.1/5 average rating: ★ ★ ★ ★

  • Access 11 lectures & 1 hour of content 24/7
  • Walk through the capabilities of PowerApps
  • Create mobile apps
  • Customize SharePoint list forms
  • Work with templates & PowerAutomate
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft PowerApps

Course Outline

  • 1 Power Apps Introduction
    • 1.1 Power Platform Course Introduction - 11:00
  • 2 Create Mobile App and Customise SP List Form
    • 2.1 Create Mobile App from SP List - 9:21
    • 2.2 Customise SP List Form - 3:18
  • 3 Templates
    • 3.1 PA Templates - 10:24
    • 3.2 Flow Templates - 7:03
  • 4 Flow Set Reminder and Sign Off
    • 4.1 Flow Set Reminder in SP List - 5:24
    • 4.2 Flow SP Sign Off - 5:08
    • 4.3 Robotic Process Automation with Power Automate - 10:33
  • 5 SP List Item, Flow Mobile Button and BI
    • 5.1 Flow SP List Item - 8:02
    • 5.2 Flow Mobile Button - 7:01
    • 5.3 BI - 6:17

View Full Curriculum


Access
Lifetime
Content
3.0 hours
Lessons
32

Microsoft SharePoint

Manage Subsites & User Permissions to Add Powerful Controls to Your Document Management Experience

By Earn and Excel | in Online Courses

As the corporate world adopts more remote working practices, SharePoint's role 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 companies' success in managing their everyday work. Several of us experienced professionals at Earn and Excel collaborated and created an efficient and powerful training for SharePoint that will have you making the most of this brilliant tool for your team's needs. This course introduces you to SharePoint and how it is important to day-to-day organization tasks.

4.1/5 average rating: ★ ★ ★ ★

  • Access 32 lectures & 3 hours of content 24/7
  • Understand why SharePoint is so important for the modern day organization
  • Manage subsites & user permissions to add powerful controls
  • Explore SharePoint apps, lists & libraries
  • Work with SharePoint libraries to maximize document management capabilities
  • List views & calendar for a visual interpretation of your team's assets
  • Work with site pages to enhance & customize your SharePoint experience
  • Sync with OneDrive to connect data sources
  • Site columns & content types to further customize the management of your document assets
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft SharePoint

Course Outline

  • 1 Introduction to SharePoint
    • 1.1 Set Up and Create Site - 6:48
    • 1.2 Settings and Navigation - 6:39
    • 1.3 News, Activity and Quick Links - 7:15
    • 1.4 Documents - 5:47
  • 2 Apps List and Libraries
    • 2.1 Adding Data using Custom List - 12:03
    • 2.2 Views, Filters and Sorting - 6:29
    • 2.3 Site Contents and Document Libraries - 9:09
  • 3 Working with SharePoint Libraries
    • 3.1 Adding Files and Checking In and Out - 8:05
    • 3.2 Versioning and Restoring - 5:36
    • 3.3 Quick Edit, Sequence No. and Sorting - 6:46
    • 3.4 Grouping - 7:33
    • 3.5 Alerting - 4:57
    • 3.6 Permissions, Sharing and Pinning - 6:13
  • 4 List Views and Calendar
    • 4.1 List Views - 7:07
    • 4.2 Calendar - Part 1 - 7:28
    • 4.3 Calendar - Part 2 - 9:24
    • 4.4 Adding Calendar and Other Apps to Home Page - 5:42
  • 5 Working with Site Pages
    • 5.1 Creating a Site Page - 8:28
    • 5.2 Adding Sections and Web Parts - 7:11
    • 5.3 Adding More Web Parts - 6:16
    • 5.4 Adding to Home Page, Deleting and Restoring - 6:02
    • 5.5 Adding a Web Part Page - 9:53
    • 5.6 Adding a Wiki Page - 5:28
  • 6 Syncing with OneDrive
    • 6.1 Syncing with OneDrive - 7:27
  • 7 Site Columns and Content Types
    • 7.1 Creating a Custom Site Column - 6:27
    • 7.2 Adding Custom Column to List - 6:31
    • 7.3 Creating New Content Types - 8:35
    • 7.4 Creating a List using Content Types - 10:02
  • 8 Managing Sub Sites and User Permissions
    • 8.1 Creating Sub Sites - 10:23
    • 8.2 Site Permissions - 9:52
    • 8.3 Sub Site Permissions - 6:30
    • 8.4 Access Requests and Site Collections - 3:37

View Full Curriculum


Access
Lifetime
Content
6.0 hours
Lessons
36

Microsoft Access 365: Beginner to Advanced

Get Your Database Up & Running Quickly

By Earn and Excel | in Online Courses

If you are working in a small company and you want to be able to manage your data, whether that be some 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. This course is created to teach you how to use Access to be a great end-user tool that you can get up and running quickly and give your database more advanced capability if you wish to.

4.7/5 average rating: ★ ★ ★ ★

  • Access 36 lectures & 5 hours of content 24/7
  • Learn the fundamentals of Access: tables, primary key & data types
  • Query your database
  • Create links between tables
  • Create forms with & without the wizard
  • Use the wizard to build a report or
  • Export data to Excel, Word, or PDF
  • Use buttons to carry out advanced functions, conditional outputs, & more
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Access

Course Outline

  • 1 Creating Tables
    • Course Materials
    • 1.1 Creating and Saving a Table in Design Mode - 15:53
    • 1.2 The Primary Key - 8:02
    • 1.3 Important Field Properties - 13:50
  • 2 Creating Queries
    • 2.1 The Select Query - 12:04
    • 2.2 Filtering and Sorting Records using Numeric and Date Fields - 12:06
    • 2.3 Filtering and Sorting Records using Text Fields and Wildcards - 12:21
    • 2.4 Adding a Calculated Field to a Query - 11:07
  • 3 Action Queries
    • 3.1 Queries that Change Data - 9:20
    • 3.2 Adding Pop Up Parameters to Queries - 10:10
  • 4 Linking Tables
    • 4.1 Two Reasons for a Relational Database - 14:35
    • 4.2 Creating Links Between Tables - 8:43
    • 4.3 Multiple Table Queries - 8:41
  • 5 Creating Forms
    • 5.1 Creating a Form Using the Wizard - 15:35
    • 5.2 Creating and Editing a Form WITHOUT the Wizard - 14:17
    • 5.3 The Clever ComboBox Record Finder - 8:35
  • 6 Creating SubForms
    • 6.1 Forms Within Forms in a Relational Database - 13:30
    • 6.2 SubForms Based on Query Data - 13:33
  • 7 Creating Splitforms
    • 7.1 Use of the SplitForm Feature - 6:33
  • 8 Creating Reports
    • 8.1 Create a Report with the Wizard - 9:13
    • 8.2 Create a Report from Scratch and add Special Fields - 14:15
    • 8.3 Grouping with Reports - 8:47
  • 9 Exporting Data
    • 9.1 Export Data into Excel - 8:04
    • 9.2 Export a Report to Word or PDF - 7:28
  • 10 Importing data
    • 10.1 Import from Excel - 13:52
    • 10.2 Use of Paste Append - 5:22
    • 10.3 Import an Access Table from another Database - 7:31
    • 10.4 Create a Mail Merge in Word using Data from Access - 9:54
    • 10.5 Mail Merging in Word using Data from Excel - 7:15
  • 11 Building VBA/Macros
    • 11.1 Introduction to Access Macros - 13:08
    • 11.2 Introduction to Events in Access using VBA - 9:01
    • 11.3 Create a Form with Buttons to open/close other objects - 12:40
    • 11.4 Refresh the data in one combo box when another combo box is changed - 17:08
    • 11.5 Decide on a course of action based on user input - 8:26
    • 11.6 Using VBA to connect Access to a SQL Server backend database - 11:56
    • 11.7 The special AUTOEXEC macro - 6:57

View Full Curriculum


Access
Lifetime
Content
2.0 hours
Lessons
20

Microsoft Project: Get Up & Running Quickly

Avoid the Pitfalls & Create a Plan That is Easily Manageable Regardless of Size or Complexity

By Earn and Excel | in Online Courses

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. That's why this course was created: to get you up and to run and to work with best practices in a concise time frame. It 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 organizations and is ready to pass on to you what you really need to know to create and manage an efficient and effective project plan.

4.2/5 average rating: ★ ★ ★ ★

  • Access 20 lectures & 2 hours of content 24/7
  • Have great command of Microsoft Project
  • Understand the ways of working with the tool that best set you up for success
  • Set up the baseline for your project, track it & manage easily
  • Know the 3 levels of project reporting
  • Understand the importance of dependency relationships
  • Use calendars to build a complete picture of schedule & delivery
  • Create templates that can be reused on future projects
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Project

Course Outline

  • 1 Navigation-Overview
    • 1.1 Network View, Ribbon and QAT Customisation - 9:05
    • 1.2 Timeline, Entry Table and Gantt Chart - 14:35
    • 1.3 Indicator column etc. - 10:19
    • 1.4 Custom Options - 9:02
    • 1.5 Assignments, Task Usage and Summaries - 4:31
  • 2 Task Dependencies
    • 2.1 Task Dependency Types - 8:10
    • 2.2 Leads, Lags and Overlaps - 6:24
  • 3 Calendars
    • 3.1 Types of Calendar and Exceptions - 9:38
    • 3.2 Resource and Task Calendars - 4:38
    • 3.3 Using Organizer - 7:46
  • 4 Costs
    • 4.1 Resource Sheet - 7:45
    • 4.2 Fixed Costs - 4:23
  • 5 Resource Management – Overallocation
    • 5.1 Levelling Options - 11:07
    • 5.2 Contouring Resources - 10:44
  • 6 Constraints & Deadlines
    • 6.1 Constraints and Deadlines - 9:56
  • 7 Baselines
    • 7.1 Setting Project Baseline - 8:41
    • 7.2 Set Task Baseline and Clear Baseline - 7:11
  • 8 Reports
    • 8.1 Report Examples - 9:32
    • 8.2 Visual Reports - 4:07
  • 9 Project Templates
    • 9.1 Project Templates - 6:56

View Full Curriculum


Access
Lifetime
Content
5.0 hours
Lessons
58

Microsoft OneNote (365/2019/2016/2010) Beginner to Advanced

Make Your Notes Highly Organized, Stored in One Place, & Easily Accessed From Any Device

By Earn and Excel | in Online Courses

Paperless and productive — the two biggest benefits you will get from doing this course. OneNote lets you take your work with you, wherever you go, on any device. It syncs automatically, so you never have to worry about saving notes when you're on the go. Earn, and Excel brings you a course that will teach you everything you need to know about OneNote, and then some. 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, your notes will be highly organized, stored in one place, and easily accessed from any device.

4.3/5 average rating: ★ ★ ★ ★

  • Access 58 lectures & 5 hours of content 24/7
  • Get started with OneNote: introduction, quick access toolbar & inserting notes
  • Copy cut text & split and merge containers
  • Delete & insert time stamp
  • Format text, apply styles & use format painter
  • Add & organize sections
  • Create subpages & section groups
  • Work with different page versions
  • Insert printouts & attachments
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Any device with basic specifications

Course Outline

  • 1 Getting Started, Intro, QAT, Inserting Notes
    • 1.1 Introduction to OneNote - 5:38
    • 1.2 OneNote Introduction to the ribbon - 8:52
    • 1.3 Organise QAT - 6:08
    • 1.4 Organise QAT Part 2 - 2:34
    • 1.5 Inserting notes - 5:54
  • 2 Containers, Time Stamp, Pages, Formatting, Bullets and Numbers, Spaces
    • 2.1 Copy cut text and split and merge containers - 8:06
    • 2.2 Deleting and inserting time stamp - 5:32
    • 2.3 Adding and deleting pages - 4:11
    • 2.4 Formatting text applying styles and using the format painter - 7:33
    • 2.5 Creating bulleted and numbered lists - 10:25
    • 2.6 Inserting and removing spaces between containers - 3:21
  • 3 Sections, Subpages, Section Groups, Templates
    • 3.1 Adding and organising sections - 5:53
    • 3.2 Creating subpages - 8:59
    • 3.3 Creating section groups - 10:27
    • 3.4 Applying OneNote templates - 9:01
    • 3.5 Creating customised templates - 5:11
  • 4 Page Versions, History, Quick Notes, Dock to Desktop, Linked Notes
    • 4.1 Working with different page versions - 4:58
    • 4.2 The History tab – recycle bin etc. - 5:42
    • 4.3 Using Quick Notes - 7:04
    • 4.4 Change default location of Quick Notes - 2:58
    • 4.5 Using dock to desktop - 9:27
    • 4.6 Using Linked Notes - 4:54
  • 5 Inserting Printouts, Attachments, Excel, Tables
    • 5.1 Inserting printouts and attachments - 5:56
    • 5.2 Inserting Excel part 1 - 6:38
    • 5.3 Inserting Excel part 2 - 5:01
    • 5.4 Inserting tables - 7:48
    • 5.5 Formatting tables - 6:21
    • 5.6 Sorting data within a table - 4:23
  • 6 Screen Clipping, Inserting Pictures & Symbols, Send to OneNote, Text to Ink
    • 6.1 Screen clipping - 7:13
    • 6.2 Inserting pictures - 5:12
    • 6.3 Using the Optical Character Recognition - OCR - 3:17
    • 6.4 Inserting symbols - 5:01
    • 6.5 Using Send to OneNote - 8:05
    • 6.6 Converting handwritten ink to text - 5:11
  • 7 View Tab, Side Panes, Tags, Audio Recording
    • 7.1 The View tab options - 13:08
    • 7.2 Customising the side panes - 6:42
    • 7.3 Applying tags - 6:34
    • 7.4 Searching tags - 8:27
    • 7.5 Audio recording part 1 - 3:08
    • 7.6 Audio recording part 2 - 2:03
  • 8 Research, Links, TOC, Pen & Highlighter, Shapes
    • 8.1 Using research option within the View tab - 8:56
    • 8.2 Creating links between notebooks sections and pages - 7:58
    • 8.3 Creating a TOC - 4:06
    • 8.4 Setting up the pen and highlighting text - 7:11
    • 8.5 Inserting and formatting shapes - 4:02
    • 8.6 Rearranging shapes - 7:08
    • 8.7 Using the pointer - 2:39
  • 9 Equations, Math, Sending & Exporting, Linking Contacts & Appointments
    • 9.1 Inserting Equations - 6:11
    • 9.2 Inserting handwritten Equations - 6:24
    • 9.3 Calculating simple math - 2:37
    • 9.4 Sending OneNote pages via email - 5:16
    • 9.5 Exporting OneNote - 5:04
    • 9.6 Linking Outlook Contacts in OneNote - 3:44
    • 9.7 Linking Outlook 365 appointments in OneNote - 7:20
    • 9.8 Using Outlook tasks in OneNote - 8:05
  • 10 Backups, Restores, Password Protecting
    • 10.1 Using Backups to restore sections - 3:32
    • 10.2 Restoring deleted pages and sections - 4:25
    • 10.3 Password protecting sections - 6:17

View Full Curriculum


Access
Lifetime
Content
4.0 hours
Lessons
41

Microsoft Outlook 365: Beginner to Advanced

Be Expert at Managing Your Emails, Calendars, Meetings, Tasks & Contacts to an Advanced Level

By Earn and Excel | in Online Courses

Earn and Excel brings you a comprehensive course from beginner to advanced to teach you everything you need to know about Outlook. There is so much more to Outlook than sending or receiving emails. This course will show you how to get Outlook's best use by organizing your calendar, syncing calendars, arranging meetings, setting and completing tasks, and maintaining contacts. You will learn how to organize your folders in ways that will ensure you never lose track of emails, meetings, or contacts. By the end of this course, you will be an expert at managing your emails, calendars, meetings, tasks, and contacts to an advanced level.

4.5/5 average rating: ★ ★ ★ ★

  • Access 41 lectures & 4 hours of content 24/7
  • Get comfortable with the Outlook environment & understand the Ribbon
  • Create & format emails with ease
  • Set up meetings, recurring meetings, & link them up in your calendar
  • Understand the difference between Exchange, IMAP & POP email types
  • Understand the different folders & how to set up your own folder structure to your preference
  • Set rules to automatically store emails where your prefer
  • Use conditional formatting & color coding
  • Set up automatic replies when you are not available
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Any device with basic specifications

Course Outline

  • Module 1: Introduction
    • Module 1 Course Download
    • 1.1 Introduction to Outlook - 8:27
    • 1.1a Introduction to Outlook follow up - 0:49
    • 1.2 Linking an email - 6:12
    • 1.3 Creating and formatting email and inserting picture - 12:13
    • 1.4 Creating email signature - 8:37
    • 1.5 Pasting in Outlook from Word PPT and Excel - 11:44
  • Module 2: Rules, Formatting & Folders
    • Module 2 Course Download
    • 2.1 Send email, show sent folders and receiver email - 9:04
    • 2.2 Creating rules - 10:17
    • 2.3 Conditional formatting - 5:36
    • 2.4 Different view panes settings - 6:36
    • 2.5 More about view settings - 1:51
    • 2.6 Understanding different folders - 1:49
  • Module 3: Printing, Searching & Attachments
    • Module 3 Course Download
    • 3.1 Printing an email - 5:56
    • 3.2 Creating subfolder within new folder - 1:33
    • 3.3 Sending attachments - 5:43
    • 3.4 Using categories with Exchange, IMAP and POP email accounts - 12:47
    • 3.5 Tags and searching for emails - 6:26
    • 3.6 Using the search folder - 2:11
  • Module 4: In-Email Functionality
    • Module 4 Course Download
    • 4.1 Flagging emails - 6:19
    • 4.2 Automatic out of office reply with Exchange server - 3:08
    • 4.3 Automatic out of office reply with IMAP email account - 4:12
    • 4.4 Deleting automatic reply in IMAP account - 1:56
    • 4.5 Using voting buttons - 5:52
    • 4.6 Creating a distribution list - 10:14
  • Module 5: Recurring Tasks & Meetings
    • Module 5 Course Download
    • 5.1 Auto archiving and manually archiving emails-folders - 4:32
    • 5.2 Creating and assigning recurring tasks - 8:09
    • 5.3 Creating, linking new calendar, meetings, signature within outlook - 22:47
    • 5.4 Setting up recurring meetings - 9:42
    • 5.5 Categorising events - colour coding - 14:23
  • Module 6: More Meetings & Calendars
    • Module 6 Course Download
    • 6.1 Meetings - Change and propose new time - 9:09
    • 6.2 Creating meetings from email and making them private - 5:28
    • 6.3 Printing calendar or event - 6:00
    • 6.4 Searching the calendar - 3:47
    • 6.5 Modifying working hours and days - 7:17
    • 6.6 What reminders look like - 1:41

View Full Curriculum


Access
Lifetime
Content
3.0 hours
Lessons
21

Microsoft Teams: Become a Power User

Best Practice Collaboration from a Microsoft Certified Consultant

By Earn and Excel | in Online Courses

Digital collaboration is the new normal in today’s world, and Microsoft has built the market-leading collaboration tool with Microsoft Teams. Earn and Excel worked with the Microsoft Certified and highly experienced Teams Consultant Henry Phillips to put together a masterclass training course to get the most from this incredible tool. Henry’s expertise in how companies can get the most out of Microsoft Teams means you don’t have to put yourself through an unnecessarily long course, and in under three hours, you will be able to get the most out of this tool for you and your company.

3.8/5 average rating: ★ ★ ★ ★ ★

  • Access 21 lectures & 3 hours of content 24/7
  • Get a simplified overview of MS Teams as a whole
  • Crreate & manage teams
  • Understand conversations & notifications
  • Work with channels & add apps to channels
  • Use bots to your advantage
  • Access & work with recordings and transcripts
  • Work with files for collaboration on your documents
  • Use SharePoint, OneDrive, OneNote, Wiki & Voicemails (exchange) with your channels
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Teams

Course Outline

  • 1 Introduction and Overview
    • 1.1 Introduction - 1:35
    • 1.2 Overview - 19:53
  • 2 Creating and Managing Teams
    • 2.2 Managing Teams - 14:31
    • 2.1 Creating Teams - 10:49
  • 3 Channels and Team Navigation
    • 3.1 Channels - 15:07
    • 3.2 Channel and Teams Navigation - 3:16
  • 4 Chats, Conversations and Notifications
    • 4.1 Chats - 12:18
    • 4.2 Conversations and Notifications - 15:58
  • 5 Audio and Video Calls and Meetings
    • 5.1 Audio and Video Calls - 11:31
    • 5.2 Meetings - 18:33
  • 6 Working with Files
    • 6.1 Working with Files Part 1 - 11:36
    • 6.2 Working with Files Part 2 - 7:08
  • 7 Apps, Wikis and Guest Access
    • 7.1 Mobile App - 1:48
    • 7.2 Wikis - 4:15
    • 7.3 Apps - 7:01
    • 7.4 Guest Access - 6:53
  • 8 Whiteboard, Search, Enhancements and Shifts
    • 8.1 Whiteboard - 5:36
    • 8.2 Search - 4:38
    • 8.3 Enhancements - 4:12
    • 8.4 Shifts - 4:18
  • 9 Behind the Scenes
    • 9.1 Behind the Scenes - 11:45

View Full Curriculum


Access
Lifetime
Content
6.0 hours
Lessons
59

Microsoft PowerPoint 365

Craft Creative Slides & Build Persuasive Pitch Decks

By Earn and Excel | in Online Courses

Highly experienced corporate professional and trainer Claudia Carrozzo brought her many years of using Office in some of the biggest, most high profile global companies. They created an incredible training course which will have you mastering PowerPoint in a few hours. From the very basics to eventually crafting creative slides and building persuasive pitch decks, this course will upskill your PowerPoint skills to the level of top management consultants that practice in the Big 4.

4.4/5 average rating: ★ ★ ★ ★

  • Access 59 lectures & 6 hours of content 24/7
  • Get started with Microsoft PowerPoint
  • Work with shapes
  • Use SmartArt, org chart, & arrow diagrams
  • Works with guides, rulers, gridliens & formatting
  • Utilize Excel & Word in PowerPoint
  • Learn about logo slides, design ideas, spell check, add notes & more
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft PowerPoint

Course Outline

  • 1 Introduction and Basics
    • PowerPoint Notes 1
    • 1.1 Introduction to PowerPoint Ribbon Tabs & Groups - 17:11
    • 1.2 Ribbon Options - 3:00
    • 1.3 Customize the QAT - 3:22
    • 1.4 Moving through and deleting slides - 2:27
  • 2 Shapes
    • PowerPoint Notes 2
    • 2.1 Shapes filled with pictures - 3:18
    • 2.2 Arranging shapes 1 - 3:35
    • 2.3 Arranging shapes 2 - 2:28
    • 2.4 Aligning, grouping and resizing shapes - 8:58
    • 2.5 How to use shapes - 6:39
    • 2.6 Merging vs grouping - 3:18
    • 2.7 Shapes – all merging options - 3:51
    • 2.8 Creating customised shapes - 13:03
  • 3 SmartArt, Org Chart & Arrow Diagram
    • PowerPoint Notes 3
    • 3.1 Working with SmartArt 1 - 4:50
    • 3.2 Working with SmartArt 2 - 7:54
    • 3.3 Organisational chart - Manual vs SmartArt - 24:20
    • 3.4 Organisational chart – more tips - 3:13
    • 3.5 Arrow diagram - 9:05
  • 4 Guides, Rulers & Gridlines plus Formatting, Margins & Bullets
    • PowerPoint Notes 4
    • 4.1 Guides, Ruler and Gridlines - 15:16
    • 4.2 Smart Guides and shapes - 3:42
    • 4.3 Smart Guides and Text Boxes - 4:16
    • 4.4 Inserting and formatting text plus setting up tabs - 13:08
    • 4.5 Changing margins within shapes - 6:54
    • 4.6 Working with bullets - 8:30
  • 5 Sections, Slide Master and Default Styles
    • PowerPoint Notes 5
    • 5.1 Working with sections - 14:33
    • 5.2 Creating a Slide Master 1 - 8:50
    • 5.3 Creating a Slide Master 2 - 7:48
    • 5.4 Slide Master placeholders - 3:06
    • 5.5 Slide Master change placeholder shape - 1:42
    • 5.6 Slide Master change placeholder points - 4:09
    • 5.7 Changing default style to shapes and text boxes - 11:43
  • 6 Excel and Word in PowerPoint
    • PowerPoint Notes 6
    • 6.1 How to insert Excel data within PowerPoint - 9:36
    • 6.2 How to insert Excel chart within PowerPoint - 5:55
    • 6.3 How to create a chart within PowerPoint - 4:11
    • 6.4 Animating Excel Charts in PowerPoint - 2:45
    • 6.5 Adding Elements to Excel Charts in PowerPoint - 3:00
    • 6.6 Working with Word in PowerPoint - 6:17
    • 6.7 Word outline in PowerPoint - 5:49
  • 7 Slide Numbers, M&A Presentation and More About Shapes
    • PowerPoint Notes 7
    • 7.1 How to add slide numbers - 12:33
    • 7.2 Mergers and Acquisitions presentation - 12:34
    • 7.3 Shapes with gradient fill - 3:26
    • 7.4 Shapes – copy format and edit points - 6:21
    • 7.5 Shapes – formatting lines and arrows - 3:30
  • 8 Footnotes, Consistency, Reviewing & Tables
    • PowerPoint Notes 8
    • 8.1 How to add footnotes - 4:58
    • 8.2 How to check for consistency - 2:11
    • 8.3 Reviewing slides with markups - 7:13
    • 8.4 Inserting tables - 13:58
  • 9 Logo Slides, Design Ideas, Spell Check, Add Notes & Printing
    • PowerPoint Notes 9
    • 9.1 How to create a logo slide - 20:22
    • 9.2 Design Ideas On and off - 1:07
    • 9.3 Spell check - 3:50
    • 9.4 Adding notes and printing slides and handouts - 9:00

View Full Curriculum


Access
Lifetime
Content
7.0 hours
Lessons
75

Microsoft Visio 365 : Beginner to Advanced

Master the Art of Diagramming & Mapping Processes

By Earn and Excel | in Online Courses

Whether you need to map business processes, create floor layouts, build organization charts, create swimlane diagrams, or create any visual diagram, Visio is the industry standard for achieving this. This course teaches you how 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.

4.1.7/5 average rating: ★ ★ ★ ★

  • Access 75 lectures & 7 hours of content 24/7
  • Insert & format text in Visio
  • Understand & work with connectors
  • Create sophisticated shapes
  • Create flowcharts, org cahrts, swimlane diagrams & apply themes
  • Organize pages, understand autosize & apply backgrounds
  • Align & reposition shapes in charts & diagrams
  • Work with containers & callouts
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Visio

Course Outline

  • 1 Introduction
    • 1.1 Introduction to Visio - 0:48
    • 1.2 Visio look and feel - 13:23
    • 1.3 Customising the QAT - 7:10
    • 1.4 Showing hidden tabs - 4:19
    • 1.5 Creating new tabs and groups with commands - 4:25
  • 2 Visio essentials
    • 2.1 Useful shortcuts - 6:09
    • 2.2 Setting up pages - 4:29
  • 3 Visio essential diagram skills
    • 3.1 Inserting shapes and using the dynamic grid - 7:12
    • 3.2 Resizing shapes - 6:13
    • 3.3 Selecting shapes - 5:36
    • 3.4 Using guides and rulers - 7:51
    • 3.5 Copying and duplicating shapes - 4:19
    • 3.6 Grouping and ungrouping shapes - 4:27
  • 4 Inserting and formatting text in Visio
    • 4.1 Inserting text in shapes - 4:42
    • 4.2 Inserting text boxes and changing font default - 7:32
  • 5 Understanding and working with connectors
    • 5.1 Using lines to connect shapes - 5:11
    • 5.2 Using connectors vs lines - 10:00
    • 5.3 Understand Dynamic vs Static Shape Connectors - 6:32
    • 5.4 Repositioning shapes' text - 4:21
    • 5.5 Using auto connect - 5:53
    • 5.6 Selecting connectors all at once - 3:25
  • 6 Visio connectors in-depth
    • 6.1 Changing all shapes at once - 2:49
    • 6.2 Changing rerouting settings - 5:25
    • 6.3 Using connector splitting - 4:00
  • 7 Working with layers
    • 7.1 Inserting screen tips - 2:21
    • 7.2 Assigning layers - 5:03
    • 7.3 Locking layers - 3:41
    • 7.4 Managing layers - 7:58
  • 8 Creating flowcharts, org charts, swimlane diagrams and applying themes
    • 8.1 Creating a flowchart - 9:30
    • 8.2 Creating a flowchart continued - 5:44
    • 8.3 Creating an org chart - 11:03
    • 8.4 Applying themes and variants to org charts - 5:12
    • 8.5 Creating org chart with wizard - 6:25
    • 8.6 Inserting pictures into org charts - 6:18
    • 8.7 Importing data into an org chart - 4:27
    • 8.8 Creating a swimlane diagram - 16:13
  • 9 Organising pages, understanding autosize and applying backgrounds
    • 9.1 Creating backgrounds - 5:18
    • 9.2 Creating backgrounds continued - 5:12
    • 9.3 Re-ordering pages order - 4:57
    • 9.4 Working with AutoSize - 3:25
  • 10 Working with Visio shape data
    • 10.1 Assigning Data to Shapes - 4:00
    • 10.2 Customising and assigning data to shapes - 10:09
    • 10.3 Linking data to basic shapes - 9:24
    • 10.4 Refreshing data - 4:40
  • 11 Creating and editing Visio shape data report
    • 11.1 Creating a Visio shape report - 5:09
    • 11.2 Editing a Visio shape report - 6:16
  • 12 Time saving tricks in aligning and repositioning shapes in charts and diagrams
    • 12.1 Aligning and positioning shapes - 5:17
    • 12.2 Repositioning shapes in charts - 1:58
    • 12.3 Moving deleting and adding connection points - 6:23
  • 13 Working with containers and callouts
    • 13.1 Using containers - 7:07
    • 13.2 Formatting containers - 7:55
    • 13.3 Inserting callouts - 22:24
  • 14 Linking external data to Visio diagrams
    • 14.1 Linking Visio to different file type docs - 6:08
    • 14.2 Linking elements within same Visio doc - 4:59
    • 14.3 Multiple hyperlinks - 2:50
  • 15 Introduction to advanced diagrams
    • 15.1 Introduction to floor plan, IT networking and infographics - 23:42
    • 15.2 Finding and replacing words - 4:16
    • 15.3 Performing process validation - 5:38
    • 15.4 Creating sub-processes within diagrams - 3:47
  • 16 Collaborating with people by using Visio
    • 16.1 Printing charts, diagrams and drawings - 7:55
    • 16.2 Using page setup - 4:36
    • 16.3 Inserting headers and footers - 3:57
    • 16.4 Removing personal info from docs - 5:18
  • 17 Exporting Visio drawings
    • 17.1 Exporting drawings to JPEG as graphics - 5:41
    • 17.2 Creating templates - 6:31
    • 17.3 Creating web pages from Visio - 1:37
    • 17.4 Exporting to pdf - 4:08
  • 18 More trick and tips and how to truly speed up work by creating your own stencils
    • 18.1 Inserting comments - 6:29
    • 18.2 Converting handwritten text to typed text - 4:47
    • 18.3 Creating customised shapes - 6:46
    • 18.4 Searching for shapes - 2:27
    • 18.5 Creating stencils - 9:15
    • 18.6 Downloading new stencils, shapes - 4:11
    • 18.7 Customising themes - 6:25
    • 18.8 Changing the scale to drawings - 4:18

View Full Curriculum


Access
Lifetime
Content
3.0 hours
Lessons
41

Microsoft Advanced Word 365

A More Advanced Curriculum on Mail Merge, Macro, Footnotes, Hyperlinks & More

By Earn and Excel | in Online Courses

Building on from the basics, this course 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 other professionals with advanced needs from Word.

4.4/5 average rating: ★ ★ ★ ★

  • Access 41 lectures & 3 hours of content 24/7
  • Use mail merge to automate document production
  • Create Macros to speed up your work
  • Explore captions, references, & legal citations
  • Protect forms, compare documents, &Track changes
  • Amend properties, password protection & digital signatures
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Word

Course Outline

  • Module 1
    • Module 1 download
    • 1.1 Mail merge with wizard - 15:27
    • 1.2 Manual mail merge - 14:10
    • 1.3 Mail merge envelopes with wizard - 7:22
    • 1.4 Mail merge labels with wizard - 5:48
    • 1.5 Mail merge Word data source vs Excel data source - 2:52
    • 1.6 Mail merge basic sorting - 3:02
    • 1.7 Mail merge advance filtering - 2:04
  • Module 2
    • Module 2 download
    • 2.1 Viewing the TOC in different view modes - 2:10
    • 2.2 Creating and running a macro - 6:14
    • 2.3 Assigning short cut key to macro - 3:20
    • 2.4 Deleting a macro - 0:56
    • 2.5 Working in outline view - 11:58
    • 2.6 Inserting indexes and creating bookmarks - 11:22
    • 2.7 Deleting indexes - 7:03
    • 2.8 Deleting bookmarks - 1:23
  • Module 3
    • Module 3 download
    • 3.1 Working with master docs - 8:51
    • 3.2 Inserting and deleting sub docs - 4:30
    • 3.3 Entering footnotes - 4:55
    • 3.4 Inserting captions and labels - 4:29
    • 3.5 Entering cross references - 4:41
    • 3.6 Creating modifying deleting citations placeholders and bibliography - 12:10
    • 3.7 Marking legal citations and creating TA - 7:47
  • Module 4
    • Module 4 download
    • 4.1 Removing hyperlinks - 3:29
    • 4.2 Inserting and modifying TOF - 3:25
    • 4.3 Inserting and managing content control fields - 8:42
    • 4.4 Protect forms - 3:22
    • 4.5 Working and proof read with track changes - 12:01
    • 4.6 Comparing docs - 5:16
  • Module 5
    • Module 5 download
    • 5.1 Viewing and amending properties - 3:37
    • 5.2 Removing hidden properties - 3:30
    • 5.3 Making a document as final - 1:57
    • 5.4 Adding and removing password to protect a doc - 3:21
    • 5.5 Restrict editing a doc - 7:37
    • 5.6 Inserting MS digital signature - 3:43
    • 5.7 Inserting non MS digital signature not secured - 2:52
    • 5.8 Changing style and automating captions - 4:24

View Full Curriculum


Access
Lifetime
Content
4.0 hours
Lessons
83

Microsoft Word 365

Get Started with Creating Documents, Formatting & Stylizing

By Earn and Excel | in Online Courses

Earn and Excel 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 working to an intermediate level with Word in a few hours.

4.4/5 average rating: ★ ★ ★ ★

  • Access 83 lectures & 4 hours of content 24/7
  • Be familiar with the quick access toolbar, Ribbon, & basic operations
  • Get started with formatting, spell checking, & removing spaces
  • Work with tables
  • Use margins & alignments
  • Know the best practices with text boxes
  • Create shapes & objects
  • Use styles to customize your documents
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Word

Course Outline

  • Module 1
    • Module 1 download
    • 1.1 Opening a new blank document - 1:42
    • 1.2 New blank doc 3 ways - 1:20
    • 1.3 Highlighting and adding text - 1:32
    • 1.4 Revealing formatting marks - 4:01
    • 1.5 Customising the QAT - 3:43
    • 1.6 Changing the ribbon - 1:48
    • 1.7 Help menu and Search bar - 3:08
    • 1.8 Save and close doc - 1:51
  • Module 2
    • Module 2 download
    • 2.1 Formatting big docs at a glance and applying headings - 11:26
    • 2.2 Explanation of Headings - 1:55
    • 2.3 Spell Check - 3:57
    • 2.4 Spell Check continued - 1:53
    • 2.5 Removing extra paragraphs and bullet spaces - 2:37
    • 2.6 Follow up formatting removing bulleted list and spaces - 3:19
  • Module 3
    • Module 3 download
    • 3.1 Inserting a page break - 6:42
    • 3.2 Creating a table and entering data text - 2:13
    • 3.3 Creating a table and entering data text continued - 2:28
    • 3.4 Creating a table from scratch - 4:07
    • 3.5 Creating a table from scratch continued - 3:41
    • 3.6 Creating a table borders and shading - 5:07
    • 3.7 Creating a table text direction and shading - 5:29
  • Module 4
    • Module 4 download
    • 4.1 Preset margins - 3:04
    • 4.2 Orientation - 1:41
    • 4.3 Alignments and indenting - 5:46
    • 4.4 Margins manual adjustment - 1:54
    • 4.5 Formatting underline and bold - 8:20
    • 4.6 Cut and paste - 4:50
    • 4.7 Copy and paste - 4:14
  • Module 5
    • Module 5 download
    • 5.1 Applying bullets and picture bullets - 6:08
    • 5.2 Numbered list - 1:46
    • 5.3 Basic multilevel list - 5:11
    • 5.4 Paragraph numbering - 1:25
    • 5.5 Multi level list with headings - 6:16
    • 5.6 Inserting a coverpage - 3:37
  • Module 6
    • Module 6 download
    • 6.1 Convert text to table - 5:17
    • 6.2 Inserting and deleting rows and columns - 6:49
    • 6.3 Convert text to table with tabs - 3:31
    • 6.4 Working with text boxes - 7:36
    • 6.5 Working with text boxes continued - 14:36
    • 6.6 Linking text boxes - 3:56
  • Module 7
    • Module 7 download
    • 7.1 Building block explanation - 5:22
    • 7.2 Creating a building block from scratch - 3:46
    • 7.3 Delete a building block - 1:39
    • 7.4 Insert automatic date and time and update field - 4:03
    • 7.5 Section breaks - 5:30
    • 7.6 Text flow options - 3:23
  • Module 8
    • Module 8 download
    • 8.1 Insert header with building blocks - 3:00
    • 8.2 Insert footer with building blocks - 2:48
    • 8.3 Inserting page numbers and modifying where it starts - 4:59
    • 8.4 Insert header manually - 5:39
    • 8.5 Insert footer manually - 2:25
    • 8.6 All different views within Word - 5:23
  • Module 9
    • Module 9 download
    • 9.1 Find and replace - 3:12
    • 9.2 Creating shapes with fill and gradients - 8:04
    • 9.3 Adding text to shapes - 0:54
    • 9.4 Enter text with text box and group to objects - 5:41
    • 9.5Grouping and resizing shapes - 3:17
  • Module 10
    • Module 10 download
    • 10.1 Insert and format a picture - 2:48
    • 10.2 Applying page colour - 3:30
    • 10.3 Applying viewing and removing a watermark - 2:39
    • 10.4 Finding pages - 1:38
    • 10.5 Design a table manually - 3:21
    • 10.6 Setting repeat header rows - 1:36
    • 10.7 Removing all formatting and selecting headings - 3:58
  • Module 11
    • Module 11 download
    • 11.1 Creating and applying a new style - 4:49
    • 11.2 Remove style from gallery - 0:36
    • 11.3 Save Word doc as PDF file - 3:03
    • 11.4 Viewing recent docs - 2:48
    • 11.5 Creating a new folder - 2:01
    • 11.6 Using MS Word translator - 3:12
    • 11.7 Using a template - 3:38
    • 11.8 Find and replace font and formatting - 2:36

View Full Curriculum


Access
Lifetime
Content
6.0 hours
Lessons
40

Excel VBA for Professionals

Master Excel VBA & Add Real Value to Your Company

By Earn and Excel | in Online Courses

If you are regularly producing the same reports, doing the same data analysis, and another repetitive work week after week in Excel, then we will show you how to get off the hamster wheel of repetitive work so you can focus on adding real value to your company. This is the only Excel VBA and Macros course on the market purpose-built to teach Excel VBA and Macros skills to corporate professionals, including Analysts, Accountants, Controllers, PMO’s, Project Managers, Management Consultants, And Other Corporate Professionals.

  • Access 40 lectures & 6 hours of content 24/7
  • Get started with VBA & Macros
  • Know the fundamentals of automation with loops & logic
  • Automate cahrts, filters, & formulas to speed up your workflow
  • Understand the 5 levels of looping
  • Automate an entire weekly/monthly reporting process
  • Automate slide packs production, documentation & manipulation
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel

Course Outline

  • Module 2: VBA Fast-track Part 2
    • VBA Fast-track Part 2 Workbook
    • 2.1 Macro File format - 3:11
    • 2.2 Developer tab and Macro Security - 3:48
    • 2.3 Modules, macros and relative references - 9:48
    • 2.4 A first look at Buttons - 4:12
    • 2.5 Charting driven by macros - 10:02
    • 2.6 Why Macros can go wrong and what to do about it - 5:57
    • 2.7 Handling Errors and Sheet issues - 12:38
    • 2.8 Dynamic Charting part 1 - 16:35
    • 2.9 Dynamic Charting Part 2 - 13:14
    • 2.10 Dynamic Charting Part 3 - 9:01
    • 2.11 The benefits of End With - 7:49
    • 2.12 Controlling Autofilters - 20:20
    • 2.13 Controlling Formulas - 14:44
  • Module 3: Automation Part 1
    • 3.1 Five Levels of Looping Part 1 - 5:36
    • 3.2 Five Levels of Looping Part 2 - 5:26
    • 3.3 Five Levels of Looping Part 3 - 13:07
    • 3.4 Five Levels of Looping Part 4 - 20:11
    • 3.5 Five Levels of Looping Part 5 - 19:16
    • 3.6 VBA Alternative: Gathering Data with Power Query - 6:29
  • Module 4: Automation Part 2
    • VBA Gathering Data Part 1 Workbook
    • 4.1 Introduction to Information Gathering - 17:18
    • 4.2 Creating an Input Sheet Template - 22:44
    • 4.3 Mass producing Input Sheets 1 Set the scene - 6:53
    • 4.4 Mass producing Input Sheets 2 Worksheet Variables - 5:11
    • 4.5 Mass producing Input Sheets 3 Autofilter revisited and Pastespecial - 15:24
    • 4.6 Mass producing Input Sheets 4 Manipulating filter criteria - 10:40
    • 4.6b Mass producing Input Sheets 4b Creating a Worksheet - 8:06
    • 4.6c Mass producing Input Sheets 4c Creating a Worksheet - 8:06
    • 4.7 Mass producing Input Sheets 5 Creating a unique list to prepare for looping - 6:33
    • 4.8 Mass producing Input Sheets 6 Instantly creating 25 unique input Excel files - 9:05
  • Module 5: Automation Part 3
    • VBA Gathering Data Part 2 Workbook
    • 5.1 Collating Data from Input Sheets 1 Starting the new process - 5:44
    • 5.2 Collating Data from Input Sheets 2 Open up one file and copy data - 17:05
    • 5.3 Introduction to the DO WHILE LOOP - 6:03
    • 5.4 Collating Data from Input Sheets 3 Looping through all files in a folder and copying data - 17:21
    • 5.5 Collating Data from Input Sheets 4 Setting up new data before we bring into our long boring list - 11:40
    • 5.6 Collating Data from Input Sheets 5 Looking up latest data MANUALLY into our long boring list - 4:11
    • 5.7 Collating Data from Input Sheets 6 Looking up latest data AUTOMATICALLY into our long boring list - 13:00
    • 5.8 Collating Data from Input Sheets 7 putting it all together - 6:19

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
14

Introduction to VBA & Macros

Experience Some Quick Wins & Find Out Exactly How Amazing VBA/Macros Can Be

By Earn and Excel | in Online Courses

You will learn VBA and Macros with this unique experienced-based approach focusing on a handful of key themes. You will be effortless programming in a shockingly quick time frame. This course is so efficient that we don’t even allow you to learn unnecessary and confusing jargon. All other courses teach you first, so you get to experience some quick wins and find out exactly how amazing VBA/Macros can be!

  • Access 14 lectures & 1 hour of content 24//7
  • Understand the importance of VBA & Macros
  • Control cells, ranges, copy & paste
  • Control fonts & color cells
  • Build logic with IF & Select case
  • Get started with automation & looping
  • Work with constants & variables
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel

Course Outline

  • Module 1: VBA Fast-track Part 1
    • VBA Fast-track Part 1 Workbook
    • 1.1 Cells and Ranges - 3:16
    • 1.2 Copy and Paste - 2:30
    • 1.3 Controlling fonts and colouring cells - 4:36
    • 1.4 Multiple lines, clearing and column widths - 6:52
    • 1.5 Building Logic with IF - 4:22
    • 1.6 Building Logic with Select Case - 6:42
    • 1.7 The importance of Loops - 7:52
    • 1.8 Introduction to Automation - 6:25
    • 1.9 loops and ranges - 2:56
    • 1.10 Maneuvering and Macros - 5:11
    • 1.11 Constants and Variables - 2:41
    • 1.12 The MOST important line in VBA you need to know! - 5:24
    • 1.13 Putting together everything so far to demonstrate Automation - 16:17

View Full Curriculum


Access
Lifetime
Content
5.0 hours
Lessons
58

PowerPivot

Deal with Large Volumes of Data & Transform Your Data Analysis Game

By Earn and Excel | in Online Courses

Data is growing at an alarming rate in many situations. Excel is becoming less of a viable option to deal with all of this data, so what do we do? Does it make sense to move to a database immediately? Well, that comes with a lot of commitment and a lot of cost in terms of implementation and maintenance. However, in the last decade, a powerful alternative has emerged, PowerPivot. This course takes you from beginner to advanced level with PowerPivot. It gives you technical advice on how to make the most of PowerPivot and practical advice on how to work with data.

3.9/5 average rating: ★ ★ ★ ★ ★

  • Access 58 lectures & 5 hours of content 24/7
  • Get familiar with the Excel Data Model & learn fundamental Data Modelling concepts
  • Load data into the Data Model from a variety of sources
  • Use Pivot Tables in conjunction with PowerPivot
  • Work with Iterator functions such as TOPN & REATEDTABLE
  • Learn advanced data manipulation with the use Context & Filter functions
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Any device with basic specifications

Course Outline

  • 1 Getting Started With Power Pivot
    • Power Pivot Materials 1
    • 1.1 Introduction to Power Pivot - 10:58
    • 1.2 Data Model Familiarisation - 9:20
    • 1.3 Data Modelling Concepts - 7:24
    • 1.4 Introduction to Data Types - 2:11
  • 2 Loading Data
    • Power Pivot Materials 2
    • 2.1 Loading Data with PowerQuery - 3:42
    • 2.2 Loading Data From Excel Tables - 12:50
    • 2.3 Introduction to using with Pivot Tables - 3:14
    • 2.4 Other Data Load Options - 5:40
    • 2.5 Loading Data From an External Database - 10:49
  • 3 Pivot Tables and Refresh
    • Power Pivot Materials 3
    • 3.1 More on Pivot Tables - 7:23
    • 3.2 Pivot Tables and Relationships - 6:43
    • 3.3 Introduction to Refreshing Data - 3:28
    • 3.4 Refreshing Data via Connections - 6:13
    • 3.5 Refreshing Data from an External Database - 6:12
  • 4 Introduction to DAX
    • Power Pivot Materials 4
    • 4.1 Calculated Columns - 7:02
    • 4.2 Introduction to Measures - 5:29
    • 4.3 Adding Explicit Measures with Autosum - 7:04
    • 4.4 Adding Implicit Measures - 3:56
    • 4.5 Adding Explicit Measures in Power Pivot Menu - 9:35
  • 5 Hierarchies and Related Columns
    • Power Pivot Materials 5
    • 5.1 Introduction - 3:48
    • 5.2 Adding a Hierarchy - 2:53
    • 5.3 Using Hierarchies in a Pivot Table - 4:42
    • 5.4 Drill Paths - 4:55
    • 5.5 Introduction to Related Columns - 6:36
    • 5.6 Related Columns in a Hierarchy - 7:10
    • 5.7 Best Practices with Hierarchies - 2:54
    • 5.8 Editing Hierarchies - 4:19
  • 6 Deeper into DAX
    • Power Pivot Materials 6
    • 6.1 DAX Syntax and Operators - 5:46
    • 6.2 Some Useful DAX Functions Part 1 - 6:50
    • 6.3 Some Useful DAX Functions Part 2 - 2:21
    • 6.4 Some Useful DAX Functions Part 3 - 3:37
    • 6.5 Introduction to Iterator Functions - 3:24
    • 6.6 Expressions in Iterator Functions - 9:49
    • 6.7 Table functions in Iterator Functions (RELATEDTABLE) - 9:00
    • 6.8 Table functions in Iterator Functions (TOPN) - 6:33
    • 6.9 Other Iterator Functions - 4:20
    • 6.10 Introduction to Context - 2:37
    • 6.11 Examples of Context - 9:35
    • 6.12 Filter Context in Pivot Tables - 3:56
    • 6.13 Introduction to Filter Functions - 2:40
    • 6.14 Example of a Filter Function - 5:28
    • 6.15 Using Filters in a Filter Function - 7:31
    • 6.16 Using the ALL Filter Function - 7:47
    • 6.17 Using the ALLSELECTED Filter Function - 5:14
    • 6.18 Introduction to Parent-Child Functions - 6:45
    • 6.19 Using Parent-Child Functions - 11:10
    • 6.20 Using Parent-Child Functions for a Hierarchy - 9:39
    • 6.21 Time Intelligence Functions Part 1 - 5:12
    • 6.22 Time Intelligence Functions Part 2 - 2:35
    • 6.23 Time Intelligence Functions Part 3 - 15:51
    • 6.24 Time Intelligence Functions Part 4 - 7:52
    • 6.25 Key Performance Indicators - 13:58

View Full Curriculum


Access
Lifetime
Content
5.0 hours
Lessons
45

Power Query

Gather, Cleanse & Transform Your Data

By Earn and Excel | in Online Courses

If you have been wasting vast amounts of time at work trying to gather, fix, and combine your Excel data before you’ve ever done any analysis and reporting, then this is the course for you. Power Query is the No.1 Excel feature added in the last decade because it can help you get data from various sources, no matter what format it is, and clean it all up for you with nothing more than a few clicks! This course teaches you how to get, transform, and refresh your data, after which it will be ready for quick analysis and report.

4.7/5 average rating: ★ ★ ★ ★

  • Access 45 lectures & 5 hours of content 24/7
  • Get data from various sources & clean it up
  • Rapidly transpose, pivot & un-pivot your data to make it useful
  • Quickly combine multiple data sets by appending & joining
  • Speed up your data queries with duplication & tweaking parameters
  • Troubleshoot your queries & set up auto refreshing of your data
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel

Course Outline

  • 1 Getting Started with Power Query
    • Power Query Materials 1
    • 1.1 Introduction to Power Query - 3:15
    • 1.2 Getting Familiar with the Power Query Editor - 9:23
    • 1.3.First Data Clean Up for a Pivot Table - 7:06
    • 1.4. Tweaking our Query until the data is correct - 9:25
    • 1.5. Rounding data - 4:28
    • 1.6. Altering Data Types - 2:19
    • 1.7. Filtering out data before we load it - 1:09
    • 1.8. Advanced Calculated Columns - 8:59
    • 1.9. Grouping Columns - 7:03
    • 1.10. Using Columns From Examples - 8:39
  • 2 Transpose, Pivot and Un-Pivot
    • Power Query Materials 2
    • 2.1 Introduction to Transpose, Pivot and Un-Pivot - 9:43
    • 2.2 Pre-preparing messy data - 7:30
    • 2.3 Appropriating our data with Transpose - 14:32
    • 2.4 Un-Pivoting Data - 6:24
    • 2.5 Pivoting Data - 9:24
    • 2.6 Creating a Pivot Chart - 2:34
  • 3 Combining Data From Two or More Data Sets
    • Power Query Materials 3
    • 3.1 Appending data - 8:39
    • 3.2 Introduction to Merging data - 1:32
    • 3.3 Left Outer Join - 6:37
    • 3.4 Right Outer Join - 4:19
    • 3.5 Full Outer Join - 6:18
    • 3.6 Inner Join - 3:29
    • 3.7 Left Anti Join - 2:18
    • 3.8 Right Anti Join - 2:57
    • 3.9 More appending with bigger data sets - 13:29
    • 3.10 Going deeper with Merging data - 23:12
  • 4 Duplication and Parameters
    • Power Query Materials 4
    • 4.1 Duplicating Queries - 6:43
    • 4.2 Speeding up query editing with duplication - 8:14
    • 4.3 Filtering duplicated queries - 4:16
    • 4.4 Working with References - 4:34
    • 4.5 Parameters - 25:03
  • 5 Steps, Groups and Dependencies
    • Power Query Materials 5
    • 5.1 Functions - 14:58
    • 5.2 Dealing with Errors - 13:11
    • 5.3 Steps Part 1- Troubleshooting Queries - 17:20
    • 5.4 Steps Part 2 - 9:33
    • 5.5 Queries and Groups - 12:54
    • 5.6 Advanced Query Editor - 13:36
    • 5.7 Query Refresh - 7:29
    • 5.8 Dependencies - 7:46
    • 5.9 Revisiting Combining Queries - 6:37

View Full Curriculum


Access
Lifetime
Content
2.0 hours
Lessons
46

Ultimate Pivot Tables

Gain Command of This All-Important Data Analysis Tool in Excel

By Earn and Excel | in Online Courses

This is a crash course on Pivot Tables to get you from complete beginner to advanced. It will start immediately by building Pivot Table. You'll learn how to get your data correct and briefly drive into Power Query. It will also teach you important features and tools on layout, formatting, filters, slicers, and more. Once you've gained great understanding, it will step up even more by teaching you advanced analysis.

  • Access 46 lectures & 2 hours of content 24/7
  • Quickly build your first pivot table
  • Refine data by tweaking the layout
  • Dig into running totals, grouping data, sorting, filtering & more
  • Slice & dice your data with multiple filter techniques
  • Connect multiple data sources & use calculated fields for deep analysis)
  • Visualize your data
  • Put your skills to the test & create a sales dashboard
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel

Course Outline

  • 1 Introduction and Data Preparation
    • Pivot Tables Workbook 1
    • 1.1 Introduction to Pivot Tables - 4:28
    • 1.2 Pivot Cache - 1:20
    • 1.3 Altering the Data Source - 2:56
    • 1.4 Unpivot data to a long boring list - 4:16
    • 1.5 Moving row and column - 1:54
    • 1.6 Expand and Collapse field - 3:02
  • 2 Layout and Formats
    • Pivot Tables Workbook 2
    • 2.1 Format Error and Empty cells - 2:06
    • 2.2 Change Layout of Pivot Table - 3:28
    • 2.3 Place Pivot Table - 3:01
    • 2.4 Pivot Table Styles - 2:01
    • 2.5 Format Content in Pivot - 2:01
  • 3 Core Pivot Table Analysis
    • Pivot Tables Workbook 3
    • 3.1 Summarise Value by - 1:48
    • 3.2 Multiple Subtotal - 2:02
    • 3.2 Percentage of column total - 3:02
    • 3.3 Difference From value as percentage - 2:25
    • 3.4 Double click for detail - 1:27
    • 3.5 Running Total - 1:58
    • 3.6 Grouping Year Month Quarter - 2:33
    • 3.7 Sorting - 1:52
  • 4 Filters and Slicers
    • Pivot Tables Workbook 4
    • 4.1 Filtering - Part 1 - 3:17
    • 4.2 Filtering - Part 2 - 3:00
    • 4.3 Slicer - Insert Style Property - 4:31
    • 4.4 One Slicer connected to Multiple Pivots - 4:01
    • 4.5 Timeline Slicer - 4:40
  • 5 Advanced Analysis
    • Pivot Tables Workbook 5
    • 5.1 Calculated Field - 4:21
    • 5.2 Link Multiple Table into One Pivot - Part 1 - 1:42
    • 5.3 Link Multiple Table into One Pivot - Part 2 - 2:21
    • 5.4 Calculated Field with IF statement - 3:28
  • 6 Visuals and Reports
    • Pivot Tables Workbook 6
    • 6.1 Conditional Formatting in Pivot - Part 1 - 3:26
    • 6.2 Conditional Formatting in Pivot - Part 2 - 3:43
    • 6.3 Pivot Charts Part 1 - 2:37
    • 6.4 Pivot Charts Part 2 Links and Slicers - 2:39
    • 6.5 Pivot Charts Part 3 Formatting - 4:14
    • 6.6 Dashboard 1 - What we will build - 0:56
    • 6.7 Dashboard 2 - Our Dataset - 2:26
    • 6.8 Dashboard 3 - Pie Chart - 1:41
    • 6.9 Dashboard 4 - Line Chart - 4:18
    • 6.10 Dashboard 5 - Bar Chart - 3:14
    • 6.11 Dashboard 6 - Map Chart - 4:40
    • 6.12 Dashboard 7 - Put it all together - 9:04

View Full Curriculum


Access
Lifetime
Content
5.0 hours
Lessons
46

Microsoft Publisher 365

Create Business Cards, Greeting Cards, Calendars, Newsletters & Much More

By Earn and Excel | in Online Courses

This course takes you step-by-step from the very basics of setting up Publisher with personalizations and preferences through to designing and publishing a booklet. Along the way, you will learn how to maximize 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 personalize templates for business cards and much, much more.

  • Access 46 lectures & 5 hours of content 24/7
  • Personalize & set page options
  • Insert pages, business info, & setting preferences
  • Insert text boxes, columns & symbols
  • Find & replace list and tab stops
  • Master pages, spell check templates & mail merge
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Publisher

Course Outline

  • 1 Introduction, Personalisation and Setting Page Options
    • 1.1 Introduction to Publisher - 0:58
    • 1.2 Look and feel of Publisher - 8:47
    • 1.3 Personalising QAT - 9:48
    • 1.4 Personalising the ribbon by creating new tabs and groups - 7:21
    • 1.5 Setting up page options before starting - 8:08
  • 2 Pages, Business Info and Preferences
    • 2.1 Inserting pages - 4:33
    • 2.2 Moving and deleting pages - 3:50
    • 2.3 Editing and inserting business info - 6:55
    • 2.4 Setting up preferences in the Options dialog box and using AutoCorrect - 8:30
  • 3 Text Boxes, Formatting, Importing, Columns and Symbols
    • 3.1 Inserting text boxes and text - 9:28
    • 3.2 Formatting text boxes - 10:34
    • 3.3 Formatting text - 8:58
    • 3.4 Further text formatting with WordArt Styles - 7:44
    • 3.5 Importing text and creating columns - 7:20
    • 3.6 Paragraph and columns spacing - 4:28
    • 3.7 Using hyphenations and inserting symbols - 6:38
  • 4 Find and Replace, Lists and Tab Stops
    • 4.1 Using find and replace - 3:21
    • 4.2 Finding words using a wild card - 1:57
    • 4.3 Creating bulleted lists - 5:52
    • 4.4 setting up tab stops - 6:36
  • 5 Tables and Pictures
    • 5.1 Inserting a table - 4:40
    • 5.2 Designing a table - 9:02
    • 5.3 Inserting pictures and text wrapping - 18:58
    • 5.4 Formatting a picture - 5:03
    • 5.5 Cropping a picture - 2:29
    • 5.6 Cropping pictures to shape - 3:22
    • 5.7 more picture effects and settings - 6:42
  • 6 Shapes, Borders, Backgrounds and Inserting Word and Excel
    • 6.1 Inserting shapes and using sample fill colours and grouping objects - 13:51
    • 6.2 Inserting and formatting shapes and its text - 9:21
    • 6.3 Inserting word and excel - 5:18
    • 6.4 Inserting and formatting callouts - 8:08
    • 6.5 Applying page background - 7:36
    • 6.6 Applying page borders - 8:19
  • 7 Master Pages, Spell Check Templates and Mail Merge
    • 7.1 Creating master pages - 14:12
    • 7.2 Running the spell check - 4:26
    • 7.3 Searching for templates and creating a mail merge with the wizard - 11:47
    • 7.4 Creating a mail merge manually - 10:08
  • 8 Design Checker, Embedded Fonts, Printing, Saving and Exporting
    • 8.1 Running the design checker - 4:16
    • 8.2 Managing embedded fonts - 2:46
    • 8.3 Printing the publication - 2:48
    • 8.4 Further saving and exporting options - 6:25
  • 9 Aligning, Anchor Points, Building Blocks, Captions and Hyperlinks
    • 9.1 Aligning objects - 5:01
    • 9.2 Using anchor points and creating new shapes - 14:41
    • 9.3 Creating building blocks - 3:12
    • 9.4 Adding captions and alternative text to images - 3:24
    • 9.5 Inserting hyperlinks - 2:18

View Full Curriculum



Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
×
Your Ad Blocker Is On!
Sadly, recent updates to your Ad Blocker are preventing crucial parts of our shop from loading. Frustrating. We know. We hate to nag, but please turn off your Ad Blocker or whitelist us to continue exploring our shop.