• About WordPress
    • WordPress.org
    • Documentation
    • Support
    • Feedback
  • Log In
  • Register
Skip to content
Get your free eBook "How to choose correct chart type?"
Get your free eBook "How to choose correct chart type?"
DataWitzz

DataWitzz

Tutorials on MS Excel, Power BI, SQL, Python

  • Home
  • All Courses
DataWitzz
DataWitzz

Tutorials on MS Excel, Power BI, SQL, Python

Search
Get your free eBook "How to choose correct chart type?"
Get your free eBook "How to choose correct chart type?"

What is Data: 2 types of data and their general understanding

Leave a Comment / Excel, Six Sigma and Statistics

What is Data Data are basically units of information that are usually numeric. Technically it is a set of values …

What is Data: 2 types of data and their general understanding Read More »

Excel Slicer: How to use Excel slicer to filter data

2 Comments / Excel Formula, Excel

Excel Slicer: How to use Excel slicer to filter data What Slicer in excel Slicers are floating buttons in excel …

Excel Slicer: How to use Excel slicer to filter data Read More »

What is Spark lines in Excel and How to use it in 3 different ways?

Leave a Comment / Excel Formula

What is Spark lines in Excel Sparklines also known as micro charts adds rich visualization to tabular data without taking …

What is Spark lines in Excel and How to use it in 3 different ways? Read More »

How to use XLOOKUP in excel: Understanding it with 3 examples

Leave a Comment / Excel Formula

How to use XLOOKUP in excel XLOOKUP is used to search a range or an array and then return a …

How to use XLOOKUP in excel: Understanding it with 3 examples Read More »

How to add Developer Tab in excel | adding developer tab in excel

1 Comment / Excel Formula, Excel

How to add Developer Tab in excel The Developer Tab in excel is a very important tab to accomplish many …

How to add Developer Tab in excel | adding developer tab in excel Read More »

VBA in Excel: What is VBA, How to use

Leave a Comment / Excel, Excel Formula, VBA

VBA in Excel VBA stands for Visual Basic Application. It is an event-driven programming language used by Microsoft for its …

VBA in Excel: What is VBA, How to use Read More »

What is Power Query in excel: how to use Power Query in excel

1 Comment / Excel Formula, Power Query and Power BI

What is Power Query in excel Power Query in excel helps in connecting multiple sources and sizes of data. It …

What is Power Query in excel: how to use Power Query in excel Read More »

How to use INDIRECT function in Excel

Leave a Comment / Excel, Excel Formula, Function, Uncategorized

How to use INDIRECT function in Excel In this blog post, we will try to understand about INDIRECT function of …

How to use INDIRECT function in Excel Read More »

How to Get Stock Market Data Into Excel

Leave a Comment / Stock Market

How to Get Stock Market Data Into Excel In this blog post, we will learn how to get stock market …

How to Get Stock Market Data Into Excel Read More »

How to use MATCH function in Excel

2 Comments / Excel, Excel Formula, Function, Uncategorized

How to use MATCH function in Excel In this blog, we will be discussing MATCH function in excel. MATCH function …

How to use MATCH function in Excel Read More »

Posts navigation
← Previous Page 1 … 7 8 9 Next Page →
Get new posts by email

Recent Courses

Categories

  • Chart and Visualization
  • Excel
  • Excel Formula
  • Function
  • Power Query and Power BI
  • Six Sigma and Statistics
  • SQL
  • Stock Market
  • Uncategorized
  • VBA
  • Home
  • All Courses

Copyright © 2023 DataWitzz | Powered by DataWitzz