Microsoft Excel: from ZERO to ADVANCED Course

Description

[Updated 2022]

Microsoft Excel 2019: from ZERO to ADVANCED

Working knowledge of Excel is vital for most office-based professionals today, and stronger Excel skills can open the door to jobs, promotions, and leadership opportunities.

For example, if basic SUM and AVERAGE functions can help businesses calculate and analyse data better and quicker, think about how much more efficient advanced functions can make you. And to make you efficient and better at work, our Microsoft Excel experts have designed this Microsoft Excel course.

Curriculum

• Microsoft Excel 2019 New Features
• Getting Started with Microsoft Office Excel
• Performing Calculations
• Modifying a Worksheet
• Formatting a Worksheet
• Printing Workbooks
• Managing Workbooks
• Working with Functions
• Working with Lists
• Analyzing Data
• Visualizing Data with Charts
• Using PivotTables and PivotCharts
• Working with Multiple Worksheets and Workbooks
• Using Lookup Functions and Formula Auditing
• Sharing and Protecting Workbooks
• Automating Workbook Functionality
• Creating Sparklines and Mapping Data
• Forecasting Data
• Excel Templates

Learning Outcomes

By the end of this course, you'll learn the following skills:

• Perform various calculations and get results in seconds rather than doing them manually
• Gain the ability to modify and format worksheets and learn to print and manage workbooks
• Learn various functions and how to work with lists
• Become an expert on data analysis 2019 features
• Learn to use visual elements like charts and data visualisation to see and understand trends, outliers, and patterns in data
• How to present data using PivotTables and PivotCharts as well as working with multiple worksheets and workbooks
• Using lookup functions and formula auditing, sharing and protecting workbooks, automating workbook functionality
• How to forecast data, create sparklines and mapping, usage of various Microsoft Excel templates

Key Features of the Microsoft Excel Course :

• Accredited by CPD
• Instant e-certificate and hard copy dispatch by next working day
• Fully online, interactive course with audio voiceover
• Developed by qualified professionals in the field
• Self-paced learning and laptop, tablet, smartphone-friendly
• 24/7 Learning Assistance
• Discounts on bulk purchases

Accreditation

All of our courses, including this course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.

Certification

Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Assessment

At the end of the course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed the course.

*** Additional Gifts ***

Free Life coaching Course

This Microsoft Excel Skills course is designed for people with a career in Accounting, Finance, Marketing, Sales, Executive, Administration, Business Management, Manager, Human Resources, Customer Service, Assistant, and Reception.

In this course, we will go in-depth into Microsoft Excel applications, which are delivered in a simple way to be understood.

CPD

Career path

Certificates