Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel 2016 (365) Intermediate Training Course | Office 365
Rating: 4.5 out of 5(583 ratings)
18,951 students

Excel 2016 (365) Intermediate Training Course | Office 365

Go beyond the Excel 2016 basics. Excel 2016 is included with Microsoft Office 365
Created byDavid Murray
Last updated 7/2016
English
English [Auto],

What you'll 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

Course content

19 sections • 19 lectures • 1h 38m total length

  • Introduction2:07

    Develop intermediate Excel skills by mastering functions and formulas, named ranges, range formatting, and templates, building on the foundation course for small businesses and office environments.

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 this course is for:

  • This Intermediate Excel tutorial is designed for people with some previous Excel experience and wish to learn more about using this powerful spreadsheet program.

Report abuse