Excel 2016 (365) Intermediate Training Course | Office 365

Go beyond the Excel 2016 basics. Excel 2016 is included with Microsoft Office 365

4.45 (583 reviews)

Udemy

platform

English

language

Microsoft

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

Why take this course?

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.

Screenshots

Excel 2016 (365) Intermediate Training Course | Office 365 - Screenshot_01

Excel 2016 (365) Intermediate Training Course | Office 365 - Screenshot_02

Excel 2016 (365) Intermediate Training Course | Office 365 - Screenshot_03

Excel 2016 (365) Intermediate Training Course | Office 365 - Screenshot_04

Reviews

Simon

September 21, 2022

Some of the tables used to illustrate points were very basic, but overall i found the pace and content beneficial.

Tricia

May 31, 2022

The videos went too fast and weren't specific to what he was clicking so I could follow along with my own workbook.

Holly

May 15, 2017

Detailed step by step explanations are given as well as every file he's using is provided. Leaves no room for error or guessing.

Deanna

January 18, 2017

There is a lot of information. Just hoping to retain some of it. Will watch again and hopefully learn even more.

Keith

December 26, 2016

Course was informative, and well worth the Black Friday price I paid for it. For the practice files uploaded, it would be better if the task to be completed was stated in the practice spreadsheet because the task to be accomplished was not clear in many of them.

Bobby

December 18, 2016

I have learned new information so I believe an above average rating is necessary. However, I do believe the sequence could be better.

Laura233

November 7, 2016

soy mexicana , casi no hablo ingles, sin embargo hay una interacción visual tan completa que no necesitas, estar capacitado con el idioma para entender la información proporcionada

Isauro

October 26, 2016

Hace falta que expliquen el por que se redactan de tal manera las formulas, ya que que solo dicen que formula se utiliza, pero no el porque de su redacción de tal formula

Jason

October 25, 2016

A good background of intermediate functionalities of Excel. A chapter on charting may have been helpful. Instructor was both pleasant and efficient in describing concepts.

Ken

October 19, 2016

the accent makes for unclear diction. Having trouble understanding. Also very mono-tone I had trouble staying awake during the presentation.

Bobbie

October 18, 2016

This guys is a terrible teacher! He doesn't explain what the functions are doing, just quickly clicks through and shows you how to accomplish what he has done but I don't want to copy his work, I need to know how to formulate the formulas to accomplish my task! I am extremely glad I did not pay for this course. I used a coupon from dealnews.com. If you thinking of paying for this course, DON'T WASTE YOUR MONEY!

Maggie

October 13, 2016

Good job. Good speech speed. Only recommendation, snip shot the excel document you will be working in.

Martha

October 3, 2016

Even though i have been using Excel for a very long time, I learned a few simple tips that I was unaware of that will be useful to me immediately.

Karen

October 3, 2016

Great tips and bits of information. A good sampling of what's available in Excel that you might not know at first blush.

Jeff

September 28, 2016

repetitive and examples are really not useful. there are bettter courses on youtube and this is hardly an intermediate course.

Charts

Price

Rating

Enrollment distribution

Excel 2016 (365) Intermediate Training Course | Office 365 - Distribution chart