• No products in the cart.
CPD Accredited Course

0

0

11

Students

GET THIS COURSE AND 1500+ OTHERS FOR ONLY £149. FIND OUT MORE

Course Overview

Gear up to get well equipped in Microsoft Excel Complete Course 2019 now, and make up your mind to be the best in the business! All you need is proper training, firm support and a push to shine in your vocation, and Compliance Central is determined to provide you with it all! Explore what you got in this exclusive Microsoft Excel Complete Course 2019 Skills, start learning and excel in it! This amazing Microsoft Excel Complete Course 2019 course has been designed and developed by the industry specialists.! You’ll get to-the-point knowledge both practical and theoretical, and gain valuable insights into the business which will help you understand the drill better than ever! Join today, be skilled, learn with positive energy and enthusiasm, and create an excellent career using your full potential! Brace yourself, enrol now for an amazing venture!

This Microsoft Excel Complete Course 2019 Course Package Includes

  • Free CPD Accredited PDF Certificate
  • Comprehensive lessons and training provided by experts on Microsoft Excel Complete Course 2019
  • Interactive online learning experience at your convenience
  • 24/7 Access to the course materials and learner assistance
  • Easy accessibility from any smart device (Laptop, Tablet, Smartphone etc.)
  • A happy and handy learning experience for the professionals and students
  • 100% learning satisfaction, guaranteed by Compliance Central — a leading compliance training provider

Certification

You can instantly download your certificate for £4.79 right after finishing the Microsoft Excel Complete Course 2019 course. The hard copy of the certification will also be sent right at your doorstep via post for £10.79. All of our courses are continually reviewed to ensure their quality, and that provide appropriate current training for your chosen subject. As such, although certificates do not expire, it is recommended that they are reviewed or renewed on an annual basis.

Who Is This Course For

Compliance Central aims to prepare efficient human resources for the industry and make it more productive than ever. This helpful course is suitable for any person who is interested in Microsoft Excel Complete Course 2019. There are no pre-requirements to take it. You can attend the course if you are a student, an enthusiast or a
  • Employee
  • Employer
  • Manager
  • Supervisor
  • Entrepreneur
  • Business Professional
  • Company Leader
  • HR Professional

Course Currilcum

    • 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
    • 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
    • Create Worksheet Formulas 00:15:00
    • Insert Functions 00:17:00
    • Reuse Formulas and Functions 00:17:00
    • 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
    • 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
    • Preview and Print a Workbook 00:10:00
    • Set Up the Page Layout 00:09:00
    • Configure Headers and Footers 00:07:00
    • Manage Worksheets 00:05:00
    • Manage Workbook and Worksheet Views 00:07:00
    • Manage Workbook Properties 00:06:00
    • 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
    • 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
    • Apply Intermediate Conditional Formatting 00:07:00
    • Apply Advanced Conditional Formatting 00:05:00
    • Create Charts 00:13:00
    • Modify and Format Charts 00:12:00
    • Use Advanced Chart Features 00:12:00
    • 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
    • Use Links and External References 00:12:00
    • Use 3-D References 00:06:00
    • Consolidate Data 00:05:00
    • Use Lookup Functions 00:12:00
    • Trace Cells 00:09:00
    • Watch and Evaluate Formulas 00:08:00
    • Collaborate on a Workbook 00:19:00
    • Protect Worksheets and Workbooks 00:08:00
    • Apply Data Validation 00:13:00
    • Search for Invalid Data and Formulas with Errors 00:04:00
    • Work with Macros 00:18:00
    • Create Sparklines 00:07:00
    • MapData 00:07:00
    • 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

199 25

  • Calendar 1 Year
  • chart Regular
  • student 11 students
  • clock 10 hours, 39 minutes
Gift this course
£11 /Unit Price
£110

Student Reviews

Ben lim

Gaining improve knowledge in the construction project management and the course is easy to understand.

Mr Brian Joseph Keenan

Very good and informative and quick with marking my assignments and issuing my certificate.

Sarah D

Being a support worker I needed add a child care cert in my portfolio. I have done the course and that was really a good course.

Sam Ryder

The first aid course was very informative with well organised curriculum. I already have some bit and pieces knowledge of first aid, this course helped me a lot.

Ben lim

Gaining improve knowledge in the construction project management and the course is easy to understand.

Thelma Gittens

Highly recommended. The module is easy to understand and definitely the best value for money. Many thanks

BF Carey

First course with Compliance Central. It was a good experience.

Course Currilcum

    • 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
    • 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
    • Create Worksheet Formulas 00:15:00
    • Insert Functions 00:17:00
    • Reuse Formulas and Functions 00:17:00
    • 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
    • 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
    • Preview and Print a Workbook 00:10:00
    • Set Up the Page Layout 00:09:00
    • Configure Headers and Footers 00:07:00
    • Manage Worksheets 00:05:00
    • Manage Workbook and Worksheet Views 00:07:00
    • Manage Workbook Properties 00:06:00
    • 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
    • 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
    • Apply Intermediate Conditional Formatting 00:07:00
    • Apply Advanced Conditional Formatting 00:05:00
    • Create Charts 00:13:00
    • Modify and Format Charts 00:12:00
    • Use Advanced Chart Features 00:12:00
    • 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
    • Use Links and External References 00:12:00
    • Use 3-D References 00:06:00
    • Consolidate Data 00:05:00
    • Use Lookup Functions 00:12:00
    • Trace Cells 00:09:00
    • Watch and Evaluate Formulas 00:08:00
    • Collaborate on a Workbook 00:19:00
    • Protect Worksheets and Workbooks 00:08:00
    • Apply Data Validation 00:13:00
    • Search for Invalid Data and Formulas with Errors 00:04:00
    • Work with Macros 00:18:00
    • Create Sparklines 00:07:00
    • MapData 00:07:00
    • 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