Accounts Executive

Module 1

Advance Excel

Working with Multiple Worksheets, Protecting Worksheets with Password, VLOOKUP / HLOOKUP, Performing Magic with Array Formulas Charting Techniques, Pivot Tables, Cell Styles and Conditional Formatting Paste Special , Data Validation, ARRAY FORMULAS : Introducing Arrays, Advance Filter and Advance Sorting Techniques, MACROS , Goal Seek Scenario , Short cut Keys. Advance Formulas And Mathematical & Logical Functions(Sumif, Countif, Dcount, Dcounta, Averageif, Averageifs, and, or, not, iferror, Daverage, Dget, Dsum, Match. Index, Concatenate ,Trim, Find, Search, Rounddown, Roundup,Countblank etc.)

Download Our Advance Excel PDF