Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 58 Minute(s)
Language
English
Taught by
Stephen Beak
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Learn Excel 2016 and the most important and popular functions. Learn to use Excel like a pro with this Excel Course
By Completing this course, you will receive a verifiable Certificate of Completion.
This course has cut down on the fluff and empty space to keep it shorter, but still cover a wide range of topics. Designed for people starting out with Excel, it also covers some of the more complicated and important areas like Pivot Tables.
This Excel course is recorded completely using Excel 2016, the latest version of Excel offered in the Microsoft Office 2016 suite.
Some of the topics include (but not limited to)
- Creating your first workbook
- Referencing from other sheets within a book
- Quick Charts
- Quick Sorting
- Flash Fill
- Named Ranges
- Excel Sheet Management (moving, colouring, creating)
- Creating 3D maps using address data in a list
- Popular Excel Functions like SumIf, VLookUp, Left, Right, Mid, Len and more
- Power Excel functionality like nested formulas
- Using slicers to quickly sort and make spreadsheets look good
- A complete set of Pivot Table videos
I aim to add 4 new lectures every month to the course, and would love to have your feedback. So once you have signed up and completed the training, let me know what you would like to learn next!
Course Content
- 5 section(s)
- 37 lecture(s)
- Section 1 Jumping Straight In
- Section 2 Increasing Efficiency to save time in Excel
- Section 3 Using the data in your Excel 2016 spreadsheet
- Section 4 Pivot Tables - How to use them in Excel 2016 and why you should
- Section 5 More functions - General Excel 2016 Functions
What You’ll Learn
- Use Excel in a professional environment
- Create and manage complicated spreadsheets
- Manage constantly changing data
- Understand what Excel is and how it really works
- Create a 3D heat map to plot sales geographically
- Set up and manage Excel Pivot Tables
Skills covered in this course
Reviews
-
DDian Santana
Nice...
-
MMichèle Raffaele
Yes, I needed a review from the beginning so this is great.
-
SSouky Titus
Information/examples are showed in detail
-
NNeil Jenkins
Easy to understand, keeps the course interesting and relevant
