Course details

How to work with large worksheets and advanced formatting techniques. How to create outlines and subtotals. Sort and filter data. Create and format tables. Audit worksheets for errors, protect work-sheets, share and merge and track changes in a workbook.

Course Outline

1 - 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

2 - Advanced formatting

  • Using special number formats
  • Working with themes
  • Other advanced formatting

3 - Outlining and subtotals

  • Outlining and consolidating data
  • Creating subtotals

4 - Cell and range names

  • Creating and using names
  • Managing names

5 - Data structure and tables

  • Sorting and filtering data
  • Working with tables

6 - Web and sharing features

  • Saving workbooks as Web pages
  • Using hyperlinks
  • Sharing workbooks

7 - Documenting and auditing

  • Auditing features
  • Comments in cells and workbooks
  • Protection
  • Workgroup collaboration

8 - Application settings and templates

  • Application settings
  • Working with templates

Target Audience: This course is for students to gain a farther understanding of Excel 2013.

Updated on 08 November, 2015

About New Horizons Ireland

With a very convenient location next to Jervis street in Dublin 1, we offer a wide range of IT and business skills courses and we can also send our instructors to your location.

We are 100% Irish owned, but we are also part of the largest independent IT Training Provider, New Horizons Computer Learning Centres who deliver more courses than any other IT training company.

Because we're local, we understand the needs of business and individuals in our community. Whether you choose to take classes in person or online, you're always welcome to call or stop by.

See all New Horizons Ireland courses
Are you from New Horizons Ireland ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Office starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or