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
Welcome! Enhance your analytical skills through

​“
Wisdom by Data”.

​
With 100+ blog posts on topics such as MS Excel, Business Intelligence, SQL, Python, Interview tips, etc. you can find solutions on this blog that will make your daily tasks more effective and efficient.

All the tabs on this website are linked to the Blog. You can search for your topic of choice through the search menu.
Picture

​​
Alternatively, you could also, browse through the various category tabs (i.e. EXCEL, BI, SQL, etc.) to find the materials that you find useful. 
​

Moreover, you could visit the Blog History page to view all blog posts, categories and publication dates on a single page.
Picture


​Most Popular Blog Posts


CALCULATING SENIORITY OF ACTIVE EMPLOYEES USING MS EXCEL
CALCULATING SENIORITY OF ACTIVE EMPLOYEES USING MS EXCEL

REPLACING DUPLICATE VALUES IN A COLUMN WITH BLANK CELLS IN MS EXCEL
REPLACING DUPLICATE VALUES IN A COLUMN WITH BLANK CELLS IN MS EXCEL

HOW TO TRANSFER FOLDER NAMES WITHIN A WINDOWS FOLDER INTO MS EXCEL
HOW TO TRANSFER FOLDER NAMES WITHIN A WINDOWS FOLDER INTO MS EXCEL

HOW TO FIND CELLS THAT CONTAIN ALL OF MANY WORDS
HOW TO FIND CELLS THAT CONTAIN ALL OF MANY WORDS

HOW TO CHANGE THE COLOR OF NEGATIVE PERCENTAGE VALUES IN WEB INTELLIGENT (WEBI) REPORTS
HOW TO CHANGE THE COLOR OF NEGATIVE PERCENTAGE VALUES IN WEB INTELLIGENT (WEBI) REPORTS

CRACKING PASSWORDS ON PROTECTED MS EXCEL TABS!
CRACKING PASSWORDS ON PROTECTED MS EXCEL TABS!
HOW TO EMAIL ONLY ONE (OF MANY) TABS/WORKSHEETS DIRECTLY THROUGH MS EXCEL
HOW TO EMAIL ONLY ONE (OF MANY) TABS/WORKSHEETS DIRECTLY THROUGH MS EXCEL

HOW TO TRANSFER DATA (INCLUDING BLANKS) FROM MULTIPLE EXCEL SHEETS INTO A SINGLE REPOSITORY
HOW TO TRANSFER DATA (INCLUDING BLANKS) FROM MULTIPLE EXCEL SHEETS INTO A SINGLE REPOSITORY
USER RESPONSE FUNCTION IN WEBI
USER RESPONSE FUNCTION IN WEBI

    Subscribe

    Subscribe to my blog to stay up to date and see my latest posts!
Subscribe to My Blog
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