Beginning, Intermediate, Advanced Excel
for Business (Modules 1-8) |
|
Module: Introduction
Key Module Topics:
- Copyright and support information
- Mouse terminology
- Digital manual and example organization
- Where to find the Excel examples
Module 1:
Excel Basics for Business Professionals
Key Module Topics:
- Introduction to Microsoft Excel, VBA, DLL’s and business graphical user
interfaces
- Excel program interface review including how to use Excel on-line help
- How to open and close workbooks
- How to save workbooks
- How to use toolbars and the Ribbon
- How to arrange workbook windows
- How to create a new workbook
Module 2:
Excel and the Business Professional
Key Module Topics:
- Discusses how Excel can be used in the business process in the areas of
analysis, information integration, VBA program development, dashboard
development, rapid analysis, team integration and data processing.
Module 3:
Business Analysis Methods on the Worksheet
Key Module Topics:
- Worksheet/cell command and control fundamentals
- Business formula construction and editing techniques on the worksheet
- How to name cells and ranges and use them in business formulas
- How to design business input and output ranges on the worksheet
- How to use Logical, Lookup, Reference and Information functions to
create "smart" business worksheets
- How to create array formulas that summarize data
- How to use the conditional formatting and data validation features in
Excel to create interactive business applications on the worksheet
- How to track business data using the conditional formatting feature
- How to protect worksheets and workbooks
- How to create business forms on the worksheet
- How to format worksheets (i.e. color cells, change the font...etc)
- How to use Excel's drawing tools and import pictures
- How to design data and management task tracking applications in Excel
using the conditional formatting feature
- How to analyze sort and filter data using Excel's Sort, Auto Filter and
Advanced Filter tools
- How to create an outline a worksheet
- How to create Pivot Tables on the worksheet
- How to import text files into Excel
- How to construct ActiveX and Form controls on the worksheet
- How to create graphics that display worksheet cell values
- How to use OLE and DDE to link with other applications in Excel
- How to build worksheet outlines
Module 4:
Creating Business Charts and Reports in Excel
Key Module Topics:
- Business chart construction using Chart Wizard
- Business chart editing and formatting techniques
- Curve fitting in Excel
- Data visualization in Excel
- Business report generation strategies in Excel
Module 5:
Accessing Data Bases from Microsoft Excel Using MS Query
Key Module Topics:
- Overview of relational databases
- Overview of ODBC and MS Query
- How to use MS Query to access a database
- How return data to the Excel worksheet from MS Query
- How to dynamically link data on a worksheet to a database
Module 6: Problem Optimization in Excel Using
Solver
Key Module Topics:
- Overview of problem optimization
- How to layout an optimization problem in Excel
- Command and control worksheet overview
- How to drive multiple workbooks using Solver
- How to use Solver in Microsoft Excel
Module 7: Linking Teams Together in Excel
Key Module Topics:
- Overview of external
references
- How to link Excel workbooks
- How to manage Excel workbook links
- How to
distribute linked Excel workbooks
- How to share Excel workbooks
Module 8: Advanced Excel Formulas
Key Module Topics:
- How to extract start and end points of data
- How use the IF function
- How to summarize data using advanced logic
- How to parse text
- How to determine specific items from lists
|
