Excel 2016 (365) Intermediate Training Course | Office 365
4.3 (372 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
18,365 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 (365) Intermediate Training Course | Office 365 to your Wishlist.

Add to Wishlist

Excel 2016 (365) Intermediate Training Course | Office 365

Go beyond the Excel 2016 basics. Excel 2016 is included with Microsoft Office 365
4.3 (372 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
18,365 students enrolled
Created by Mr David Murray
Last updated 7/2016
English
Current price: $10 Original price: $50 Discount: 80% off
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
Requirements
  • You will need a PC with Microsoft Windows and Excel 2016 installed on it
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.

 

 

Who is the target audience?
  • This Intermediate Excel tutorial is designed for people with some previous Excel experience and wish to learn more about using this powerful spreadsheet program.
Curriculum For This Course
Expand All 19 Lectures Collapse All 19 Lectures 01:38:00
+
Introduction
1 Lecture 02:07
+
FREE 233-page e-Book, plus sample files
1 Lecture 00:19
Download a 233-page e-Book edition of this course, plus sample files
00:19
+
Excel 2016 Setup & Printing Issues
1 Lecture 07:37
+
Functions and Formulars
1 Lecture 09:10
+
Time and Date Functions
1 Lecture 04:19
Excel 2016 Time and Date Functions
04:19
+
Math Functions
1 Lecture 04:21
Math Functions
04:21
+
Logical Functions
1 Lecture 07:07
Logical Functions
07:07
+
SUMIF Functions
1 Lecture 02:25
SUMIF Functions
02:25
+
Stats Functions
1 Lecture 05:31
Stats Functions
05:31
+
Excel 2016 Text Functions
1 Lecture 06:37
Text Functions
06:37
9 More Sections
About the Instructor
Mr David Murray
4.5 Average rating
1,176 Reviews
41,259 Students
9 Courses
20 years SEO Experience | 25 Years MS Office Experience

David Murray | An SEO Guru 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.  I have the most watched YouTube SEO TUTORIAL video.  I have been presenting Microsoft Office training at all levels since 1990 from beginner to expert level.