Master Microsoft Excel - Excel from Beginner to Advanced

Course

Online

£ 12 + VAT

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Microsoft Excel All-In-One TrainingThis Microsoft Excel course includes all three Levels from Beginner to AdvancedMicrosoft Excel Level 1 - Beginner
Microsoft Excel Level 2 - Intermediate
Microsoft Excel Level 3 - AdvancedAs your instructor I will use my 18+ years of Excel training and certifications including: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016, Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP) to guide you step by step through Beginner, Intermediate and Advanced Levels of Excel.At completion of this course you will master Excel skills that will alleviate the discomfort of uncertainty and reduce time working through your daily tasks. Below are just a few of the topics that you will master:Creating effective worksheets
Writing and editing formulas and calculations
Use sorting and filtering options
Build a database right the first time and avoid common design flaws
Creating informative and captivating Charts
Eliminate repetitive tasks instantly using Macros
Create many scenarios with varying groups of data
Manage large ranges of data in a List or Table
Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, INDEX and much more

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Master Microsoft Excel from Beginner to Advanced
Build a solid understanding on the Basics of Microsoft Excel
Writing Formulas and performing Calculations
Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, INDEX and much more
Create charts with Trend Lines, and Dual Axis
Use Excel as a Database with Sort and Filter options
How to avoid the most common Database Design flaws
Taught by Certified Microsoft Office Excel 2016 Specialist and Expert with over 18 years of Excel training

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • MS Excel
  • Microsoft excel training
  • Ms Office
  • Trainer
  • Database training
  • Database
  • Spreadsheet
  • Microsoft Excel
  • Office IT
  • Options
  • Access
  • Excel

Course programme

