Excel Beginners

This course is part of the library from IMPROVE. No need to worry about which course is right for you….purchase the whole library for a subscription fee AND we will set it up for you, get you started and will be on hand as part of a managed service…all starting from £45 + VAT per month for 20 employees! Prices are based on the size of your organisation with access for all of them to over 50 courses on a range of IT and non-IT topics.

Description

Modules:

  • Create and Save a Workbook
  • Inserting and Deleting Rows and Columns
  • Resizing Columns and Rows
  • Moving and Copying Data
  • Changing Cell Appearance and Alignment
  • Drawing Borders
  • Using Pre-set Borders
  • Wrap Text
  • Merging Cells
  • Clearing Formats
  • Format Painter
  • Cell Styles
  • Calculations using Symbols
  • Calculations using Brackets
  • Calculations using $ Symbol
  • Using Sum Min Max and Average
  • Calculations Between Tabs
  • Sorting a List (Simple)
  • Filtering a List using Simple Tick Boxes
  • Filtering a List using Criteria
  • Creating Bar and Line Charts
  • Creating Pie Charts
  • Chart Formatting Options
  • Setting Print Areas
  • Document Scaling
  • Hiding Columns and Rows
  • Grouping Columns and Rows
  • Freeze panes
  • Keyboard Shortcuts