Course for People with Knowledge of Basic Excel and Computer

Topics Covered

? Data Management in Excel ? Data types in Excel ? Page Layout Tab o Page Setup o Arrange o Sheet Options ? Conditional Formatting ? Formulas Tab o Introduction to Formulas o Arithmetic Operators o Logical Operators o Concatenation Operator o Linking worksheets o Relative, absolute, and mixed referencing o Auto sum ? Functions Text Functions : Left, Right, Mid Len , Search,Find , Substitute Building Complex functions using Text Functions Math’s and Trigonometric Function : Sumif, Sumifs Data analysis using sumif and sumifs functions Logical Function : If ,AND ,OR, NOT , IfError ? Building Complex functions using logical Functions ? Statistical Functions – Average, AverageIf, Count, CountA, CountBlank, countIF ? Data analysis using statistical funcs ? Lookup and References functions Vlookup ? Column Searching of data in a particular column and retriving the data from a range on either side of search column. ? Data analysis using lookup functions Date and Time Functions Datediff ? Resolving all the issues with dates ? Creating Named Ranges for faster navigation and using name in formulas • Evaluating the formulas • Insert Tab • Pivot Tables • Analysing the data’s using Pivot Tables • Hierarchical reports using pivot Tables • Applying Calculated column in Pivot Tables • Customizing Pivot Tables. ? Charts • Creating Charts • Adding a Chart • Creating a Custom Chart • Chart Location ? Inserting Tables ? Inserting Object ? Inserting Hyperlinks ? Data Tab • Importing the data from other applications ? View Tab • Workbook views • Window • Macros • Macro Editing ? o Creating Reports using Macros.

Who should attend

People with Knowledge of Basic Excel and Computer .

Pre-requisites

Knowledge of Basic Excel and Computer .

What you need to bring

Nothing

Key Takeaways

Practical knowledge Work Materials and notes placement Assistance