Excel Level 1 – Beginner 1 lecture 04:09 Level 1 - Exercise Files, Instructor's Notes, Quiz and Answers
  • Exercise Files - the exercise files are provided for you to practice what you've learned after watching the training videos. The exercise files are numbered, and are the exact same as the instructor uses in the video
  • Instructor Notes - are quick notes about the main points covered in the training videos, and are typically used to reference a point quickly without having to watch the entire training video over again
  • Quiz & Answers - there are two separate .pdf files: Quiz and Answers. The Quiz has one question for each video to test yourself on what was presented, and of course the answers to compare
  • Excel Level 1 – Beginner 1 lecture 04:09 Level 1 - Exercise Files, Instructor's Notes, Quiz and Answers
  • Exercise Files - the exercise files are provided for you to practice what you've learned after watching the training videos. The exercise files are numbered, and are the exact same as the instructor uses in the video
  • Instructor Notes - are quick notes about the main points covered in the training videos, and are typically used to reference a point quickly without having to watch the entire training video over again
  • Quiz & Answers - there are two separate .pdf files: Quiz and Answers. The Quiz has one question for each video to test yourself on what was presented, and of course the answers to compare
  • Level 1 - Exercise Files, Instructor's Notes, Quiz and Answers
  • Exercise Files - the exercise files are provided for you to practice what you've learned after watching the training videos. The exercise files are numbered, and are the exact same as the instructor uses in the video
  • Instructor Notes - are quick notes about the main points covered in the training videos, and are typically used to reference a point quickly without having to watch the entire training video over again
  • Quiz & Answers - there are two separate .pdf files: Quiz and Answers. The Quiz has one question for each video to test yourself on what was presented, and of course the answers to compare
  • Level 1 - Exercise Files, Instructor's Notes, Quiz and Answers
  • Exercise Files - the exercise files are provided for you to practice what you've learned after watching the training videos. The exercise files are numbered, and are the exact same as the instructor uses in the video
  • Instructor Notes - are quick notes about the main points covered in the training videos, and are typically used to reference a point quickly without having to watch the entire training video over again
  • Quiz & Answers - there are two separate .pdf files: Quiz and Answers. The Quiz has one question for each video to test yourself on what was presented, and of course the answers to compare
  • Level 1 - Exercise Files, Instructor's Notes, Quiz and Answers
  • Exercise Files - the exercise files are provided for you to practice what you've learned after watching the training videos. The exercise files are numbered, and are the exact same as the instructor uses in the video
  • Instructor Notes - are quick notes about the main points covered in the training videos, and are typically used to reference a point quickly without having to watch the entire training video over again
  • Quiz & Answers - there are two separate .pdf files: Quiz and Answers. The Quiz has one question for each video to test yourself on what was presented, and of course the answers to compare
  • Level 1 - Exercise Files, Instructor's Notes, Quiz and Answers
  • Exercise Files - the exercise files are provided for you to practice what you've learned after watching the training videos. The exercise files are numbered, and are the exact same as the instructor uses in the video
  • Instructor Notes - are quick notes about the main points covered in the training videos, and are typically used to reference a point quickly without having to watch the entire training video over again
  • Quiz & Answers - there are two separate .pdf files: Quiz and Answers. The Quiz has one question for each video to test yourself on what was presented, and of course the answers to compare
  • Exercise Files - the exercise files are provided for you to practice what you've learned after watching the training videos. The exercise files are numbered, and are the exact same as the instructor uses in the video
  • Instructor Notes - are quick notes about the main points covered in the training videos, and are typically used to reference a point quickly without having to watch the entire training video over again
  • Quiz & Answers - there are two separate .pdf files: Quiz and Answers. The Quiz has one question for each video to test yourself on what was presented, and of course the answers to compare
  • Exercise Files - the exercise files are provided for you to practice what you've learned after watching the training videos. The exercise files are numbered, and are the exact same as the instructor uses in the video
  • Instructor Notes - are quick notes about the main points covered in the training videos, and are typically used to reference a point quickly without having to watch the entire training video over again
  • Quiz & Answers - there are two separate .pdf files: Quiz and Answers. The Quiz has one question for each video to test yourself on what was presented, and of course the answers to compare
  • Basics 10 lectures 01:06:45 Excel Introduction - First Look Excel introduction for beginners who want to get started with the first look at Excel, by Microsoft Certified Trainer. Themes, Save Location, Back Stage & Fonts Learn how to set default options for: Office Theme, Save Location, Backstage , Font, Body Font, Theme Fonts and Excel 2016 Startup Screen. Quick Access Toolbar Excel 2016 training video on how to customize the Quick Access Toolbar, by adding and removing commands from the toolbar that you can then access from it in a single click! Excel 2016 training video. Ribbon Excel 2016 training video on how to customize the Ribbon including: adding Tabs, Groups and Commands, as well as hiding, deleting or resetting it. Watch my Excel 2016 training on the Ribbon! Navigating Shortcuts, Tips, Tricks & Selecting Cells Excel 2016 tutorial on how to navigate the cells in your spreadsheet with some great tips, tricks and shortcuts. Also learn how to select cells either separately, as a group, or non-linearly. Data Entry & Basic Worksheet Excel 2016 tutorial on the basics of entering data into a cell, on a spreadsheet! And then how to create your own first mini database, or table of data! Save, Save As & Backup Copy Excel 2016 tutorial on how to save your workbook, and the difference between "Save" and "Save As"; where you can use the "Save As" feature to save a copy of your workbook. However, the first time you save any Excel workbook it will force you to "Save As" and I explain why in the Excel tutorial. Convert To 2016 Excel 2016 tutorial on how to convert older versions of Excel to Excel 2016. Compatibility Checker Excel 2016 Tutorial on how to check the compatibility of the current version of Excel when converting it to an earlier version of Excel. For example, some features in Excel 2016 may not appear, or function in earlier version of Excel, and the Compatibility feature will check to see what current Excel 2016 features won't convert. Tell Me What You Want To Do - The New Help Feature Excel 2016 tutorial on the new Excel 2016 feature, "Tell Me What You Want To Do", or the newest version of accessing Help in Excel 2016. Basics. 10 lectures 01:06:45 Excel Introduction - First Look Excel introduction for beginners who want to get started with the first look at Excel, by Microsoft Certified Trainer. Themes, Save Location, Back Stage & Fonts Learn how to set default options for: Office Theme, Save Location, Backstage , Font, Body Font, Theme Fonts and Excel 2016 Startup Screen. Quick Access Toolbar Excel 2016 training video on how to customize the Quick Access Toolbar, by adding and removing commands from the toolbar that you can then access from it in a single click! Excel 2016 training video. Ribbon Excel 2016 training video on how to customize the Ribbon including: adding Tabs, Groups and Commands, as well as hiding, deleting or resetting it. Watch my Excel 2016 training on the Ribbon! Navigating Shortcuts, Tips, Tricks & Selecting Cells Excel 2016 tutorial on how to navigate the cells in your spreadsheet with some great tips, tricks and shortcuts. Also learn how to select cells either separately, as a group, or non-linearly. Data Entry & Basic Worksheet Excel 2016 tutorial on the basics of entering data into a cell, on a spreadsheet! And then how to create your own first mini database, or table of data! Save, Save As & Backup Copy Excel 2016 tutorial on how to save your workbook, and the difference between "Save" and "Save As"; where you can use the "Save As" feature to save a copy of your workbook. However, the first time you save any Excel workbook it will force you to "Save As" and I explain why in the Excel tutorial. Convert To 2016 Excel 2016 tutorial on how to convert older versions of Excel to Excel 2016. Compatibility Checker Excel 2016 Tutorial on how to check the compatibility of the current version of Excel when converting it to an earlier version of Excel. For example, some features in Excel 2016 may not appear, or function in earlier version of Excel, and the Compatibility feature will check to see what current Excel 2016 features won't convert. Tell Me What You Want To Do - The New Help Feature Excel 2016 tutorial on the new Excel 2016 feature, "Tell Me What You Want To Do", or the newest version of accessing Help in Excel 2016. Excel Introduction - First Look Excel introduction for beginners who want to get started with the first look at Excel, by Microsoft Certified Trainer. Excel Introduction - First Look Excel introduction for beginners who want to get started with the first look at Excel, by Microsoft Certified Trainer. Excel Introduction - First Look Excel introduction for beginners who want to get started with the first look at Excel, by Microsoft Certified Trainer. Excel Introduction - First Look Excel introduction for beginners who want to get started with the first look at Excel, by Microsoft Certified Trainer. Excel introduction for beginners who want to get started with the first look at Excel, by Microsoft Certified Trainer. Excel introduction for beginners who want to get started with the first look at Excel, by Microsoft Certified Trainer. Themes, Save Location, Back Stage & Fonts Learn how to set default options for: Office Theme, Save Location, Backstage , Font, Body Font, Theme Fonts and Excel 2016 Startup Screen. Themes, Save Location, Back Stage & Fonts Learn how to set default options for: Office Theme, Save Location, Backstage , Font, Body Font, Theme Fonts and Excel 2016 Startup Screen. Themes, Save Location, Back Stage & Fonts Learn how to set default options for: Office Theme, Save Location, Backstage , Font, Body Font, Theme Fonts and Excel 2016 Startup Screen. Themes, Save Location, Back Stage & Fonts Learn how to set default options for: Office Theme, Save Location, Backstage , Font, Body Font, Theme Fonts and Excel 2016 Startup Screen. Learn how to set default options for: Office Theme, Save Location, Backstage , Font, Body Font, Theme Fonts and Excel 2016 Startup Screen. Learn how to set default options for: Office Theme, Save Location, Backstage , Font, Body Font, Theme Fonts and Excel 2016 Startup Screen. Quick Access Toolbar Excel 2016 training video on how to customize the Quick Access Toolbar, by adding and removing commands from the toolbar that you can then access from it in a single click! Excel 2016 training video. Quick Access Toolbar Excel 2016 training video on how to customize the Quick Access Toolbar, by adding and removing commands from the toolbar that you can then access from it in a single click! Excel 2016 training video. Quick Access Toolbar Excel 2016 training video on how to customize the Quick Access Toolbar, by adding and removing commands from the toolbar that you can then access from it in a single click! Excel 2016 training video. Quick Access Toolbar Excel 2016 training video on how to customize the Quick Access Toolbar, by adding and removing commands from the toolbar that you can then access from it in a single click! Excel 2016 training video. Excel 2016 training video on how to customize the Quick Access Toolbar, by adding and removing commands from the toolbar that you can then access from it in a single click! Excel 2016 training video. Excel 2016 training video on how to customize the Quick Access Toolbar, by adding and removing commands from the toolbar that you can then access from it in a single click! Excel 2016 training video. Ribbon Excel 2016 training video on how to customize the Ribbon including: adding Tabs, Groups and Commands, as well as hiding, deleting or resetting it. Watch my Excel 2016 training on the Ribbon! Ribbon Excel 2016 training video on how to customize the Ribbon including: adding Tabs, Groups and Commands, as well as hiding, deleting or resetting it. Watch my Excel 2016 training on the Ribbon! Ribbon Excel 2016 training video on how to customize the Ribbon including: adding Tabs, Groups and Commands, as well as hiding, deleting or resetting it. Watch my Excel 2016 training on the Ribbon! Ribbon Excel 2016 training video on how to customize the Ribbon including: adding Tabs, Groups and Commands, as well as hiding, deleting or resetting it. Watch my Excel 2016 training on the Ribbon! Excel 2016 training video on how to customize the Ribbon including: adding Tabs, Groups and Commands, as well as hiding, deleting or resetting it. Watch my Excel 2016 training on the Ribbon! Excel 2016 training video on how to customize the Ribbon including: adding Tabs, Groups and Commands, as well as hiding, deleting or resetting it. Watch my Excel 2016 training on the Ribbon! Navigating Shortcuts, Tips, Tricks & Selecting Cells Excel 2016 tutorial on how to navigate the cells in your spreadsheet with some great tips, tricks and shortcuts xcel...

    Additional information

    This course was created with Excel 2016. However, Excel 2007, 2010, 2013, 2016, 2019 and 365 will work with most, or all features You will need Microsoft Excel installed on your computer to follow along and complete the exercise files

    Master Microsoft Excel - Excel from Beginner to Advanced

    £ 12 + VAT