Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
11 Hour(s) 46 Minute(s)
Language
English
Taught by
R-Tutorials Training
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 from scratch or improve your skills and learn new tricks to speed up your work.
Do you want to make your work with Excel faster, more efficient and fun?
Do you want to learn more about hidden tricks that make Excel easier to use?
Are you looking for a structured way to get really good with Excel?
If your answer was YES to some of the questions, this course might be of interest to you.
When I created this course I put full emphasis on a structured and didactically sound way to gently show you how Excel 2016 and 2013 works. This course is especially suited towards a beginners and intermediate user group.
The course was shot with Excel 2016, which basically means that you can apply the knowledge from this course also to Excel 2013 (and 2010) since those versions are quite similar.
Excel is such a huge and powerful software so that learning it can be confusing. It is advisable to learn it in a structured way so that you can improvise and find proper solutions to new problems. Many users tend to only know the parts of Excel that are needed for their daily routine. Once a totally new problem arises, they are stuck. Having structured training combined with practice is key to finding solutions faster and without frustration.
In this course you will learn about the general interface, the capabilities and limitations, popular and efficient functions, useful tools, data visualization, database handling, getting help and much more. Take a look at the course content overview to see how extensive the whole product is.
At the end of this beginners and intermediate course you should be confident in using for your daily tasks. You will know
how to use Excel's functions and other tools
what the capabilities of Excel are
where to find the appropriate features
how to get help
and how to work more efficiently with Excel.
Excel is one of the key software products of today’s professional world. You will use it extensively in your work life, and of course your colleagues will be thankful if you can show them some tricks they did not know before!
Course Content
- 18 section(s)
- 122 lecture(s)
- Section 1 Introduction
- Section 2 The Basics of Excel
- Section 3 Content Formatting
- Section 4 Print
- Section 5 Basic Mathematics
- Section 6 Functions in Excel
- Section 7 Working with multiple sheets
- Section 8 Protection
- Section 9 Data Visualization in Excel
- Section 10 Illustrations in Excel
- Section 11 Database
- Section 12 Tools to Generate Data
- Section 13 New Chart Types in Excel 2016 and their Creation in Earlier Versions
- Section 14 Advanced Formulas
- Section 15 Pivot Tables
- Section 16 Pivot Charts
- Section 17 Tools of the What-if Analysis Toolbox
- Section 18 Extra lectures on Excel
What You’ll Learn
- know how to get help in Excel
- know how to use the many features of Excel 2016 or earlier
- know how to use Excel in order to solve new problems that arise
- help out your colleagues in general questions concerning Excel
- make your work faster, better and more efficient
Skills covered in this course
Reviews
-
AAyana Rainey
I thought I knew Excel but quickly realized on my new job I definitely didn't. The instructor is clear and is covering functions of Excel that I didn't know existed.
-
DDione Hargrove
Voice is hard to understand sometimes.
-
LLoren L. Ratzlaff
Much experience of Excel goes into this course, as the instructor mentions Excel 5, which I used many years ago. The instructor then knows when specific features were added and what Excel was like thirty years ago.
-
DDaniel James McKinney
Fantastic course. I learned alot. Thank you for the work it took to put these videos together.
