MS Excel is a versatile application used by professionals, business persons and students widely in their everyday tasks. This course will help you discover advanced features/ functions of Excel and make you master in using Excel.

Topics Covered

Basic Excel • Introduction to MS Excel • Using Excel 2007 & Above: Ribbons, Tabs, Groups & Quick Access toolbar • Creating Workbooks and Worksheets • Entering Data • Formatting Data • Cell Referencing o Absolute o Relative o Mixed • Basic Excel Functions o Arithmetic Operations o SUM o AVERAGE o MAX & MIN o COUNT & COUNTA • Other Features o Sorting Data o Filtering Data o Printing Worksheets o AutoFill o Format Painter • Keyboard Shortcuts Intermediate level • Cleaning Data • Vlookup & Hlookup • Logical Functions o IF o AND o OR o IFERROR • SUMIFS & COUNTIFS • LARGE & SMALL • Text Functions o RIGHT o LEFT o MID o TEXT • Creating Charts • Creating Pivot Tables • Data Validation • Using Names & Name Manager Advanced Level • Nested IFs • Array Formulae • SUMPRODUCT • Advanced lookup using VLOOKUP • Advanced lookup using INDEX & MATCH • Returning cell references from INDEX • Creating dynamic Named Ranges • Date & Time Functions o TODAY & NOW o NETWORKDAYS o DATEDIF o DATE o DAY, MONTH, YEAR • Conditional Formatting • Pivot Tables: Creating Calculated Fields & Calculated Items • Using Advanced Filter • Text to Columns • SubTotals • Protecting Worksheets & Workbooks • Sharing Workbooks

Who should attend

Students, Professionals, Managers, Anyone who uses Excel.

Pre-requisites

Nothing

What you need to bring

Nothing; Just have a version of MS Office 2007 installed in your PC/ Laptop.

Key Takeaways

Advanced MS Excel knowledge.