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

Create a dynamic pie chart



CONCATENATE MULTIPLE CELLS AND REMOVE UNWANTED COMMAS BETWEEN VALUES (INCLUDING CELLS WITH SPACE SEPARATED VALUES)



Concatenate cells and remove unwanted commas between values in MS Excel​



How to get rid of #N/A in VLOOKUP



Capture the name of a file using a formula



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



Counting unique values in Excel



How to summarize monthly data into quarters in MS Excel



How to use the OFFSET formula in Excel



Inserting duplicate rows (from multiple columns) based on numeric column values ​



Delete unwanted rows using Vlookup



Two way lookup with VLOOKUP



How to convert a column into a comma-delimited list in MS Excel



How to capture the name of a MS Excel worksheet tab in any given cell



Creating Conditional SUM, MAX, and MIN formulas using Arrays



How to find cells that contain all of many words



How to check if a cell matches specific text in MS Excel



How to count the number of records that match multiple criteria ​



Using Conditional If Statemens in MS Excel



Using the ISTEXT Function of Excel in String Concatenations



Counting the Number of Unique Values Displayed after Applying a Filter in MS Excel



Replacing Duplicate Values in a Column with Blank Cells in MS Excel



Calculating Seniority of Active Employees Using MS Excel


Picture

Picture
Picture
Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture
Picture

Picture

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