Cademy logoCademy Marketplace
  • 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

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

+ Add Review