WISDOMBYDATA
  • BLOG
    • Blog Guide
    • Blog History
  • EXCEL
    • Functions & Formulas
    • VBA & Macros
    • VLOOKUP
    • Pivot Tables
    • Conditional Formatting
    • Tricks & Shortcuts
  • BI
    • SAP BOBJ/BW
    • Tableau
  • SQL
  • ABOUT
    • About WBD
    • About Me

MS Excel

Applying a Formula to Many Rows in Excel
Ascertaining the folder path using a Macro
Assigning security rights to specific cells within a MS Excel worksheet   
Calculating Seniority of Active Employees Using MS Excel
Copy a data set from one range into a different range/tab
Counting the Number of Unique Values Displayed after Applying a Filter in MS Excel
Counting unique values in Excel
​
Cracking Passwords on Protected MS Excel Tabs!
Creating a Gantt chart using Conditional Formatting in MS Excel
​Creating Conditional SUM, MAX, and MIN formulas using Arrays​ 

Creating Timestamps in MS Excel Using Keyboard Shortcut
Delete content of cells which cells have a specific background color
Delete unwanted rows using Vlookup in MS Excel
Deleting all Rows which Contain a Certain Value Within Any Field of the Row
Deleting Blank Cells in MS Excel - Exclusively Using Your Keyboard!

Finding ranges that don’t have blank values in MS Excel
Getting the maximum values in one column based on unique values in another column
Highlight alternate data groupings in MS Excel

​Highlight alternate data groupings in MS Excel – Blank Cells Filtered
Highlight alternating grouping of ​data in Excel - taking into account blanks (method#2)
Highlight only a part of the text within a cell in MS Excel
Highlight the rows whenever cell values change in a data set​
How to add the Developer toolbar to the ribbon​    
How to capture the name of a MS Excel worksheet tab in any given cell  
How to check if a cell matches specific text in MS Excel
How to convert a data column into a comma-delimited list in MS Excel
How to count the number of records that match multiple criteria 
How to create line breaks (or carriage returns) in MS Excel  
How to create a dynamic VLOOKUP in MS EXCEL
How to Email only one (of many) tabs/worksheets directly through MS Excel 
How to export all MS Excel tabs
How to find cells that contain all of many words
How to highlight non present values using conditional formatting
​

Responsive & Interactive

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.

Cleaner Graphics

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.

Wider Scope

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.

Tablet Ready

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.

See Some Examples

Picture
Picture
Picture
View More
Powered by Create your own unique website with customizable templates.
  • BLOG
    • Blog Guide
    • Blog History
  • EXCEL
    • Functions & Formulas
    • VBA & Macros
    • VLOOKUP
    • Pivot Tables
    • Conditional Formatting
    • Tricks & Shortcuts
  • BI
    • SAP BOBJ/BW
    • Tableau
  • SQL
  • ABOUT
    • About WBD
    • About Me