5

5

ratings 

This Mastering Excel 2019 - Advanced course is designed for professionals who want to thrive in their profession. The course covers all the essential skills and knowledge needed to become specialised in this sector.

£15.00
Course Access

Unlimited Duration

Last Updated

November 6, 2021

Students Enrolled

4

Course Duration

4 hours, 24 minutes

Course Instructor
Certification
This Mastering Excel 2019 - Advanced course is designed for professionals who want to thrive in their profession. The Mastering Excel 2019 - Advanced course covers all the essential skills and knowledge needed to become specialised in this sector. You will learn real life knowledge and expertise from the industry experts and practitioners from this Mastering Excel 2019 - Advanced course.
 
The Mastering Excel 2019 - Advanced Course starts with the basic knowledge of Mastering Excel 2019 - Advanced and gradually shares expertise knowledge. In this course you will get a complete idea of Mastering Excel 2019 - Advanced with key concepts, strategies regarding use of it and in-depth knowledge. The Mastering Excel 2019 - Advanced course is completely an online course. You can access this course from any part of the world with just a smart device and the internet.
 
By the end of this course, you will get complete knowledge and marketable skills. The course also comes with an E-certificate, which will add extra value to your resume and help you stand out in the job market. In short, Mastering Excel 2019 - Advanced Course is the perfect course to fast track your career. So what are you waiting for? Enrol today!
 

What you will learn

  • Use multiple worksheets and workbooks to track, retrieve, consolidate and report on data using features like cell links, Group Mode, 3D Reference formulas, and Consolidate.
  • Prepare a document for sharing by checking for accessibility and sensitive information, as well as multiple ways to protect your worksheets and workbooks from changes.
  • Perform complex calculations by developing a deep understanding of Excel’s Lookup functions like VLOOKUP, MATCH, and INDEX.
  • Use your data to plan and forecast trends and explore a variety of outcomes based on variables and scenarios.
  • Collaborate with others using Comments, Track Changes, Sharing, Co-Authoring, and Compare and Merge.
  • Keep your data consistent and accurate with Data Validation and automate tasks with Macros.
  • Quickly find and address errors in your formulas with Tracing, Evaluate Formula, and the Watch Window, as well as add error handling with the IFNA and IFERROR functions.
  • Visualize geographic data with Map Charts and 3D Map Tours.
 

Course Media

Who is this course for?

This course is ideal for those who work in or aspire to work in the following professions:
  • People who have a working knowledge of Excel 2019 or Excel 365, but want to use more complex functions and features to analyze data.
 

Why Choose Mastering Excel 2019 - Advanced course?

  • Conducted by industry experts
  • Get Instant E-certificate
  • Fully online, interactive course with Professional voice-over
  • Developed by qualified professionals
  • Self paced learning and laptop, tablet, smartphone friendly
  • Tutor Support
 

Certification

By the successful completion of the course, you will get an instant e-certificate. Our courses are fully updated, that aim at making you an expert in the field. The hard copy of the certificate is also available for £4.99 and can be sent to your address. The delivery charge is applicable which will be £3.99.

Instructor

Profile Photo
5 5
1745

Students

Accredited by

Rated Excellent on Trustpilot

14 Days Moneyback Gurantee

Course Central 14 Days Money Back

Course Curriculum

    • Introduction 00:02:00
    • Creating Internal Links 00:04:00
    • Creating External Links 00:09:00
    • Using Paste Special 00:06:00
    • Using Group Mode 00:03:00
    • Using 3D References 00:03:00
    • Consolidating Data 00:07:00
    • Adding Comments 00:05:00
    • Tracking Changes 00:06:00
    • Co-Authoring, Part 1 00:06:00
    • Co-Authoring, Part 2 00:05:00
    • Using Compare and Merge 00:03:00
    • Preparing to Share 00:07:00
    • Adding Digital Signatures 00:06:00
    • Protecting Worksheets 00:11:00
    • Protecting Workbook Structure 00:03:00
    • Protecting a Workbook File 00:07:00
    • Applying Data Validation 00:07:00
    • Adding a Dropdown List 00:05:00
    • Customizing Data Validation 00:05:00
    • Recording a Macro. 00:08:00
    • Running a Macro 00:06:00
    • Editing a Macro 00:08:00
    • Using VLOOKUP, Part 1 00:06:00
    • Using VLOOKUP, Part 2 00:05:00
    • More Lookup Functions 00:10:00
    • Using Array Formulas 00:06:00
    • Tracing Formulas 00:06:00
    • Addressing Formula Errors 00:07:00
    • Watching and Evaluating Formulas 00:05:00
    • Adding Error Handling 00:05:00
    • Working with Information Functions 00:05:00
    • Using Goal Seek 00:04:00
    • Forecasting with Data Tables 00:05:00
    • Using Solver 00:07:00
    • Forecasting with Scenarios 00:08:00
    • Forecasting Data Trends 00:03:00
    • Inserting Symbols and Characters 00:03:00
    • Creating Sparklines 00:04:00
    • Creating a Map Chart 00:04:00
    • Creating 3D Maps 00:08:00
    • Creating Custom Lists 00:06:00
    • Importing and Exporting Data 00:03:00
    • Creating a Web Query 00:04:00
    • Working with Forms 00:10:00
    • Using ActiveX Controls 00:04:00
    • Ideas in Office 365 00:04:00
    • Get Your Certificate & Transcript 00:00:00

Course Reviews

© Course Central 2021. Course Central is a trading style of Idea Republic Ltd. Company registered in England and Wales. Registration no: 08664232 | Registered Address: 1 Flag Business Exchange, Vicarage Farm Road, Peterborough, PE1 5TX | VAT no: 196 1993 55

X