• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Complete Microsoft Excel

Complete Microsoft Excel

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 11 hours

  • All levels

Description

Are you looking to improve your current abilities or make a career move? Our unique Complete Microsoft Excel Course might help you get there! Expand your expertise with high-quality training - study the Complete Microsoft Excel and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the online training course.

This Complete Microsoft Excel online training course is accredited by CPD with 15 CPD points for professional development. Students can expect to complete this training course in around 11 hours. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our course.

The course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Complete Microsoft Excel course, you will receive an instant e-certificate as proof of the comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enroling on this course.

With this comprehensive course, you can achieve your dreams and train for your ideal career. The Complete Microsoft Excel course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development.

You'll get a Free Student ID card by enroling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards.

Enroling on the Complete Microsoft Excel course will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the program.

Why Prefer this Complete Microsoft Excel Course?

  • Opportunity to earn a certificate accredited by CPD after completing this course

  • Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery)

  • Standard-aligned lesson planning

  • Innovative and engaging content and activities

  • Assessments that measure higher-level thinking and skills

  • Complete the program in your own time, at your own pace

  • Each of our students gets full 24/7 tutor support

Experts created the Complete Microsoft Excel course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you.

Start your learning journey straight away with this course and take a step toward a brighter future!

*** Course Curriculum ***

Here are the topics you will cover on the Course:

>> Complete Microsoft Excel <<

Module 01: Microsoft Excel 2019 New Features

  • Introduction to Microsoft Excel 2019 New Features

  • CONCAT

  • IFS

  • MAXIFS

  • MINIFS

  • SWITCH

  • TEXTJOIN

  • Map Chart

  • Funnel Chart

  • Better Visuals

  • Pivot Table Enhancements

  • Power Pivot Updates

Module 02: Getting Started with Microsoft Office Excel

  • Navigate the Excel User Interface

  • Use Excel Commands

  • Create and Save a Basic Workbook

  • Enter Cell Data

  • Use Excel Help

Module 03: Performing Calculations

  • Create Worksheet Formulas

  • Insert Functions

  • Reuse Formulas and Functions

Module 04: Modifying a Worksheet

  • Insert, Delete, and Adjust Cells, Columns, and Rows

  • Search for and Replace Data

  • Use Proofing and Research Tools

Module 05: Formatting a Worksheet

  • Apply Text Formats

  • Apply Number Format

  • Align Cell Contents

  • Apply Styles and Themes

  • Apply Basic Conditional Formatting

  • Create and Use Templates

Module 06: Printing Workbooks

  • Preview and Print a Workbook

  • Set Up the Page Layout

  • Configure Headers and Footers

Module 07: Managing Workbooks

  • Manage Worksheets

  • Manage Workbook and Worksheet Views

  • Manage Workbook Properties

Module 08: Working with Functions

  • Work with Ranges

  • Use Specialized Functions

  • Work with Logical Functions

  • Work with Date & Time Functions

  • Work with Text Functions

Module 09: Working with Lists

  • Sort Data

  • Filter Data

  • Query Data with Database Functions

  • Outline and Subtotal Data

Module 10: Analyzing Data

  • Apply Intermediate Conditional Formatting

  • Apply Advanced Conditional Formatting

Module 11: Visualizing Data with Charts

  • Create Charts

  • Modify and Format Charts

  • Use Advanced Chart Features

Module 12: Using PivotTables and PivotCharts

  • Create a PivotTable

  • Analyze PivotTable Data

  • Present Data with PivotCharts

  • Filter Data by Using Timelines and Slicers

Module 13: Working with Multiple Worksheets and Workbooks

  • Use Links and External References

  • Use 3-D References

  • Consolidate Data

Module 14: Using Lookup Functions and Formula Auditing

  • Use Lookup Functions

  • Trace Cells

  • Watch and Evaluate Formulas

Module 15: Sharing and Protecting Workbooks

  • Collaborate on a Workbook

  • Protect Worksheets and Workbooks

Module 16: Automating Workbook Functionality

  • Apply Data Validation

  • Search for Invalid Data and Formulas with Errors

  • Work with Macros

Module 17: Creating Sparklines and Mapping Data

  • Create Sparklines

  • MapData

Module 18: Forecasting Data

  • Determine Potential Outcomes Using Data Tables

  • Determine Potential Outcomes Using Scenarios

  • Use the Goal Seek Feature

  • Forecasting Data Trends

Module 19: Excel Templates

  • Excel Templates

Assessment Process

Once you have completed all the modules in the Complete Microsoft Excel course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards.

CPD

15 CPD hours / points Accredited by CPD Quality Standards

Who is this course for?

Anyone interested in learning more about the topic is advised to take this course. This course is open to everybody.

Requirements

You will not need any prior background or expertise to enrol in this course.

Career path

After completing this course, you are to start your career or begin the next phase of your career.

Certificates

CPD Accredited Certificate

Digital certificate - £10

CPD Accredited Certificate

Hard copy certificate - £29

If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

About The Provider

Tags

Reviews