3.79 out of 5
3.79
492 reviews on Udemy

# Excel 2016 (365) Intermediate Training Course | Office 365

Go beyond the Excel 2016 basics. Excel 2016 is included with Microsoft Office 365
Instructor:
David Murray
18,828 students enrolled
English [Auto-generated]
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

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.

1
Introduction

### FREE 233-page e-Book, plus sample files

1
Download a 233-page e-Book edition of this course, plus sample files

1
Excel 2016 Setup

### Functions and Formulars

1
Excel 2016 Function and Formulars

### Time and Date Functions

1
Excel 2016 Time and Date Functions

1
Math Functions

### Logical Functions

1
Logical Functions

1
SUMIF Functions

1
Stats Functions

1
Text Functions

### Excel 2016 Financial Functions

1
Finance Functions

### Excel 2016 Lookup Functions

1
Hlookup and Vlookup

### Database Functions

1
Database Functions

1
Named Ranges

1
Range Formatting

### Manipulating Worksheets within Excel 2016

1
Worksheet Manipulation

1
Templates

1
Paste Special

### Rank Function

1
Rank Function
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.8
3.8 out of 5
492 Ratings

#### Detailed Rating

 Stars 5 154 Stars 4 189 Stars 3 102 Stars 2 30 Stars 1 17
30-Day Money-Back Guarantee

#### Includes

2 hours on-demand video
1 article