Excel 2016 (365) Intermediate Training Course | Office 365 (Udemy.com)
Go beyond the Excel 2016 basics. Excel 2016 is included with Microsoft Office 365
Created by: David Murray
Last updated July 2016
What you will learn
- 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
How it compares
Against the other 355 rated Udemy courses in Excel on CourseDuck:
- Rating4.5 out of 5higher than 39% of them
- Reviews583#214 of 356 by number of reviews
- Length1.6 hoursshorter than 88% of them
- Last updatedJuly 2016earlier than 94% of them
Course Description
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.
Instructor Details
- 4.5 Rating
583 Reviews
David Murray
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 website within Google. Over 73,000 students have purchased my Udemy training courses.
More courses by David Murray
Excel 2016 Foundation Training Course | Video Tutorial
4.7 (706 Reviews)
Provider: Udemy
Time: 1.9h
$44.99
WordPress training for 2018 step-by-step WordPress tutorial
4.4 (700 Reviews)
Provider: Udemy
Time: 4.5h
$19.99
PowerPoint 2016 Foundation Training Course | Office 365
4.5 (259 Reviews)
Provider: Udemy
Time: 2.3h
$39.99
PowerPoint 2016 Advanced Training Course | MS Office 365
4.1 (157 Reviews)
Provider: Udemy
Time: 1.7h
$10.99
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Master NEW Excel Functions in Office 365 & Office 2021+
4.8 (5,262 Reviews)
Provider: Udemy
Time: 7.1h
$15.99
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (2026)
4.8 (3,239 Reviews)
Provider: Udemy
Time: 8.6h
$119.99
Reviews
By Idris Thomas on 5/2/2020
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. :)
By Erick Daniel Vallejo Huerta on 1/28/2019
It's okay for an entry intermediate level of excel, you can enhance this course by following the entire book and practice any kind of example of your job/school. Thank you so much it refreshed me some functions I forgot.
By Karl Razul E. Casurra on 4/9/2018
it was fun and i learned a lot about excel the instructor did well in explaining it simply and effectively
By Robbie Allan Garcia on 3/30/2018
I think the instructor just did right. Because since this is for intermediate users, it is expected for listeners/learners to catch up with the instructor. In my opinion this lessons are on point and helpful. At the same time, we learners can check and review on our own to get exactly the lessons by doing it on excel to exactly understand everything. All in all this is a very helpful course to improve our skills.
By Andrew Tarus on 3/21/2018
I got to learn about ctrl+c and ctrl+v techniques in Excel workbooks. I learned also on various types of templates used in excel and how to create, modify and customize them. I learnt also on copying values in excel, doing adddition, subtraction, multiplication and other forms of arithmetic, 3D sum consolidation, sumif functions, financial functions, database functions, and name ranges. the instructor is a pro in teaching and guiding. His oral skillls are perfect
By Z Z on 3/17/2018
This is a really good introduction to useful tips and tricks with Excel. The instructor goes at a steady pace but explains things clearly, with no unnecessary chat.
By Travis Wilson on 9/27/2016
This course was very informative and resourceful. I actually like the fact that the videos were not overly extensive and time consuming. The videos were brief, but they were also very detailed and precise. Considering this, I suggest that if anyone is unclear or unsure of what was discussed in any of the videos, re-watch the video for further understanding and clarity. Overall, I think this course is a great way to sharpen anyone's excel skills.
By Cory Sharshel on 9/26/2016
I found this course to be useful. It doesn't do anything too in-depth, but gives you an overview of some typical functions and more or less points you in the right direction to learn more about the functions. The teaching style is straight-forward and unobtrusive. Would recommend for those users that are just above a beginners level and haven't worked much with functions.
By Peggy Parskey on 7/22/2016
The information was good and the instructor was very clear. He didn't go too fast so it was easy to follow along. His delivery was a bit dry, but perhaps it's just the subject matter. While I was familiar with 85% of the functionality he described, I nevertheless picked up some tips and pointers.
By Ken Walker on 7/20/2016
Loved the lectures and illustrations. The instructor was very user friendly and I just simply loved his calm demeanor and voice. Great course.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 90 / 100












