admin@designated.org.uk - 0151 653 3338

Microsoft Courses

Microsoft Excel: Level Two Microsoft

2017/05/12
2017/05/12
  • 0

    day

  • :
  • 0

    hour

  • :
  • 0

    min

  • :
  • 0

    sec


Going beyond basic Excel. This course covers concepts and exercises involving charts. Using Excel as a database. If statements and many more functions.

Overview

This training course aims to give foundation level users of Excel knowledge of commands and functions which will make them more proficient in spreadsheet design and development.

Viewing Worksheets

  • Customise view options
  • Display and customise toolbars
  • Hide workbooks and worksheets
  • Freeze panes
  • Group worksheets

More Formatting Techniques

  • Using styles
  • Conditional formatting
  • The format painter
  • Hiding and displaying cells

More Formulas and Functions

  • Using the function wizard
  • Financial functions
  • Correcting formulas
  • Using the error checker
  • Using the auditing toolbar
  • Using the watch window

Absolute Cell References

  • Entering an absolute column and row reference into a formula
  • Entering mixed cell references into a formula

Using Logical Functions

  • Using the IF function
  • Nesting IF functions

Database and List Management

  • Using Excel as a database
  • Sorting a database
  • Using Autofilters and advanced filters
  • Using data forms

Charts

  • Creating charts using the wizard
  • Formatting charts

Linking Worksheets within a Workbook

  • Renaming worksheets
  • Inserting and deleting worksheets
  • Creating formulas to link worksheets

Drawing and Picture Objects

  • Creating drawing objects
  • Using drawing toolbar to control objects 

Excel and Other Applications

  • Copying data from another application
  • Using hyperlinks