Financial data using Advanced Excel

Financial data using Advanced Excel

Course contents:

SECURITY AND PROOFING

PROTECTING EXCEL FILES

• Specifying a password for opening & saving a workbook
•  Removing a Workbook Password

WORKSHEET PROTECTION

• Protecting & UN-Protecting Worksheets
• Protecting Cells

WORKING WITH DIGITAL SIGNATURES

• Using Digital Signatures

Removing a digital signature from a file

USING DATA VALIDATION

• Setting data validation
• Creating the Input Message
•  Displaying an Input Message

USING TEXT TO SPEECH

•  Reading back a group of cells
• Using Speak On Enter
• Turning off Speak On Enter

DOCUMENTATION

•  Working with Comments
• Adding a Comment
• Displaying a Comment

ANALYZING DATA

GOAL SEEK

• Using Goal Seek
• Applying Goal Seek

DATA TABLES

• Using Data Tables
• Creating a one-variable Data Table
• Creating a two-variable Data Table

SCENARIO MANAGER

• Using Scenario Manager
• Adding & Showing a Scenario
• SOLVER

TEMPLATE SAND STYLES

WORKING WITH TEMPLATES

•   Using & Creating Templates

 Applying Templates

WORKING WITH STYLES

• Using & Applying Styles
•  Editing & Deleting a Style

COLLABORATION AND CONSOLIDATION

SHARING WORKBOOKS

• Customizing Workbook Sharing Options
•  Comparing and Merging Shared Workbooks

SENDING WORKBOOKS

• Sending Workbooks for Review
• Routing a Workbook to the next recipient

CONSOLIDATION

• Consolidating data over several Worksheets
•  Consolidating selected rows and columns from several Worksheets

IMPORTING DATA

IMPORTING DATA FROM EXTERNAL SOURCES

• Using Database Terminology
•  Importing Data into Excel

IMPORTING TEXT FILES

• Importing text files into Excel
• Importing text using the Text Import Wizard

QUERYING DATA FROM THE WEB

•   Accessing the New Web Query dialog box
• Creating & Saving a new Web Query

REFRESHING DATA

• Refreshing external data without losing the formatting
•  Refreshing external data automatically

MACRO SAND CUSTOM CONTROLS

WORKING WITH MACROS

• Using  & Recording a Macro
•  Assigning a shortcut key to your Macro

RUNNING MACROS

•  Running a Macro using the main menu
•  Running a Macro using a shortcut key

ADDING CUSTOM CONTROLS

• Creating a new Button
•  Renaming & Formatting a Button
•  Linking an existing Macro to a Button

CUSTOMIZING EXCEL 2010

CONFIGURING EXCEL 2010 OPTIONS

• Customizing Excel Options
• Customizing Chart Options

CUSTOMIZING THE EXCEL ENVIRONMENT

• Displaying Toolbar using the Customize dialog box
•  Creating a Custom Toolbar 

WHO SHOULD ATTEND?

• Anyone using the Microsoft Office system to work on financial data in excels.