Information Technology

Excel 2013 - Level 2

Instructor-Led 8 Agenda

Description

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 Overview

Course Objective

Upon successful completion of this course, students will be able to create and manage more advanced techniques with Excel 2013 by using Microsoft Office Excel 2013.

Who Should Attend

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

Managing workbooks and worksheets Lesson Id 1

Managing workbooks and worksheets

Advanced formatting Lesson Id 2

Advanced formatting

Outlining and subtotals Lesson Id 3

Outlining and subtotals

Cell and range names Lesson Id 4

Cell and range names

Data structure and tables Lesson Id 5

Data structure and tables

Web and sharing features Lesson Id 6

Web and sharing features

Documenting and auditing Lesson Id 7

Documenting and auditing

Application settings and templates Lesson Id 8

Application settings and templates

Lesson Id	Title	Description
1	Managing workbooks and worksheets	Viewing large worksheets<br />Printing large worksheets<br />Working with multiple worksheets<br />Linking worksheets with 3-D formulas<br />Using multiple workbooks<br />Linking workbooks
2	Advanced formatting	Using special number formats<br />Working with themes<br />Other advanced formatting
3	Outlining and subtotals	Outlining and consolidating data<br />Creating subtotals
4	Cell and range names	Creating and using names<br />Managing names
5	Data structure and tables	Sorting and filtering data<br />Working with tables
6	Web and sharing features	Saving workbooks as Web pages<br />Using hyperlinks<br />Sharing workbooks
7	Documenting and auditing	Auditing features<br />Comments in cells and workbooks<br />Protection<br />Workgroup collaboration
8	Application settings and templates	Application settings<br />Working with templates