Microsoft Excel 365 Level 2

Microsoft Excel 365 Level 2

Overview

Open and create templates in Microsoft Excel
Work with different worksheet views
Visualise your data with charts
Use advanced functions
Work with Excel tables
Work with structured references
Create conditional formatting

Duration

1 Day

Target Audience

Delegates will learn about some of the functions and tools that allow them to use Microsoft Excel as an analysis toolDelegates who have little or no experience of Microsoft Excel, delegates will learn the fundamentals of Excel so that they can do basic but key tasks in the application.

Prerequisites

Delegates who are familiar with Microsoft Excel and can already create basic functions.

Topics

Excel Templates

Using templates
Creating an Excel Personal template
Deleting an Excel Personal template

Excel Setup and Viewing Options

Arrange all workbooks
Zooming the view
Hiding columns
Unhiding rows / columns

Excel Charts

Chart types
Inserting charts
Changing the chart type
Adding or removing chart elements
Adding or removing data series
Formatting chart elements
Switching Rows / Columns
Deleting a chart

Excel Functions and Formulas

Functions vs formulas
Function structure
Entering Excel functions
Nested functions
3-D references

Excel Date & Time Functions

DATEVALUE function
TODAY function
NOW function
DAY function
MONTH function
YEAR function

Excel Mathematical Functions

SUMIF function
SUMIFS function
ROUND function
ROUNDUP function
ROUNDDOWN function

Excel Statistical Functions

COUNT function
COUNTA function
COUNTBLANK function
COUNTIF function
COUNTIFS function

Excel Logical Functions

IF function
IFS function
IFERROR function
LAMBDA function

Excel Lookup Functions

XLOOKUP function

Excel Table Formatting

Why use Excel tables?
Create a table
Structured references
Structured reference syntax
Constructing structured references

Excel Conditional Formatting

Conditional formatting
Highlight cells rules
Icon sets
Colour scales
Use a formula to determine which cells to format

 

 

Course Details

Course Ref:

MSE365L2

Course Duration:

1 day

Course Location:

Sunderland

Course Dates:

Please call for dates...

Course Price (Excl VAT):

Please call for prices...


Course Downloads

Send course details to a colleague

Telephone

   To book or for further information, please telephone 0191 515 3355 or e-mail us at sales@mtc-training.co.uk