End User Applications Category Banner Image

Microsoft Excel - Managing Data and Large Workbooks (EXLL2)

  • Length 1 day
  • Price  NZD 435 exc GST
Course overview
View dates &
book now

Why study this course

Learn how to use Microsoft Excel to create advanced formulas and analyse data.

You'll learn advanced Excel features and tools such as applying advanced formulas to test and retrieve data, managing and manipulating lists with Sorting and Subtotals, and presenting data in graphical formats with Trendlines.

Request Course Information


What you’ll learn

After completing this course, students will be able to:

  • Freeze panes and split a worksheet; open and arrange a new window with the current worksheet content; hide and unhide data; set print titles and page breaks to optimise print output; insert different even and odd headers; manage multiple worksheets; link worksheets by using 3-D formulas; add a Watch window; and create and manage links between workbooks

  • Apply special and custom number formats; control the display of zero values; apply and modify themes; merge and split cells; change the orientation of data in cells; transpose data; use Paste Special operations; and add a background colour and a watermark

  • Create an outline and consolidate data; create custom views to save different sets of worksheet display and print settings; create subtotals in a list; use multiple subtotal functions;

  • Define and apply cell and range names; use names in formulas; and define and apply 3-D names

  • Sort and filter data; create, format, and name a table; add rows and columns; and use structured references

  • Save and publish a worksheet as a web page; insert and edit hyperlinks; publish a worksheet; and send a worksheet as an e-mail attachment

  • Use auditing features; add comments to cells and workbooks; protect a worksheet or part of a worksheet; protect the workbook structure; share, merge, and track changes in a workbook; find and remove hidden and personal data in a workbook; and mark a workbook as final

  • Change Excel default application settings and customise the ribbon; and create and modify templates


Microsoft Partner Cloud Logo

Microsoft Apps at Lumify Work

Lumify Work is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia's and New Zealand’s first and largest Microsoft Gold Learning Solutions Partner. Join more than 5,000 students who attend our quality Microsoft courses every year.


Who is the course for?

This course is intended for those wanting to build on existing Microsoft Excel skills.


Course subjects

Managing workbooks and worksheets

  • Viewing large worksheets

  • Printing large worksheets

  • Working with multiple worksheets

  • Linking worksheets with 3-D formulas

  • Using multiple workbooks

  • Linking workbooks

Advanced formatting

  • Using special number formats

  • Working with themes

  • Other advanced formatting

  • Unit summary: Advanced formatting

  • Outlining and subtotals

  • Outlining and consolidating data

  • Creating subtotals

Cell and range names

  • Creating, using and managing names

Data structure and tables

  • Sorting and filtering data

  • Working with tables

Web and sharing features

  • Saving workbooks as Web pages

  • Using hyperlinks

  • Sharing workbooks

Documenting and auditing

  • Auditing features

  • Comments in cells and workbooks

  • Protection

  • Workgroup collaboration

Templates and settings

  • Changing application settings

  • Working with templates


Prerequisites

To maximise your success in this course, it is recommended that you have completed Microsoft Excel - The Essentials or possess equivalent knowledge and skills.


Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.


Request Course Information

Personalise your schedule with Lumify USchedule

Interested in a course that we have not yet scheduled? Get in touch, and ask for your preferred date and time. We can work together to make it happen.