Learn Microsoft Excel from A-Z: Beginner To Expert Course

Course

Online

£ 10 VAT inc.

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Welcome to the Learn Microsoft Excel from A-Z: Beginner To Expert Course
In this practical, hands-on course our main objective is to give you the education not just to understand the ins and outs of Microsoft Excel, but also to learn exactly how to master pivot tables, formulas, macros, vba, data analysis, and how to land your first job as an Excel expert!
This course will fully prepare you for virtually any Excel related career path, including those that require advanced skills with this software. Once you complete the course, you’ll have access to the full functionality of Excel, and will know how to use all formulas, functions, and capabilities.You’ll also learn about calculating depreciation, calculating interest, and even calculating EMI for loans, all by using Excel functions. The course also features information on INDEX and MATCH functions as well as using the CHOOSE formula, and how to create special charts.
Whether you are brand new to the world of Excel, or you have training and knowledge of the software and are looking to improve your skills, this masterclass will take you to the next level. By the time you finish the beginner, intermediate and advanced portions, you too will be an expert in Excel.
We understand that theory is important to build a solid foundation, we understand that theory alone isn’t going to get the job done so that’s why this course is packed with practical hands-on examples that you can follow step by step. Even if you already have some experience, or want to learn about the advanced features of Excel, this course is for you!
Together we’re going to give you the foundational education that you need to know not just on how to use Excel at an expert level, but also how to get paid for your newly developed skills.The course covers 4 main areas:
1: INTRO TO EXCEL

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Learn to master Excel from A-Z
How to become a professional Data Analyst
How to be a better, faster, stronger Excel user
How to land your first job as an Excel Expert
How to save hours of time and boost your productivity in Excel
How to find a value with VLOOKUP, HLOOKUP, INDEX, MATCH
How to use math, statistical, logic and text functions
How to use VBA and Macros
How to use VLOOKUP/HLOOKUP in formulas
How to create basic and advanced formulas
Mastering Pivot Tables
Creating Charts from your data

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

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

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

Subjects

  • MS Excel
  • Microsoft excel training
  • Microsoft Excel
  • Access
  • Excel

Course programme

Introduction 5 lectures 16:26 Intro To Excel Course Section Overview Intro To Excel Course Section Overview Who is this course for? Microsoft Excel Marketplace Microsoft Excel Job Opportunities Microsoft Excel Job Roles Introduction 5 lectures 16:26 Intro To Excel Course Section Overview Intro To Excel Course Section Overview Who is this course for? Microsoft Excel Marketplace Microsoft Excel Job Opportunities Microsoft Excel Job Roles Intro To Excel Course Section Overview Intro To Excel Course Section Overview Intro To Excel Course Section Overview Intro To Excel Course Section Overview Intro To Excel Course Section Overview Intro To Excel Course Section Overview Intro To Excel Course Section Overview Intro To Excel Course Section Overview Intro To Excel Course Section Overview Intro To Excel Course Section Overview Who is this course for? Who is this course for? Who is this course for? Who is this course for? Microsoft Excel Marketplace Microsoft Excel Marketplace Microsoft Excel Marketplace Microsoft Excel Marketplace Microsoft Excel Job Opportunities Microsoft Excel Job Opportunities Microsoft Excel Job Opportunities Microsoft Excel Job Opportunities Microsoft Excel Job Roles Microsoft Excel Job Roles Microsoft Excel Job Roles Microsoft Excel Job Roles Getting Started with Excel 8 lectures 18:52 Excel's Start Screen Explaining the Excel Interface Excel Interface Continued Excel Workbook vs Excel Worksheet Saving & Opening Excel Documents Customizing the Excel Quick Access Toolbar Customizing the Excel Ribbon Excel Shortcut Keys Getting Started with Excel 8 lectures 18:52 Excel's Start Screen Explaining the Excel Interface Excel Interface Continued Excel Workbook vs Excel Worksheet Saving & Opening Excel Documents Customizing the Excel Quick Access Toolbar Customizing the Excel Ribbon Excel Shortcut Keys Excel's Start Screen Excel's Start Screen Excel's Start Screen Excel's Start Screen Explaining the Excel Interface Explaining the Excel Interface Explaining the Excel Interface Explaining the Excel Interface Excel Interface Continued Excel Interface Continued Excel Interface Continued Excel Interface Continued Excel Workbook vs Excel Worksheet Excel Workbook vs Excel Worksheet Excel Workbook vs Excel Worksheet Excel Workbook vs Excel Worksheet Saving & Opening Excel Documents Saving & Opening Excel Documents Saving & Opening Excel Documents Saving & Opening Excel Documents Customizing the Excel Quick Access Toolbar Customizing the Excel Quick Access Toolbar Customizing the Excel Quick Access Toolbar Customizing the Excel Quick Access Toolbar Customizing the Excel Ribbon Customizing the Excel Ribbon Customizing the Excel Ribbon Customizing the Excel Ribbon Excel Shortcut Keys Excel Shortcut Keys Excel Shortcut Keys Excel Shortcut Keys Values, Referencing and Formulas 6 lectures 29:51 Creating Excel Labels Entering Numeric Values in Excel Formatting Date Values in Excel Building Basic Formulas in Excel Order of Operations Relative vs Absolute Cell References Values, Referencing and Formulas 6 lectures 29:51 Creating Excel Labels Entering Numeric Values in Excel Formatting Date Values in Excel Building Basic Formulas in Excel Order of Operations Relative vs Absolute Cell References Creating Excel Labels Creating Excel Labels Creating Excel Labels Creating Excel Labels Entering Numeric Values in Excel Entering Numeric Values in Excel Entering Numeric Values in Excel Entering Numeric Values in Excel Formatting Date Values in Excel Formatting Date Values in Excel Formatting Date Values in Excel Formatting Date Values in Excel Building Basic Formulas in Excel Building Basic Formulas in Excel Building Basic Formulas in Excel Building Basic Formulas in Excel Order of Operations Order of Operations Order of Operations Order of Operations Relative vs Absolute Cell References Relative vs Absolute Cell References Relative vs Absolute Cell References Relative vs Absolute Cell References Intro to Excel Functions 5 lectures 20:48 Excel Functions Explained The SUM() Function The MIN() & MAX() Function The AVERAGE() Function COUNT() Functions Intro to Excel Functions 5 lectures 20:48 Excel Functions Explained The SUM() Function The MIN() & MAX() Function The AVERAGE() Function COUNT() Functions Excel Functions Explained Excel Functions Explained Excel Functions Explained Excel Functions Explained The SUM() Function The SUM() Function The SUM() Function The SUM() Function The MIN() & MAX() Function The MIN() & MAX() Function The MIN() & MAX() Function The MIN() & MAX() Function The AVERAGE() Function The AVERAGE() Function The AVERAGE() Function The AVERAGE() Function COUNT() Functions COUNT() Functions COUNT() Functions COUNT() Functions Adjusting Excel Worksheets Excel's Page Layout View ...

Additional information

You'll need Excel 2007, 2010, 2013 or 2016 installed and a desire to learn what Excel can really do for you!

Learn Microsoft Excel from A-Z: Beginner To Expert Course

£ 10 VAT inc.