Excel For Professionals

Module 1 – Create worksheets and workbooks
[private]

• Creating new blank workbooks
• Creating new workbooks using templates
• Importing files
• Opening non-native files directly in Excel
• Adding worksheets to existing workbooks
• Copying and moving worksheets

[/private]
Module 2 – Navigate through worksheets and workbooks
[private]

• Searching for data within a workbook
• Inserting hyperlinks
• Changing worksheet order
• Using Go To
• Using Name Box

[/private]
Module 3 – Customize options and views for worksheets and workbooks
[private]

• Managing macro security
• Changing workbook views
• Recording simple macros
• Adding values to workbook properties
• Displaying formulas
• Freezing panes
• Assigning shortcut keys
• Splitting the window

[/private]
Module 4 – Order and group cells and ranges
[private]

• Applying conditional formatting
• Inserting sparklines
• Transposing columns and rows
• Creating named ranges
• Creating outline
• Collapsing groups of data in outlines
• Inserting subtotals

[/private]
Module 5 – Utilize cell ranges and references in formulas and functions
[private]

• Utilizing references (relative, mixed, absolute)
• Defining order of operations
• Referencing cell ranges in formulas

[/private]
Module 6 – Create a table
[private]

• Moving between tables and ranges
• Adding and removing cells within tables
• Defining titles

[/private]
Module 7 – Modify a table
[private]

• Applying styles to tables
• Banding rows and columns
• Inserting total rows
• Removing styles from tables

[/private]
Module 8 – Filter and sort a table
[private]

• Filtering records
• Sorting data on multiple columns
• Changing sort order
• Removing duplicates

[/private]
Module 9 – Summarize data with functions
[private]

• Utilizing the SUM function
• Utilizing the MIN and MAX functions
• Utilizing the COUNT function
• Utilizing the AVERAGE function

[/private]
Module 10 – Insert and format an object
[private]

• Inserting text boxes
• Inserting smartart
• Inserting images
• Adding borders to objects
• Adding styles and effects to objects
• Changing object colors
• Modifying object properties
• Positioning objects

[/private]