Microsoft Excel: from ZERO to ADVANCED
Free PDF Certificate included, Free Life coaching Course | Free Retake Exam | Lifetime Access
Training Express Ltd
Summary
- Certificate of completion - Free
- Certificate of completion - Free
- Exam(s) / assessment(s) is included in price
- Tutor is available to students
Add to basket or enquire
Overview
[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
Certificates
Certificate of completion
Digital certificate - Included
Certificate of completion
Hard copy certificate - Included
You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.
CPD
Course media
Description
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.
Career path
No matter where you are or what you do, if you are working with digital data, having Microsoft Excel skills is a must. With skills, you can explore opportunities everywhere, including—
- Administrative Assistant
- Accountants
- Retail Manager
- Cost Estimator
- Financial Analyst
- Project Manager
- Business Analyst
- Data Journalist
And much more!
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.