Microsoft Excel 365 Level 1

Microsoft Excel 365 Level 1

Overview

Work with selection techniques
Manipulate cells and cell content within Excel
Work with Excel worksheets
Format and align cells to enhance the appearance of your workbook
Create basic Excel formulas and functions
Proof and print workbooks

Duration

1 Day

Target Audience

Delegates 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 should have an understanding of any of the following operating systems: Windows 98/NT/2000/ME/XP/VISTA/7/8/10/11

Topics

Getting started with Excel

Starting Excel using Microsoft Windows
Selecting the Blank Workbook template
The Excel cell referencing system
Entering numbers and text
Default text and number alignment
Summing a column of numbers
Entering a date
Worksheets and Workbooks
Saving a workbook to your hard disk
Saving a workbook using a different file type
Closing a workbook
Creating a new workbook
Opening a workbook
Switching between workbooks
Getting help within Excel

Excel Selection techniques

Why are selection techniques important?
Selecting a cell
Selecting a range of connecting cells
Selecting a range of non - connecting cells
Selecting the entire worksheet
Selecting a row
Selecting a range of connecting rows
Selecting a range of non – connecting rows
Selecting a column
Selecting a range of connecting columns
Selecting a range of non - connecting columns
Recommended techniques when creating or editing lists
Inserting rows into a worksheet
Inserting columns into a worksheet
Deleting rows within a worksheet
Deleting columns within a worksheet
Modifying column widths
Modifying column widths using 'drag and drop'
Automatically resizing the column width to fit contents
Modifying row heights

Manipulating cells and cell content within Excel

Copying a cell or range contents within a workbook
Deleting cell contents
Moving the contents of a cell or range within a workbook
Editing cell contents
Undo and Redo
Copying data between worksheets
Moving data between worksheets
Copying or moving data between different workbooks
AutoFill
Sorting a cell range
Searching and replacing data

Excel Worksheets

Renaming a worksheet
Recommended techniques with naming worksheets
Deleting a worksheet
Copying a worksheet within a workbook
Moving a worksheet within a workbook
Copying or moving worksheets between workbooks

Font formatting within Excel

Font formatting options
Font type
Font size
Bold, italic, underline formatting
Cell border formatting
Formatting the background colour
Formatting the font colour
Alignment formatting within Excel
Alignment options
Horizontally aligning contents in a cell range
Centring a title over a cell range
Cell orientation
Text wrapping within a cell
Aligning cell contents vertically
Format Painter

Number formatting within Excel

Number formatting
Decimal point display
Applying and removing comma style formatting (to indicate thousands)
Currency symbol
Date styles
Percentages

Freezing row and column titles within Excel

Freezing row and column titles

Excel Formulas

Creating formulas
The easy way to create formulas
Copying formulas
Operators
Using operators in formulas
Formula error messages
Relative cell referencing within formulas
Absolute cell referencing within formulas

Excel Functions

What are functions?
Common functions
Sum function
Average function
Max function
Min function

Proofing and Printing

Spell checking
Previewing a worksheet
Selecting individual worksheets or the entire workbook
Scaling your worksheet to fit a page(s)
Displaying gridlines when printing
Printing titles on every page
Printing row and column headings
Margins

 

Course Details

Course Ref:

MSE365L1

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