MICROSOFT excel Microsoft Excel

  • You will be able to build in the basic knowledge and skills to manipulate large workbooks, use functions, manage data and develop templates to increase productivity and practise the applications. Pivot Tables and Pivot Charts, Summarising data, Using Sorting and fi ltering techniques including advanced filtering, Database Functions, Lookup functions and much more

Excel Introduction

Learning Outcomes:Course Outline Excel Introduction (1 day)

  • Navigate around Microsoft Excel
  • Create a new workbook
  • Open and navigate within workbooks and worksheets
  • Understand and work with ranges in a worksheet
  • Understand, create and work with formulas and functions used to perform calculations
  • Copy and paste data in Excel
  • Understand and use formula cell referencing to create more complex formulas
  • Use font formatting techniques to greatly enhance the look of a worksheet
  • Align the contents of cells in a number of ways
  • Format rows and columns in a worksheet
  • Understand and use the number formatting features in Excel
  • Print workbook data
  • Create effective charts in Microsoft Excel

Excel Intermediate

Learning Outcomes: Course Outline: Excel Intermediate (1 day)

  • Use filling techniques
  • Use a range of techniques to work with worksheets
  • Apply a variety of page setup techniques
  • Apply borders to cells and ranges in a worksheet
  • Use the dozen or so most popular and common worksheet functions
  • Create more complex formulas and functions
  • Use a variety of financial functions
  • Use the date and time functions to perform calculations
  • Create and use defined names in a workbook
  • Apply a range of number formatting techniques to worksheet cells
  • Apply conditional formatting to ranges in a worksheet
  • Use goal seeking to determine the values required to reach a desired result
  • Understand and use Excel's Quick Analysis tools
  • Work with tables in Microsoft Excel
  • Understand and create simple Pivot Tables
  • Use a range of elements and features to enhance charts
  • Select and change the format of objects in a chart

Excel Advanced

Learning Outcomes: Course Outline: Excel Advanced (1 day)

  • Use a range of lookup and reference functions
  • Modify Excel options
  • Customise the formatting of charts in Excel
  • Create and use labels and names in a workbook
  • Protect data in worksheets and workbooks
  • Create summaries in your spreadsheets using subtotals
  • Use data linking to create more efficient workbooks
  • Use the Data Consolidation feature to combine data from several workbooks into one
  • Understand and create simple PivotTable reports
  • Construct and operate PivotTables using some of the more advanced techniques
  • Create and edit a PivotChart
  • Use goal seeking to determine the values required to reach a desired result
  • Group cells and use outlines to manipulate the worksheetUse Solver to solve more complex and intricate problems
  • Create recorded macros in Excel
  • Use the macro recorder to create a variety of macros

"The beautiful thing about learning is that nobody can take it away from you"

For the ultimate tips and tricks in Microsoft and Adobe Courses - Register below to receive keyboard shortcuts