Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 14 Minute(s)
Language
English
Taught by
SONIC Performance Support - E-Learning Experts
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Learn useful features and latest tricks for Excel 2010/2013 to create better workbooks in less time.
You do not know Excel if you do not master these topics.
If you think you can master Excel, this course is for you. After 25+ years of experience working with spreadsheets, we know what Excel worksheets lack or are often missing. We have compiled the ultimate course, with all the features and functions you need to become a master of Excel.
You do not have to go through all 18 hours of training in our Beginner, Intermediate and Advanced Excel courses. We have captured the essence for you in this course.
Course Content
- 10 section(s)
- 41 lecture(s)
- Section 1 Work FASTER and Avoid ERRORS at the Same Time
- Section 2 Customize the Ribbon and Quick Access Toolbar
- Section 3 Make your Workbooks Look Great
- Section 4 Sharing Workbooks is Much More Than Sending an Email with an Attachment
- Section 5 Useful Functions We do Not See Often Enough!
- Section 6 Manage Large and Multiple Workbooks Without Getting Lost
- Section 7 The Advantages of Organizing Data in a Table. Yes, a Table Within Excel!
- Section 8 Remove Duplicates
- Section 9 Pivot Tables - Analyze your Data Like Never Before!
- Section 10 Automatically Update Data From the Web Like Exchange Rates, Stocks and More
What You’ll Learn
- Unused or often overlooked Excel features that will save you time, make less errors, securly share workbooks with other and will make your wookbooks look great.
- Work faster with Excel
- Make less calculation errors
- Make your Excel workbooks look better
- Share Workbooks more securely
- Analyse data more efficiently with Pivot Tables and Slicers
- Establish connections to data sources on the web.
- Learn useful functions beyond SUM
- Manage Large Workbooks and Multiple Workbooks and don't get lost
- Remove duplicates in a list.
- Manage lists in a table.
Skills covered in this course
Reviews
-
MManfred Camero Garcia
Excelente curso, tips muy puntuales, útiles y entendibles para ser aplicados inmediatamente. Los temas que se tocan son poco mencionados en la mayoría de los Cursos. Recomendado.
-
RRichard Branscombe
Helpful and useful with very clear explanations. I felt some of the more simple concepts early in the course were explained in exhaustive detail but others like pivot charts were only given an introduction - there is clearly a lot more to cover on some subjects. But overall it was a good course that I enjoyed.
-
DDennis J Regan
Great pace and explanations are very clear.
-
IIan
Some files are not the same as in lecture. Quizzed with questions before doing the lecture. Something's I considered was in the basic course
