Excel is a powerful spreadsheet program that allows for construction of data in tables. Our Excel training courses concentrate on use of formulas, production of graphs and pivot tables, database management and statistical analysis.  We have Excel training courses available in three Melbourne locations: North Melbourne, Frankston and Brighton.

Duration: 7 Hours

  • Save dialog box
  • Smart tags
  • Adjusting Column Widths/Row Heights
  • Print dialog box/Print Preview
  • Emailing files
  • Formulas
  • Viewing techniques
  • Comments
  • Selecting ranges of cells
  • Moving and copying data
  • Creating a Series
  • Multiple Windows
  • Formatting a Spreadsheet
  • Inserting and deleting columns/rows
  • Inserting Page breaks
  • Basic charts

Duration: 7 Hours

  • Revision of Introductory Features
  • Advanced Charts
  • Absolute Cell References
  • Functions in formulas
  • Editing Tools
  • Custom Fill Series
  • Templates
  • Multiple Worksheets
  • Named Ranges
  • Sorting
  • Databases
  • Subtotals
  • Conditional formatting
  • Error Messages Appendix

Duration: 10.5 Hours

  • Revision of Intermediate Features
  • Advanced Functions in formulas e.g. IF and Vlookup
  • Saving a Workbook as a Web Page
  • Routing, Tracking Changes and Sharing Workbooks
  • Hyperlinks
  • Protecting Workbooks
  • Importing and Converting Text to Columns
  • Consolidating Data
  • Pivot Tables
  • Linking Workbooks
  • Data Validation
  • Recording Basic Macros

Analyse & Manipulate Data using Excel

Duration: 7 Hours

  • How to sort and filter within Excel Tables.  Created Subtotalled Filtered Lists and Custom Filters
  • Import and Exporting Data
  • Manipulate Data using Text to Columns
  • Using Grouping to create a hierarchical data structure and to show only totals
  • Learn to manipulate and display large amounts of data using Pivot Tables and Pivot Charts
  • Scenario Manager and Scenario reports
  • Using Goal Seeker
  • Create customised views of the worksheet
  • Learn how to use Data Validation to restrict the type of data entered into a cell and use an input message to instruct and inform users
  • Create drop down lists using Data Validation
  • Discussion on the use of the Excel Add In PowerPivot and MS Access to create relational data sets and reporting

 

Shortcuts, Formulas & Functions

Duration: 3.5 Hours

  • Shortcuts
  • Formulas – Constructing a Formula and using Ranges & Brackets
  • BODMAS Principles
  • How to use the Insert Function
  • Using Functions in Formulas – Order of Operations & Statistical Functions
  • Data & Time Functions

 

Duration: 3.5 Hours

  • Import data from mulitple sources
  • Create linked data
  • Create relationships between data from different sources
  • Rename columns and create calculated columns
  • Create hierarchies
  • Create PivotTables and PivotCharts
  • Add Slicers
  • Create a meausre and KPI
  • Create perspectives

 

Macros – Visual Basic

Duration: 17.5 Hours

  • Recording Macros
  • Recorder Workshop
  • User Defined Functions
  • Using the VBA Editor
  • Understanding VBA
  • Procedures
  • Variables
  • Using Excel Objects
  • Programming Techniques
  • Custom Forms
  • Custom Menus
  • Automatic Startup

Check Schedule
Book Now