Making Your Life Easier

Shortcuts, Toolbars and Menus

Tuning Excel interface
Paste Special and Transposition

Styles
Selecting cells with "Go To Special"

Dealing with Data

Utilizing cell's and range's Names

Formula, Workbook and Worksheet protection

File encryption

Track changes and revisions

Workbook sharing

Formula auditing

Managing templates (charts, worksheets and workbooks)

Data Analysis

Utilizing Logic in Excel
Logic Functions

Lookup Functions

Advanced functions

Scenarios
Reverting formula with Goal Seek
Resolving optimization problems with Solver
Charts

Utilizing Databases, Ranges and Lists

Data consolidation

Grouping and Outline

Data sorting (more than three columns)

Advanced Filter
Database functions
Subtotals
Pivot Tables

Data Exchange

Importing text file

Getting Data from a database through ODBC

OLE (embedding and linking)

Getting data from a web page (Web Queries)
Exporting spreadsheet and pivot table as a HTML page

Publicising Workbooks, Worksheet and pivot table as a Web Page

Work Automation

Creating custom formats

Data validation
Recording and editing macros

Visual Basic for Applications

Creating user functions

Executing code on special events

Creating applications and forms