IT Training‎ > ‎

Excel Introduction (level 1)

Excel 2010 or 2013 Introduction

Who is the course for?

Are you self-taught with gaps in your learning, this course is ideal for you. Or perhaps you need Excel for your work but don't know what it's all about? 

 

I would thoroughly recommend this course for anyone who needs to know Excel better. You will be surprised how much you didn't know when you attend this course. You will find that your efficiency levels improve tremendously, by saving time on those painstaking tasks of cutting and pasting, scrolling down your page, creating headings on each page, and using Autofill to its full potential. 

What the course will cover:

 

An overview of the screen, navigation and basic spreadsheet concepts

  • Familiarity with the Ribbons and what they can do
  • Customising the Quick Access Toolbar
  • Opening and Saving your workbook 
  • Understanding workbooks, worksheets, rows, columns, and cell references
  • Various selection techniques of cells
  • The mouse pointer and its many functions
  • Using navigation techniques around a worksheet, and workbook
  • Entering & deleting data
  • Moving and copying data
  • Paste Special - Pasting values, formats, pictures, links and transposing cells
  • Inserting, deleting, changing width and hiding, Rows and Columns
  • Using the Fill handle including Autofill and Custom Fill
  • Format Painter

 Formulae

  • Creating and editing basic formulas such as Addition, Subtraction, Multiplication, and Division
  • Gain understanding and using Formulae rules (making sense of BODMAS)
  • Using Excel Functions such as: Sum, Average, Max, Min and Counting cells 
  • Changing text by using text functions 
  • Understanding and using absolutes $ format numbers 

 Formatting and Proofing

  • Formatting Cells 
    • Number, Font, Time, Date, Currency, 
    • Alignment, Merging cells, Borders and Fills
  • Conditional formatting (changing cells automatically based on a given criteria)
  • Copying and Clearing Formats 

Printing and Page Setup

  • Page Orientation portrait to landscape 
  • Adding Headers and Footers 
  • Setting a print area for a worksheet
  • Shrinking fonts to fit on a page
  • Adjusting page breaks using Page Break Preview

Basic List Management

  • Sorting by one column or more
  • Filtering your rows to show only certain criteria 
  • Using a Format As a Table feature including formulas

Charts & graphs 

  • Creating a Chart: pie, column or bar
  • Editing a Chart: adding labels, a table, colours (or pictures), changing location, or even changing your mind to another chart 

Working with multiple worksheets

  • Freezing panes to see your top row when you scroll down
  • Selecting and inputting data over multiple sheets at one time
  • Creating a Summary with formulas over multiple worksheets
  • Changing, copying and moving worksheet tabs

 

Only £130 for the day including workbook and lunch. Free parking available. Contact 
 
 for bookings or more information. 
Comments