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; 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
• 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, and
add rows and columns; 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
• 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
• Change Excel default application settings and customise the
ribbon; create and modify templates.
To ensure your success in this course, it is recommended that
you have completed Microsoft Excel - The
Essentials or possess equivalent knowledge.