|
Provided by: NobleProg - IT training courses Excel Advanced with VBA Training CourseExcel |
 |
|
|
||||||||||||||||||||
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
Utilzing 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 spresheet 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 Applicationss
Creating user functions
Executing code on special events
Creating applications and forms
