Description:

*Prerequisite: Must have either previously taken Excel (Basic) Training course or show competency of topics taught in Excel (Basic) Training course.

In the Advanced EXCEL course you will learn:

Working with LIST (flat database of date in EXCEL)
What is structured list
Format as a Table-new list capabilities in 2007 (review)
Sort a list using several techniques
Add subtotals to worksheets without writing any formulas
Use the AutoFilter to display only the records that meet one’s criteria
Examine the new filtering options for Dates and Numbers
Create Pivot tables and Pivot charts to summarize a data list
Protect a workbook by enabling a password and locking cells to prevent unauthorized changes
Create Column, Bar & Pie charts (2-D/3-D)
Format charts with themes and styles
Change locations-on worksheet/on chart sheet
Large Spreadsheet
Hide/unhide columns, rows & sheets
Freeze panes & print titles (review)
Multiple worksheets
Grouping worksheets for moving, copying or printing
Use 3-D formulas to add up through sheets to a summary sheet
Links to perform calculations on data from multiple worksheets and /or workbooks
Additional functions to have in your “bag of skills” for the workplace
Naming ranges for functions
IF statements
VLOOKUP function
DATEDIFF function
PMT & FV functions
CONCATENATE, LEFT, RIGHT & MIDDLE functions

*You must register via Eventbrite!