Microsoft Excel Stage 1 for Business Professionals

Course Overview

Microsoft Excel Stage 1 for Business Professionals from Mass Training

Day 1


 

What is Excel?

·          Understand the functions of spreadsheet application

·          Recognise the different elements of the Excel screen

 

Creating a Workbook

·          Create a new workbook

·          Move around the worksheet using the mouse and keyboard

·          Select cells using the mouse and the keyboard

·          Use zoom to view a worksheet at different magnification

·          Use Undo and Redo

 

Entering and Editing Data

·          Enter text, values, and dates in cells

·          Edit cell contents

·          Print a single copy of a worksheet

 

Creating a Formula

·          Understand what a formula is and how to create simple calculations

·          Use AutoSum

·          Enter a formula by typing or by using the Formula bar

·          Enter a range within a formula using the mouse

·          Use relative and absolute cell references

 

Moving and Copying Data

·          Use the AutoFill tool

·          Create a custom list

·          Use Drag-and-Drop to move or copy cell contents

·          Move, copy, and paste data using the Windows Clipboard

 

Editing a Formula

·          Create a formula using functions

·          Revise a formula

·          Use Insert Function

·          Use basic arithmetic functions (SUM, AVERAGE, COUNT, MIN, MAX)

·          Recognise and resolve common error messages

·          Interpret spreadsheet data

 

Formatting Cell Values

·          Apply value formats (currency, percent, date, comma)

·          Adjust the decimal place

·          Change the currency symbol

·          Apply other formats (accounting, time, text, general)

 

Formatting Cell Contents

·          Apply font styles (typeface, size, colour, enhancements)

·          Modify the alignment and orientation of cell contents

·          Merge and unmerge cells (to centre headings across columns)

·          Indent text in a cell

·          Use the Format Painter to copy cell formats

·          Clear cell contents or formats

 

Structuring a Worksheet

·          Modify the size of columns and rows

·          Insert and delete rows and columns

·          Insert and delete selected cells

 

Page Layout

·          Change paper size and orientation

·          Set page margins and alignment

·          Scale print output to fit a defined number of pages

·          Print column and row titles and set other options

·          View a worksheet in Print Preview

·          Change margin and column widths in Print Preview

·          Insert and remove a page break

·          Set up headers and footers

·          Add fields in headers and footers (page number, date/time, file information)

 

Printing Worksheets and Workbooks

·          Print a worksheet

·          Print a workbook (all sheets in book)

·          Display formulas in worksheet cells

·          Print a range of cells

·          Set, print, and clear a print area

·          Print a group of worksheets

·          Print to a file

 

Creating a Chart

·          Use the Chart Wizard to create different chart types

·          Reposition, resize, and delete a chart

·          Change the chart type

·          Preview and print a chart

·          Move and copy a chart

 

Day 2

 

Data Lists

· Create a data list

· Use a form to view, sort, and enter records

· Perform single and multi-level sorts

· Filter a list using AutoFilter

 

Borders and Shading

· Apply cell borders and shading

· Apply AutoFormat

 

Viewing a Large Worksheet

· Go To a specific cell or named range

· Split a worksheet into different viewing panes

· Freeze and unfreeze panes as worksheet titles

· View a workbook in multiple windows

· Hide and unhide rows and columns

· Hide and unhide worksheets and workbooks

 

Managing Worksheets

· Switch between worksheets

· Enter and edit data on multiple worksheets

· Copy data between worksheets and workbooks

· Insert and delete worksheets

· Move and copy a worksheet

· Rename a worksheet

· Change the colour of a worksheet tab

 

Logical and Nested Functions

· Use the IF, AND, OR, and NOT functions in formulas

· Use nested functions

 

Financial Functions

· Use financial functions (PMT, FV, PV, NPV, RATE, IRR, SLN)

 

String, Date, and Time Functions

· Join strings (CONCATENATE, &)

· Extract text from a string (LEFT, RIGHT, MID)

· Change case (UPPER, LOWER, PROPER)

· Find and replace text within a string (FIND, REPLACE, SUBSTITUTE, TRIM, CLEAN, LEN)

· Convert between text and number values (TEXT, VALUE, FIXED, DOLLAR)

· Insert specific characters from the Windows character set (CHAR, CODE)

· Enter the date and time using functions (TODAY, NOW, DATE, TIME)

· Return selected parts of a date or time value (YEAR, MONTH, DAY, HOUR, MINUTE, SECOND)

· Perform calculations using date/time values

· Use other date functions (NETWORKDAYS, WEEKDAYS, WEEKNUM)

 

Statistical Functions

· Use counting functions

· Use averaging functions

· Use other statistical functions (MIN, MAX, MEDIAN, MODE, STDEV)

 

Creating and Applying Styles

· Define a style

· Apply a style to worksheet cells

· Remove a style from cells

· Modify an existing style

· Copy styles between workbooks

 

Proofing Tools

· Use AutoCorrect

· Use Find and Replace

· Check spelling across the worksheet

 

Adding Comments

· Add a comment

· Review, edit, and delete comments

· Print comments

 

Formatting a Chart

· Add, remove, move, resize, and modify chart elements (titles, labels, legend, axes, gridlines)

· Format chart elements (borders, patterns, font, values)

· Format chart axes (number format, text, line width)

· Format data series (scale, shading, spacing, width)

 

Inserting Pictures and Clip Art

· Understand Object Linking and Embedding

· Insert a Clip Art object

· Insert a picture from a file

· Insert a Print Screen graphic

· Insert an image from a scanner or digital camerav

· Modify a picture using the Picture toolbar

· Crop a picture

 

Distributing a Workbook

· Save a workbook as a plain text file

· Save a workbook for a different application

· Save a workbook as a template

 

Creating a Hyperlink

· Create a hyperlink to a file, place in a document, or place on the web

· Create an email hyperlink

· Use or modify a hyperlink in a worksheet

 

Research Tools

· Translate text to and from different languages

· Spell check text in different languages

· Research words and phrases using web reference tools

 

 

If booking for more than one delegate, please contact us on 01189 778562 for discounted prices.