Microsoft Excel 2016/19
Intermediate Functions

Course Overview

This course is a continuation from the Excel Introduction course. This course will increase your productivity and show you how to use many advanced functions in Excel 2016/19.

Course InformationRelated Training

Duration: One-Day Course
Platform: Windows Only
Fee: Call for information

We recommend one to eight people for this course.

Course Content Download PDF (57kb)

Create a Well Designed Worksheet

Set up an efficient worksheet in Excel.
Apply the new themes and styles to help you create a unified design within your workbook.
Create an absolute cell reference.
Use range names to quickly go to a range or use the range name in a formula.
Identify trends in your data using the improved conditional formatting features.
Insert cell comments to make your work easier to review.

Advanced Functions

Review the SUM, AVERAGE, MAX, MIN and COUNT functions.
Learn how to use the IF, COUNTIF, SUMIF, ROUND, TODAY and VLOOKUP functions.
Nest multiple functions such as the SUM function with the IF function.
Use the Flash Fill feature to eliminate repetitive tasks such as to extract the first name from a list rather than using a formula.

Application Overview: Microsoft Excel 2016/19

Microsoft Excel is a powerful tool to create and format spreadsheets and to analyze, evaluate, and calculate data. You can use advanced features to manage, track, and chart critical business data to create rich data visualization, PivotTable views, and professional-looking charts. You can compile your company’s data into Microsoft Office Excel by retyping or by copying and pasting. But importing is most effective when you're working with large amounts of data that would be time-consuming to enter manually or too large to copy and paste. In addition, if you import your data, Excel can automatically update your reports and summaries whenever the original source database is updated. Your data is always current.

Users: IT, Database, Engineering, Finance, Legal, Marketing and Admin Professionals as well as anyone who needs create and edit spreedsheets that can be searched, sorted, analysed, reported, updated and shared with other users.

Microsoft Excel 2016/19 Intermediate Functions