Microsoft Excel 2019 (365): Crash Course
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Master Excel 2019 (365) in under 7 hours!Description
Are you looking to learn Excel 2019 and quickly?
We have developed a crash course on how to get the best out of Excel 2019 that can be completed in under 7 hours!
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. As with all of our courses, we are experienced professionals first and so we can truly empathise with your needs and this shows in the topics we choose and the style in which we teach you.
Take a look at the lessons list and if that sounds like the kind of curriculum that really resonates with you then sign up and we look forward to seeing you on the inside where we can help you raise your skills!
Many Thanks
Sohail Anwar
Requirements
- Requirements
- No prerequisites
- A copy of Excel 2019 or Excel 365 (However this course works perfectly with 2016, 2013,2010 & 2007)
Knowledge
- This is a crash course in Excel 2019 to take you from Beginner To Advanced level in under 7 hours
- You will learn introductory topics such as the Excel interface, sheets, rows, columns and data types
- Get comfortable with Functions (Basic, Copying Functions, Named Ranges)
- Formatting (Format the Sheet, Format Numbers and Conditional Formatting)
- Data Analysis with Sorting, Filtering and Validation
- Advanced Functions such VLOOKUPS, INDEX, MATCH, IF, Nested IFs, Text Formulas and SUMIFS/COUNTIFS
- Data Consolidating with Power Query
- Advanced Data Analysis with Pivot Tables
- Visualise your Data with key Excel Charts and Dashboards
- Speed up your work by recording and tweaking Macros
- Automate with VBA (Object Model, Logic Programming and Managing Errors)
Microsoft Excel - Excel from Beginner to Advanced
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Office 365 Microsoft Excel all in One Package...
Excel - Microsoft Excel Beginner to Advanced [2021]
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Excel Course: Microsoft Excel From Beginner to Advanced, Ms Excel Formulas, Chart Tips & Tricks in Excel 2019/Office 365 Topics covered in the 30-min Getting Started With Excel lecture:...
Excel: Beginning to Expert - Complete Course (updated)
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Learn all the great features like Pivot Tables, Vlookup, Charts, Flash Fill, Auto Fill and so much more! Microsoft Excel 2019 Complete Course....
Microsoft Excel Power Pivot: Power Pivot , DAX & Pivot Table
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Power Excel with Power Pivot, DAX Formulas and Pivot Tables in Excel Power Pivot 2010-2019 & Power Pivot Office 365. ----------------------------------------...
