Microsoft Excel Complete Course 2019

4.9( 9 REVIEWS )
94 STUDENTS
Microsoft Excel Complete Course 2019

Gain excellence in Microsoft Excel. Step by step video lessons. Everything from Pivot tables, VLOOKUP, excel dashboards, and more. Plus you get access to 50+ exclusive excel templates, fully ready for you to use.

Launch the dynamic career you’ve always wanted! Take this high-quality Microsoft Excel Complete Course 2019 course worth to articulate your innovative goals and develop a simple approach for attaining them. 

Whether you’re an aspirant looking to start your dream career, a professional looking to branch out, or somebody in between — this Microsoft Excel Complete Course 2019, QLS Endorsed Course will get you sorted. The rudimentary knowledge in this course will add tremendous value and enable you to establish the meaningful Microsoft Excel Complete Course 2019 career you’ve always craved. 

Get £2495 worth of courses & certificates at only £150 (saving 94%) by enrolling now and become the person who would attract the results you seek. What you plant now, you will harvest later. So, grab this opportunity and start learning!

What unique features you will be getting in this new class of Microsoft Excel Complete Course 2019 – you asked?

You will receive 

This Microsoft Excel Complete Course 2019, 11-in-1 Exclusive Bundle course will help you overcome any career obstacles and support you in establishing your own professional path by providing you with these phenomenal courses —

This Microsoft Excel Complete Course 2019 training will help you become an expert in a relevant sector. Our world-class tutors will help you with every query throughout your learning journey and assist you in mastering Microsoft Excel Complete Course 2019. So, add this Microsoft Excel Complete Course 2019 course to your basket — harness the coveted skills and open the door to your next breakthrough!

Whether you're seeking to begin a new hobby, discover your speciality, or convert your passion into a career, this Microsoft Excel Complete Course 2019 course is the bundle for you. This training will keep you up to date on all the latest advancements and provide you with the necessary guidance in the Microsoft Excel Complete Course 2019 sector

To make the process of assessing and certifying learners easier in this Microsoft Excel Complete Course 2019 bundle, we provide an automated evaluation system.

Learn at your own pace from the comfort of your home, as the rich learning materials of this QLS Endorsed course is accessible from any place at any time. The advanced course curriculums are divided into tiny bite-sized audio-visual modules by industry specialists with years of experience behind them.

Course Curriculum

