Excel - Advanced

Unlock your true potential as an office professional with our comprehensive and practical introductory course on Microsoft Excel. Designed specifically for adults and office workers, this course equips you with the essential skills and knowledge to excel in your daily tasks, boost productivity, and gain a competitive edge in the workplace.

Whether you are a beginner or have limited experience with Excel, our expert instructors will guide you step-by-step through the fundamental concepts and functionalities of this powerful spreadsheet software. By the end of the course, you will have mastered the core techniques and gained confidence in using Excel to streamline data analysis, reporting, and decision-making processes.

Don't let Excel intimidate you. Join our introductory Microsoft Excel course today and unlock a world of possibilities. Take control of your spreadsheets, boost your productivity, and become an indispensable asset in any office environment. Book now and take the first step towards Excel mastery!


RECAP OF INTERMEDIATE

  • Linking spreadsheets
  • Consolidating data and using workbooks
  • Database and sorting
  • Word and graphic tools
  • Absolute referencing

STYLES AND ANNOTATIONS

  • Using Autoformat
  • Create, edit, use and merge styles

USING FORMULAS

  • If, date and lookup tables
  • Tables

CHARTS

  • Creating 2D and 3D charts
  • Graphing isolated rows
  • Creating overlay charts

REPORTS AND VIEWS

  • Using Report and View Managers

DATABASE

  • Sorting and querying
  • Database statistical functions
  • Using the Pivot table wizard

MACROS

  • Macro recording and running
  • Automatic executing macros
  • Assign macros to buttons and graphic objects

MISCELLANEOUS CONTENT AND TIPS

  • Exchanging data with other documents
  • Setting up a workspace
  • Specifying startup directory
  • Create and use document templates
  • Protecting data

Pricing:

On your premises

3 hours 10am - 1pm or 1:30 - 4:30
4 or more people - $225 + GST (per person)
3 people - $250 + GST (per person)
1 or 2 people - $275 + GST (per person)

No charge is made for supply and setting up of 6 computers, transport, accommodation or meals when booking a minimum of 3 consecutive days (6 three hour sessions or 9 two hour sessions). Flights, Meals and accomdation charge will apply if booking less than 3 consecutive days.

Venue:

On your premises or we can arrange a venue to suit.

Upcoming Sessions


Dates don't suit? Call or E-mail.