Excel Basic Training

Training

In London

£ 595 VAT inc.

Description

  • Type

    Training

  • Level

    Intermediate

  • Location

    London

  • Duration

    1 Day

  • Start date

    Different dates available

This course is designed for beginners and covers: Excel basics; working with data; editing a worksheet; editing text; formatting a worksheet; page setup and printing; working with pages; formulas and functions; and modifying workbooks.

Facilities

Location

Start date

London
See map
United House, North Road, Islington, N7 9DP

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Printing
  • MS Excel
  • Cell styles
  • Worksheets
  • Workbook
  • Footers
  • Cell borders
  • Shading
  • Page Breaks
  • Average Functions

Course programme

Excel Basics

Creating An Excel Workbook, Examining The Excel Environment, Opening An Existing Workbook, Navigating A Worksheet, Creating A New Workbook, Saving A New Workbook, Moving Between Workbooks, Setting Excel Options, Switching Between Views, Using Help, Closing A Workbook And Exiting ExceOn Your Own

Working With Data

Entering Text And Numbers, Entering Simple Formulas, Choosing Formula Cell References Manually, Using Autosum, Changing & Deleting Data, Using Undo/Redo, Using Find And Replace, Using The Go To Command, Spell Checking Your Worksheet, Inserting Symbols

Editing A Worksheet

Working With Ranges, Copying And Pasting Data, Using The Office Clipboard, Cutting And Pasting Data, Copying And Moving Cells Using Drag-And-Drop, Changing Column Width, Changing Row Height, Inserting And Removing Rows And Columns, Copying Data And Formulas With Autofill, Filling In Cells Using Flash Fill

Formatting A Worksheet

Formatting Text, Using The Format Cells Dialog Box, Formatting Values, Using The Format Painter Button, Alignment And Text Wrapping, Merging Cells And Centering Text, Adding Cell Borders, Applying Colors And Shading To Cells, Applying Cell Styles, Hiding And Unhiding Rows And Columns, Freezing And Unfreezing Rows And Columns, Inserting And Removing Page Breaks

Page Setup And Printing

Adjusting Margins, Setting Page Orientation, Setting Paper Size, Defining A Print Area, Printing Worksheet Titles, Forcing A Worksheet To Fit, Inserting Headers And Footers, Printing A Worksheet

Formulas And Functions

Relative References, Absolute References, Mixed References, Copying Formulas, Min, Max, Count And Average Functions, The Insert Function Button

Modifying Workbooks

Adding And Deleting Worksheets, Copying Worksheets, Renaming Worksheets, Repositioning Worksheets, Grouping Worksheets, Changing Worksheet Tab Colors, Using 3-D Formulas & References

Excel Basic Training

£ 595 VAT inc.