Excel Training Program
May, 2010
|
Excel Committee Chair -Steven Singh
Learning Excel is a must in today's business world and especially if you are an accounting and finance professional. As you go
through the series week after week, you will notice a significant change in your ability to utilize these skills at work. The
sessions cover advanced formatting techniques, working with templates and workbooks, using advanced functions, working with lists,
using Excel's analysis tools, managing and auditing worksheets, and many other advanced features. Attending the chapter sponsored
excel programs provides you with the skill set to perform your jobs more effectively and efficiently. In this course, you will
use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics, formulas and macros.
You will apply visual elements and advanced formulas to a worksheet to display data in various formats.
|
The Domain Hotel
1085 East El Camino Real, Sunnyvale, CA 94087
Phone:408.247.0800
May 8th, May 15th, May 22nd
(Three Saturdays of May 2010)
Registration:8:15 AM
Training Sessions: 8:30 AM - 4:00 PM
|
COST & REGISTRATION
"A Member is specifically, chapter member of IMA Peninsula Palo Alto Association
and not of any other chapter of IMA or other association members."
"To affiliate with the IMA Peninsula Chapter, send an email to hcandella@imanet.org"
Early Bird Registration (Until March 31st, 2010)
Member-$300; Non-Member- $350
Regular Registraion (April 1st through April 15, 2010)
Member-$350; Non-Member- $400
*Online Registration closes on April 15, 2010
*Seats not guaranteed for walk-in registration
*All walk-ins pay $500 at the door, please bring cash or check
|
|
|
|
|
|
Session Details |
Instructors |
Lesson 1: Preparing an Excel Workbook: Creating worksheet, saving editing, printing, closing and exiting workbook, Using automatic
entering features, such as auto complete, auto correct and auto fill, Inserting formulas, sum buttons to add and average numbers,
fill handle to copy, Selecting cells using mouse, keyboard, data within the cells, Formatting with predesigned styles, Cell and
Table styles
Lesson 2: Inserting Formulas in a Worksheet: Writing formula’s with mathematical operations, Inserting formula’s with functions
(statistical and financial functions),Writing formula’s with date, time functions, and IF logic function, using absolute and mixed
cell reference in a formula
Lesson 3: Formatting an Excel Worksheet: Changing column width, row height, inserting and deleting cells, rows and columns,
clearing data in the cells, applying formatting, font, mini-toolbar, alignment, previewing a worksheet-zoom setting, applying
theme, formatting using group buttons and format cells dialogue box, alignment and indent of data, adding borders, fill and
shading cells, formatting with format painter, repeating last action
Lesson 4: Enhancing a Excel Worksheet: Formatting a worksheet, margins, centering, orientation, size, inserting and removing page
breaks, printing row and column titles, scaling data, inserting background picture, various print options, inserting headers,
footers, Spell checking, undo and redo, finding and replacing data, sorting and filtering
Lesson 5: Moving Data within and between Workbooks: Creating workbook with multiple worksheets, cutting, copying, pasting selected
cell. Paste option button and office clipboard, managing worksheets, hiding, formatting, splitting windows, Freezing, Working
with ranges, windows, multiple workbooks, Linking data between worksheets, 3-D reference
Lesson 6: Maintaining Excel Work Books: Maintaining workbooks, creating and renaming a folder, Copying and moving sheets to
other workbooks, Saving workbook in different format, version, Formatting with cell styles, working with comments
|
Instructor-Sudha Chadalavada, SEC Reporting Consultant
Sudha, a CPA and a CFE,
has over fifteen years of experience in accounting and finance and currently specializes in SEC Reporting. Sudha is the
current VP Professional Education of the IMA Palo Alto Chapter and also has served on the board's several non-profit educational
associations including IMA Silicon Valley Chapter, IIA San Jose Chapter, and ISACA Silicon Valley Chapter aswell as a club and
district officer of Toastmasters' International. Sudha's vision for the chapter is to establish sustainable longstanding
initiatives following the traditions of the Peninsula Palo Alto chapter.
Instructor- Patricia Huang, Treasurer,IMA-PPA
Patricia has been a member of the IMA, Peninsula-Palo Alto Chapter since 1994.
This is the first year Patricia is joining the board of the Palo Alto Chapter of IMA. She had a broad experience in various
aspects of corporate financial management. She worked in high tech industry, such as Raychem and Applied Materials; she also
worked in regional banks industry, such as Silicon Valley Bank. She has extensive experience in accounting and financial
analysis; good exposure of SOX compliance, process reengineering and ERP implementation. Patricia lives in Cupertino and enjoys
hiking and traveling. Patricia has an MBA, Santa Clara University and BS in Economics, Soo Chow University.
Instructor- Steven Sing, Director-at-large, IMA-PPA
Steven is currently responsible for the Excel Program at the Peninsula Palo Alto Chapter of IMA. Steven Singh has been member of
IMA since 2002. He has over 15 years of accounting and finance experience. Steven's wide range of industry experience includes
manufacturing, software, defense and non-profit organizations. Steven currently consults through RHI along with his other
clientele located in the bay area and San Diego of California. Steven is originally comes from Fiji Islands,
where his career started as an auditor. Steven has a B.A. in Management and Economics from The University of the South Pacific;
an M.A. in Accounting from The University of the New South Wales, Sydney Australia. Steven is a member of Australian Society
of CPA and California Society of CPA. Steven is a CMA, and holds active Australian CPA license along with active California
State CPA license.
Â
|
|
|
