Topics & Behaviors

Remarks The Excel program is a very popular spreadsheet that offers the power and extreme ease of use as any professional would wish for. With its numerical, statistical, financial and general its user-definable formula capability, you can exercise your mental muscle to any extent.

Here is a taste of the topics:

Day 1:Beginner/Intermediate Level

Overview & Moving Around

- overview of the Excel Environment,

- Buttons, Formula Bar, Scroll Bars, Min-Max Icons, sizing, moving, closing worksheets;

- Worksheet Cells, Cell Addresses, Moving Around the Worksheet:

Absolute vs Relative Cell references

-           Specify, reasoning & justification of

-           Referencing using the F4 key

-           Demonstrate a good working knowledge of Absolute Cell Ref

-           Applications of, strategic usage.

Data Types & Formatting Overview of data types

- Entering & Editing Labels, Numeric Data, Dates;

-     Editing cells with the Formula bar

-     Currency, Comma, Fraction, Percent

-     Serial Date, Date and Fraction

Optional Financial/Statistical functions,

-           Present Value, Future Value, Net Present Value, IRR applications

-           Statistical functions, Standard Deviation, Variation etc

-           Overview of Serial Date and Time, VLOOKUP command

Manipulating Data

-     Copying & Moving using the Mouse, Deleting/clearing cell entries,

-     Click & Drag features vs Menu usage

- Changing Cell Width/Row heights;

-     Align Left, Center, Right buttons

Saving & retrieving/opening files, Save vs Save As commands

Other Functions & Facilities

-           Using Excels Goal Seek facility

-           Creating & Using Comments

-           Naming Cells, using in formulas

-           GoTo a named cell

-           Creating & using Styles

Creating user defined formula

-           Using the Auto-Sum Button

-           keyboard vs mouse to build a formula

-           Using Excel’s built-in formula wizard

-           Formulas and Linking cells across sheets , keyboard vs mouse

-           General formula usage

Multiple Windows Usage as follows:

-           Multiple Windows and their use

-           Invoking/Manipulating windows

-           Overview of Split Windows facility

-           Overview of Windows Arrange

Overview of Freeze Panes

Other Formatting

-           Using Cell Align, aspects of, Borders & patterns formatting;

-           Selecting/Inserting/Deleting Rows/Columns/Worksheets

-           Naming sheets

-           selecting using Ctrl & Shift keyboard keys

Printing Worksheets

-           Set Print Area vs Set Print Titles;

-           Print Preview, changing margins, columns etc

-           Page Setup, Setting Headers & Footers info, special codes etc.

-           Grid Lines, Center on page options etc. Printing

Additional Day 1 topics:

-           Setting Worksheet Fonts, Setting Worksheet Options,

-           Using Find, Checking Spelling