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

Course Images

Microsoft Excel Complete Diploma

Microsoft Excel Complete Diploma

By Course Gate

5.0(1)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 11 hours 20 minutes

  • All levels

Description

Become an expert in Microsoft Excel with our Complete Diploma course, where you'll learn in-depth about Excel functions and features. 

You'll study a wide range of topics, from simple calculations to advanced data analysis methods. You'll follow a clear and structured path, with practical exercises to help you apply your skills in real situations.

You'll learn how to use Excel efficiently and effectively, with tips and tricks for performing calculations, modifying worksheets, and formatting data. You'll also learn how to work with Excel functions, manage workbooks, and analyse data to get useful insights.

You'll explore the art of data visualisation with charts and PivotTables, which will help you present complex data in a clear and impactful way. You'll also learn advanced Excel techniques such as automating workbook functionality and forecasting data, which will help you save time and make better decisions.

Whether you want to become a data analyst, a business professional, or an entrepreneur, this course will give you the skills and credentials you need to achieve your career goals. 

Don't miss this opportunity to boost your future success with our comprehensive Excel diploma today!

Learning Outcome of Microsoft Excel Complete Diploma
  • Understand the new features of Microsoft Excel.

  • Master the basics of Microsoft Office Excel.

  • Perform various calculations efficiently.

  • Modify and format worksheets effectively.

  • Print workbooks professionally.

  • Manage workbooks with ease.

  • Utilize a wide range of functions for data analysis.

  • Work with lists and manipulate data effectively.

  • Analyze data using various tools and techniques.

  • Visualize data using charts and graphs.

  • Create and utilize PivotTables and PivotCharts.

  • Work seamlessly with multiple worksheets and workbooks.

  • Utilize lookup functions and formula auditing for accuracy.

  • Share and protect workbooks securely.

  • Automate workbook functionality to improve efficiency.

  • Create Sparklines and map data for enhanced visual representation.

  • Forecast data accurately for informed decision-making.

Key Features of the Course
  • A CPD certificate that is recognised worldwide.

  • A great online learning experience.

  • Interesting and unique online materials and activities.

  • Expert guidance and support from the field leaders.

  • Access to the study resources anytime you want.

  • Friendly and helpful customer service and admin support by email, phone, and chat from Monday through Friday.

  • Get a year-long access to the course.

Who is this course for

This Microsoft Excel Complete Diploma Course is suitable for -

  • Office workers

  • Business professionals

  • Students

  • Data analysts

  • Financial planners

  • Entrepreneurs

  • Researchers

  • Accountants

  • Project managers

  • Anyone interested in mastering Microsoft Excel

Requirements
  • No prerequisites; suitable for individuals from any academic background.

  • Accessible course materials from any internet-enabled device.

CPD Certificate from Course Gate

At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22.

Career path
  • Data Analyst

  • Financial Analyst

  • Business Analyst

  • Accountant

  • Project Manager

  • Administrative Assistant

  • Entrepreneur/Small Business Owner

  • Research Analyst

  • Marketing Manager

  • Educator/Trainer

course Content

19 sections72 lessons
Microsoft Excel New Features12 lessons
  1. 1Introduction to Microsoft Excel 2019 New Features
  2. 2CONCAT
  3. 3IFS
  4. 4MAXIFS
  5. 5MINIFS
  6. 6SWITCH
  7. 7TEXTJOIN
  8. 8Map Chart
  9. 9Funnel Chart
  10. 10Better Visuals
  11. 11Pivot Table Enhancements
  12. 12Power Pivot Updates
Getting Started with Microsoft Office Excel 5 lessons
  1. 1Navigate the Excel User Interface
  2. 2Use Excel Commands
  3. 3Create and Save a Basic Workbook
  4. 4Enter Cell Data
  5. 5Use Excel Help
Performing Calculations3 lessons
  1. 1Create Worksheet Formulas
  2. 2Insert Functions
  3. 3Reuse Formulas and Functions
Modifying a Worksheet3 lessons
  1. 1Insert, Delete, and Adjust Cells, Columns, and Rows
  2. 2Search for and Replace Data
  3. 3Use Proofing and Research Tools
Formatting a Worksheet6 lessons
  1. 1Apply Text Formats
  2. 2Apply Number Format
  3. 3Align Cell Contents
  4. 4Apply Styles and Themes
  5. 5Apply Basic Conditional Formatting
  6. 6Create and Use Templates
Printing Workbooks3 lessons
  1. 1Preview and Print a Workbook
  2. 2Set Up the Page Layout
  3. 3Configure Headers and Footers
Managing Workbooks3 lessons
  1. 1Manage Worksheets
  2. 2Manage Workbook and Worksheet Views
  3. 3Manage Workbook Properties
Working with Functions5 lessons
  1. 1Work with Ranges
  2. 2Use Specialized Functions
  3. 3Work with Logical Functions
  4. 4Work with Date & Time Functions
  5. 5Work with Text Functions
Working with Lists4 lessons
  1. 1Sort Data
  2. 2Filter Data
  3. 3Query Data with Database Functions
  4. 4Outline and Subtotal Data
Analyzing Data3 lessons
  1. 1Create and Modify Tables
  2. 2Apply Intermediate Conditional Formatting
  3. 3Apply Advanced Conditional Formatting
Visualizing Data with Charts3 lessons
  1. 1Create Charts
  2. 2Modify and Format Charts
  3. 3Use Advanced Chart Features
Using PivotTables and PivotCharts4 lessons
  1. 1Create a PivotTable
  2. 2Analyze PivotTable Data
  3. 3Present Data with PivotCharts
  4. 4Filter Data by Using Timelines and Slicers
Working with Multiple Worksheets and Workbooks3 lessons
  1. 1Use Links and External References
  2. 2Use 3-D References
  3. 3Consolidate Data
Using Lookup Functions and Formula Auditing3 lessons
  1. 1Use Lookup Functions
  2. 2Trace Cells
  3. 3Watch and Evaluate Formulas
Sharing and Protecting Workbooks2 lessons
  1. 1Collaborate on a Workbook
  2. 2Protect Worksheets and Workbooks
Automating Workbook Functionality3 lessons
  1. 1Apply Data Validation
  2. 2Search for Invalid Data and Formulas with Errors
  3. 3Work with Macros
Creating Sparklines and Mapping Data2 lessons
  1. 1Create Sparklines
  2. 2MapData
Forecasting Data4 lessons
  1. 1Determine Potential Outcomes Using Data Tables
  2. 2Determine Potential Outcomes Using Scenarios
  3. 3Use the Goal Seek Feature
  4. 4Forecasting Data Trends
Resources1 lessons
  1. 1Resources - Microsoft Excel Complete Diploma

About The Provider

Course Gate
Course Gate
London
5.0(1)

Welcome to Course Gate, your gateway to a world of knowledge and oppo...

Read more about Course Gate

Tags

Reviews