Microsoft Excel 365 Level 1 ( 10/07/2024 )

MSE365L1

Overview

About the course

  • 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

Audience Profile

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.

Course Details

  • Course Ref: MSE365L1
  • Course Duration: 1 day
  • Course Dates: 10 July 2024
  • Course Price: £195+ VAT

Modules

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