We provide MS Excel Basic training

Topics Covered

Module - 1: Introduction of Spreadsheet Exploring the Excel Window Ribbon User Interface Menus, Toolbar and other familiar Tools Quick Access Toolbar Editing Label and values Undo and Redo Saving and Updating Workbooks Module - 2: Formatting a Worksheet Formatting Numbers Formatting Text Wrap Text Centre across selection Find and Replace Shading Of Cells Applying Borders Format Table Paste Special (Value, Transpose, Formula) Module - 3: Understanding Cell References and Range Name Different References in Excel Using Relative References Absolute References Mixed References Working with Range Name, Fill series Module - 4: Working with Simple Formulas and Functions Basic Functions(SUM,MAX,MIN,AVERAGE,COUNT,COUNTA,COUNTBLANK) Conditional Functions (COUNTIF,SUMIF,AVERAGEIF) Logical Functions (IF,AND,OR) VLOOKUP,HLOOKUP Module - 5: Sorting , Filtering Data ,Charting and Data Validation Simple Sort Auto Filter Custom Auto Filter Creating Simple Charts (Graphical presentation of data) Validating cell entries Module - 6: Printing Options Changing The Page Orientation – Landscape/Portrait Setting paper size Inserting Headers And Footers Changing The Margins Page setup options Printing Column Or Row Headings Module - 7: Text and Date Functions Date Functions(Day, Month, Year, Edate) Text Functions(Left, Right, Mid, Search, Find, Trim, Concatenate) Text To Column Remove Duplicates Freeze Panes/Split Module - 8: Pivot Table and Subtotal Display Subtotal Pivot table Wizard Cross Tab Report Use of Report Filter Module - 9: Self Practice

Who should attend

Financial Analyst Research Advisers Marketing Professionals HR Professionals Job Applicants Management Students

Pre-requisites

Understanding of Basic Computer skills Separate PC per trainee Projector for more than 5 trainees Installed MS Office 2007®

What you need to bring

Installed MS Office 2007®

Key Takeaways

Upon successful completion of this course, Users will be able to: Explore the Excel 2007 environment Work with an Excel worksheet by entering and selecting the data in it. You will also save the data in the worksheet Modify a worksheet Perform calculations Format a worksheet Develop a workbook Print workbook contents Generating Simple Report