Microsoft Excel Complete Course 2019
Microsoft Excel 2019 New Features
Introduction to Microsoft Excel 2019 New Features 00:07:00
CONCAT 00:02:00
IFS 00:01:00
MAXIFS 00:01:00
MINIFS 00:01:00
SWITCH 00:02:00
TEXTJOIN 00:01:00
Map Chart 00:02:00
Funnel Chart 00:01:00
Better Visuals 00:06:00
Pivot Table Enhancements 00:02:00
Power Pivot Updates 00:01:00
Getting Started with Microsoft Office Excel
Navigate the Excel User Interface 00:28:00
Use Excel Commands 00:10:00
Create and Save a Basic Workbook 00:19:00
Enter Cell Data 00:12:00
Use Excel Help 00:05:00
Performing Calculations
Create Worksheet Formulas 00:15:00
Insert Functions 00:17:00
Reuse Formulas and Functions 00:17:00
Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00
Search for and Replace Data 00:09:00
Use Proofing and Research Tools 00:07:00
Formatting a Worksheet
Apply Text Formats 00:16:00
Apply Number Format 00:08:00
Align Cell Contents 00:09:00
Apply Styles and Themes 00:12:00
Apply Basic Conditional Formatting 00:11:00
Create and Use Templates 00:08:00
Printing Workbooks
Preview and Print a Workbook 00:10:00
Set Up the Page Layout 00:09:00
Configure Headers and Footers 00:07:00
Managing Workbooks
Manage Worksheets 00:05:00
Manage Workbook and Worksheet Views 00:07:00
Manage Workbook Properties 00:06:00
Working with Functions
Work with Ranges 00:18:00
Use Specialized Functions 00:11:00
Work with Logical Functions 00:23:00
Work with Date & Time Functions 00:08:00
Work with Text Functions 00:11:00
Working with Lists
Sort Data 00:10:00
Filter Data 00:10:00
Query Data with Database Functions 00:09:00
Outline and Subtotal Data 00:09:00
Analyzing Data
Apply Intermediate Conditional Formatting 00:07:00
Apply Advanced Conditional Formatting 00:05:00
Visualizing Data with Charts
Create Charts 00:13:00
Modify and Format Charts 00:12:00
Use Advanced Chart Features 00:12:00
Using PivotTables and PivotCharts
Create a PivotTable 00:13:00
Analyze PivotTable Data 00:12:00
Present Data with PivotCharts 00:07:00
Filter Data by Using Timelines and Slicers 00:11:00
Working with Multiple Worksheets and Workbooks
Use Links and External References 00:12:00
Use 3-D References 00:06:00
Consolidate Data 00:05:00
Using Lookup Functions and Formula Auditing
Use Lookup Functions 00:12:00
Trace Cells 00:09:00
Watch and Evaluate Formulas 00:08:00
Sharing and Protecting Workbooks
Collaborate on a Workbook 00:19:00
Protect Worksheets and Workbooks 00:08:00
Automating Workbook Functionality
Apply Data Validation 00:13:00
Search for Invalid Data and Formulas with Errors 00:04:00
Work with Macros 00:18:00
Creating Sparklines and Mapping Data
Create Sparklines 00:07:00
MapData 00:07:00
Forecasting Data
Determine Potential Outcomes Using Data Tables 00:08:00
Determine Potential Outcomes Using Scenarios 00:09:00
Use the Goal Seek Feature 00:04:00
Forecasting Data Trends 00:05:00
Excel VBA Data Management
Create a Macro Using the Macro Recorder 01:00:00
Edit a Macro 01:00:00
Debug a Macro 00:30:00
Customize the Quick Access Toolbar and Hotkeys 00:30:00
Set Macro Security 01:00:00
Insert Text 00:30:00
Format Text 00:30:00
Sort Data 00:30:00
Duplicate Data 01:00:00
Generate a Report 01:00:00
Determine the Dialog Box Type 00:15:00
Capture User Input 01:00:00
Insert, Copy, and Delete Worksheets 00:30:00
Rename Worksheets 00:30:00
Modify the Order of Worksheets 00:15:00
Print Worksheets 00:30:00
Create User-Defined Functions 00:30:00
Automate SUM Functions 00:30:00
Activities and Exercise Files – Microsoft Excel 2016 and VBA 00:00:00
Excel Templates
Excel Templates 00:00:00
Resources
Resources – Microsoft Excel Complete Course 2019 4 days, 4 hours
Mock Exam
Mock Exam – Microsoft Excel Complete Course 2019 00:20:00
Final Exam
Final Exam – Microsoft Excel Complete Course 2019 00:20:00
Assignment
Assignment – Microsoft Excel Complete Course 2019 4 days, 4 hours
Order Your Certificate
Order Your Certificate QLS 00:00:00

Quality Licence Scheme Endorsed Certificate of Achievement

Learners will get an endorsed certificate of achievement (included with the course) directly at their doorstep after successfully completing the package! It should be noted that international students must pay a £10 shipping cost.

For ordering additional QLS Certificates, other than this course, the fees will be following with £10 for international shipping only 

CPD Accredited Certification 

Upon successfully completing each of the courses in this package, you will
be qualified for CPD Accredited Certificates. Certification is available –

It should also be noted that international students must pay a £10 shipping cost.

Endorsement

The Quality Licence Scheme has endorsed this course for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification. Imperial Academy will be able to advise you on any further recognition, for example, progression routes into further and/or higher education.

Imperial Academy is an approved reselling partner for Quality Licence Scheme courses under One Education

Course Info

4.9
94 Enrolled
  • Career Bundle
TAKE THIS COURSE
  • £150.00
  • UNLIMITED ACCESS
  • Number of Units93
  • Number of Quizzes2
  • 1 week, 2 days

© 2022 IMPERIAL ACADEMY COPYRIGHT