Index to how to… providing a range of solutions page 3

< Back to Search results

 Category: [Excel]  Demo Available 

Index to how to… providing a range of solutions page 3


1 How to sort by phone #, phone # in different columns, phone # with extensions
2 How to convert mmmm d yyyy to dd/mm/yyyy
3 How to work with COUNTIF with multiple criteria
4 How to average both positive and negative numbers
5 How to find the maximum date within date range
6 How to sum from two tables based on From-To date criteria
7 How to calculate straight line depreciation
8 How to calculate diminishing balance depreciation
9 How to use IF and VLOOKUP formulas together
10 How to use Index/Countif based on multiple factors including range
11 How to calculate productivity in time basis
12 How to use SUMIF to extract attendance details from a register
13 How to convert decimals to text fraction
14 How to calculate hours based on individual daily rates
15 How to count the frequency of a specific number on a specific day
16 How to determine the top sales person
17 How to use RANK formula with multiple criteria
18 How to calculate the total commission value from a sliding scale
19 How to add a trend arrow to a dashboard
20 How to use SUMIF using Variable Columns
21 How to set up an efficient spreadsheet design
22 Excel/VBA Golden Rules. These should NOT be optional
23 How to match positive and negative values within subgroups
24 How to drag every Nth column, with varying starting column by date
25 How to add lines to a chart
26 How to for Microsoft Office applications
27 How to maintain the VLOOKUP font format
28 How to convert data in one column to two columns
29 How to print range excluding blank rows with formulas
30 How to indent based on corresponding cell value
31 How to vertically centre text in userform label
32 How to use a dropdown or text option
33 How to use a VBA code to change cells colours based on date in other cells
34 How to Delete/Hide every nth row
35 How to clear Userform
36 How to count non blanks 5 years from the last non blank date
37 How to disable edit/delete comments
38 How to print hidden sheets without viewing the sheet being printed
39 How to use IF THEN to select a specific case (region)
40 How to use VBA code to check interactions in the formula bar
41 How to use SUMPRODUCT with dates
42 How to sum up values in a date range
43 How to remove excel password protection
44 How to combine rows with the same ID# but different columns
45 How to merge multiple excel files into one file in separate sheets with source file name
46 How to copy last used row to next empty row in another worksheet


See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets


Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.


Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft


stars (0 Reviews)