Course Details

Advanced Excel Training Course is conducted by us. This is a very professionally compact program designed for the students, keeping in mind the recent professional requirements. Course details are as follows:

• An Overview of the Excel 2013 Interface
• An Overview of Excel
• Using Templates and Workbooks
• Formulas and Functions in Excel
• Using Simple Formulas
• Using the auto sum Function
• Using Auto Average
• Exploring the Insert Function Feature
• Using a Function from the Insert Function
• Using CountIF
• Copying, Moving and auto fill
• Comments, Saving, Printing, and Importing Data
• Backstage View
• Printing from Backstage
• Saving a Workbook
• Using Page Setup
• Using Print Preview

ADVANCED EXCEL LEVEL 2

• An Overview of Formulas and Functions
• Common Text and Numeric Functions Revisited
• Referencing Cells, Sheets and Workbooks
• Working with Conditions
• Naming Cell Ranges and Miscellaneous Functions
• Creating Formulas that Look Up Values
• Lookup Function
• V Lookup Function
• H Lookup Function
• An Overview of Charting
• Data Sources for an Excel Chart
• Types of Charts
• Recommended Procedure to Produce a Meaningful Chart About Our First Chart
• Creating a 3-D Pie Chart
• Modifying a Pie Chart
• Exploding a Pie Slice
• Adding Additional Objects to a Chart