About the Course
Excel Prodigy for training corporate to best suit their schedule, budget, learning style and expertise. We are Microsoft Authorized Testing Center to conduct Microsoft Office Specialist Exam (MOS Certification) in Chennai.
Unlike other conventional training centers, we offer Beginner level, Intermediate level, Advanced level and Professional level courses based on your convenience and requirements.
Our training courses will show you how to use Excel better, faster and more efficiently. You will learn how to save time, access new features and work with confidence.
Our teaching methods ensure maximum comprehension in the shortest possible time. We provide a dynamic learning environment with lots of practical hands on exercises and real world examples.
Our instructors are knowledgeable, experienced and patient computer training professionals with both industry experienced and qualified.
Topics CoveredExcel Basics
The Excel Screen • Moving About the Workbook • Simple Data Entry • Selecting Ranges • Saving Workbook Formats
Copying & Filling
Using Fill for Quick Copying • Copying Cell(s) to One/Many Cells & Worksheets
Overwriting/Editing Cell Contents • Editing Formulae/Functions • Using Undo/Redo • Search & Replace
Adjusting a Worksheet
Inserting/Deleting Cells • Inserting/Deleting/Resizing Rows/Columns
Working With Worksheets
Copying/Moving/Renaming Worksheet(s) • Inserting/Deleting/Grouping Worksheets • Hiding & Unhiding Worksheets
Formulae that Add/Subtract/Multiply/Divide • BODMAS/Formula Error Checking • The Sum Function
Formatting in Excel
Formatting Numbers/Dates/Currency • Formatting for Effect Bolding/ Italics/ Underling • Cell/Background Colours • Cell Alignment
Working with Functions
Summing Non-Contiguous Ranges •Count/ Average/Maximum/Minimum Functions
Hiding/Unhiding Columns/Rows • Freezing Panes/Splitting Windows
Paste Special to Copy Formulae/Formats/Validations • Paste Special to Add/Multiple & Transpose
Filling a Series with formatting/without formatting • Filling a weekdays • Fill data using stop value
Problems with Absolute/Relative Cell Referencing, Creating Absolute/Mixed References
Define Names & Lables
Creating/Deleting Labels/ Names • Creating/Using Names in Formulas/ Across Workbooks
Creating, Formatting Simple PivotTables • Page Field in a PivotTable • Formatting a PivotTable • Creating/Modifying a PivotChart
The VLOOKUP/HLOOKUP Functions • MATCH with VLOOKUP Functions
IF's and Nested IF Functions • Using AND/OR/NOT Functions
Using The SUMIF/COUNTIF Functions • Using The AVERAGE/COUNT/LARGER/SMALLER Functions
Using The TODAY • NOW & DATE Functions • Using The DATEDIF/ NETWORKDAYS/ EOMONTH Functions.
Using The MID/ SEARCH/ LEFT/ RIGHT Functions • Using The TRIM/ CLEAN/ UPPER/ LOWER Functions.
Input Messages / Error Alerts/ Drop-Down Lists • Conditional Formatting
Chart Data Techniques
The Chart Wizard • Chart Types • Adding Title/Legends/Lables • Printing Charts • Adding Data to a Chart • Formatting/Renaming/Deleting Data Series • Changing the Order of Data Series
Hyper / Data Linking
Hyper linking data, within sheet / workbook • Linking & Updating links between workbooks & application
Filters & Data Sorting
Applying & Using AutoFilter • Creating a Custom AutoFilter • Sorting On More Than One Column
Simple Printing/Previewing • Page Setup & Orientation • Creating and Formatting Page Headers/Footers • Custom views
Who should attendCorporate Professionals
Pre-requisitesExcellent Keyboard Skills
Attitude to Learn
Good Logical Skills
What you need to bringKeen attention to class
Key TakeawaysOutstanding knowledge in excel