Dive deeper into Excel 2016 with our friendly intermediate course. Learn functions, formulas, and more in a fun, easy way!
This intermediate course is all about diving deeper into Excel 2016. Perfect for those who have a bit of experience already and want to learn more. It's fun, it's easy, and it's all about making Excel work for you!
Go beyond the Excel 2016 basics. Excel 2016 is included with Microsoft Office 365
Microsoft Excel 2016 (365) Intermediate Training Course
Excel 2016 is included with Microsoft Office 365
This course is designed for people with some limited experience of using PowerPoint 2016. It will also suit people who has studied my Excel 2016 Foundation level course.
The course starts by looking at Microsoft Excel 2016 Setup & Printing Issues
We then start looking at Excel Functions and Formulas including Time & Date Functions, Mathematical Functions, Logical Functions, Mathematical Functions, Statistical Functions, Text Functions, Financial Functions, Lookup Functions and finally Database Functions
Next we see how to create and use Named Ranges within an Excel worksheet.
The next chapter shows you how to use Cell Formatting techniques.
Then we see the various Worksheets manipulation techniques.
Finally we look at the use of Microsoft Excel Templates and the Microsoft Excel Paste Special Options.
This is the second of three Excel 2016 training courses and builds on the materials covered in the foundation tutorials. Topics covered include Excel 2016 Functions and Formulas such as Time & Date Functions, Mathematical Functions, Logical Functions, Mathematical Functions, Statistical Functions, Text Functions, Financial Functions, Lookup Functions & Database Functions. Plus Named Ranges, Cell Formatting, Worksheet manipulation and Excel 2016 Templates
1 Lectures
1 Lectures
1 Lectures
1 Lectures
1 Lectures
1 Lectures
1 Lectures
1 Lectures
1 Lectures
1 Lectures
1 Lectures
1 Lectures
1 Lectures
1 Lectures
1 Lectures
1 Lectures
1 Lectures
1 Lectures
David Murray | An SEO (Search Engine Optimization)  training expert with over 20 years’ experience delivering training courses all over Europe from Dublin to Moscow. First website went live in April 1996 and I have never needed any salespeople or advertising, I just use organic SEO to get sales. Lean how to do SEO the right way and promote your...
Very easy to follow and understand.
The videos went too fast and weren't specific to what he was clicking so I could follow along with my own workbook.
Quick overview of some intermediate excel functionality. Filling in the various fields for the functions is totally intuitive but by the end of the course, you kinda get the hang of it.
Thorough overview, would suggest users have their own excel open and work the examples alongside the instructor.
He could have gone deeper into explanations of the functions and in what cases we would use these functions.
The Most easiest way to learn difficult stuff.
Detailed and easy to follow, thanks.
very nicely deep teaching one by one...
I only became confused a couple of times, which is a miracle. I needed to better understand the logic behind syntax, which took a while to figure out otherwise. Also, when introducing difficult new concepts, such as NPV, perhaps an explanation of that, too. :)
Your email address will not be published. Required fields are marked *
Simon G.
Some of the tables used to illustrate points were very basic, but overall i found the pace and content beneficial.