Connexion
-
Count cells with text and formula – Excel stats
-
Counting unique values in Excel – 5 effective ways
-
Create a running balance in Excel that allows you to insert, delete, and move rows
-
Create a unique list in Excel based on criteria
-
Creating user-friendly Data Validation in Excel: Displaying help out of the way
-
Custom charts in Excel: Waterfall chart
-
Data tables
-
Dependent drop down lists in Excel
-
Detecting inconsistent formulas
-
Determine the drive, folder & file existence (VBA functions)
-
Displaying decimals versus Rounding in Excel
-
Do you have to use Dim to declare variables?
-
Do you really need to merge those cells?
-
Documenting Excel projects
-
Easily recover a previously unsaved Microsoft Excel workbook
-
Errors, errors, everywhere!
-
Excel - Basics of pivot tables
-
Excel - Data Validation error checking & other useful tips
-
Excel - Protecting your worksheets and workbooks
-
Excel & genes: mutation and curation
Page 4 of 15