Excel

Service Description

Introduction Microsoft Excel and Variance in version 2003, 2007, 2010, 2013. Use of Relative and Absolute Reference. Use of $ sign in Formula and Formula R1C1. Definition of file extension [.csv, .xls, .xla, .xlsx, .xlsb, .xlsm] Cut, Copy, Paste, Paste Special [15 + Copy Paste Technique]. Format Painter, Data Formatting. Normal, Advanced, Color, Icon, Horizontal/Vertical, Custom Sorting, Data Types. Auto, Custom, Advanced Filters. Naming Range, Screen Tip, Naming Range Function, Hyperlink [Internal, External, Web, Object]. Count World : COUNT, COUNTA, COUNTBLANK, COUNTIF 10+ Technique, COUNTIFS. SUM World : AUTOSUM, SUMIF, SUMIFS, SUMPRODUCT, SUM with Array, SUBTOTAL, AGGREGATE. Validation : Number, Decimal, List, Text Length, Time, Date Custom  etc. LOOKUP Array, LOOKUP Vector, HLOOKUP, VLOOKUP 10+ Types like, Nested VLOOKUP, Array VLOOKUP, IFERROR VLOOKUP, Wild Card VLOOKUP etc. Functions : OFFSET, INDIRECT , ADDRESS & Function Combination as per requirement. Error Identification & rectification. IF Condition, Nested IF Text to Columns, Conditional Formatting. Protection, Cell, Range, Sheet, Formula. Chart Lexicon : Normal Chart, Dynamic Chart, Pareto Chart, Pivot Chart. Pivot Table : Pivot, Chart, Grouping, Compiler, Slicer etc. Create Batch File, CSV Compiler. Picture Link (Naming range for Image). 3D Reference Sparkline Ageing & Due Date Fill Series, Step Value Split Number & Text Extract First Name, Last Name, Middle Name. Automations, Dynamic Dashboard, All Developer Form Controls Operations etc. Form Controls: Group Box, Radio Button, Scrollbar, Spin Button, Check Box etc.