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.

 

 

Introduction

1
Introduction

FREE 233-page e-Book, plus sample files

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

Excel 2016 Setup & Printing Issues

1
Excel 2016 Setup

Functions and Formulars

1
Excel 2016 Function and Formulars

Time and Date Functions

1
Excel 2016 Time and Date Functions

Math Functions

1
Math Functions

Logical Functions

1
Logical Functions

SUMIF Functions

1
SUMIF Functions

Stats Functions

1
Stats Functions

Excel 2016 Text Functions

1
Text Functions

Excel 2016 Financial Functions

1
Finance Functions

Excel 2016 Lookup Functions

1
Hlookup and Vlookup

Database Functions

1
Database Functions

Excel 2016 Named Ranges

1
Named Ranges

Excel 2016 Cell Formatting

1
Range Formatting

Manipulating Worksheets within Excel 2016

1
Worksheet Manipulation

Excel 2016 Templates

1
Templates

Paste Special Options within Excel 2016

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
fd1fbd0922933c9b4328e1fa4d28a5dc
30-Day Money-Back Guarantee

Includes

2 hours on-demand video
1 article
Full lifetime access
Access on mobile and TV
Certificate of Completion