Extracting Records with Advanced Filter. Using Formulas In Criteria
Sorting by Top to Bottom / Left to Right. Creating / Deleting Custom List. Sort by using Custom List...
Hyper linking data, within sheet / workbook. Linking & Updating links between workbooks & application
Using SUMPRODUCT Functions. Using FLOOR/ CEILING/ MROUND/ MOD/ QUOTIENT Functions
Creating Subtotals/Nested Subtotals. SUBTOTALS Formula
Creating/Working with an Automatic/Manual Outline. Grouping / Ungrouping
Consolidating Data with Identical/Different Layout
Displaying/Removing Dependent & Precedent Arrows. Evaluate Formula – Step IN / Step Out
Creating Custom Views. Displaying Custom Views, Deleting Custom Views
Sharing Workbooks & Tracking Changes. Protecting sheets / workbooks / Files
Importing Data from Database/ Text Files/ Web. Exporting Data, Changing External Data Range. Feel free to connect with our experts: Get a free Quote
