Get the Sum of Filtered Data in Excel
Hello friends!! We’ll be learning to do calculation and do aggregation on filtered data in Excel. We’ll achieve this using the SUBTOTAL() function in Excel.
Read moreTag: Machine Learning
Automated workflows using CrewMacros in Alteryx
Hello friends!! We’ll be learning to automate the Alteryx workflows using the CReW Macros in Alteryx. These quick Alteryx tip will help you run multiple workflows with single click in Alteryx.
Read moreGenerate dates between two dates in Alteryx
Hello friends!! We’ll be learning to generate dates between two dates using Alteryx. These quick Alteryx tip will help you use Generate Rows option in Alteryx.
Read moreStart with Python and Pandas – Part 2
Hello Friends! I’ll be continuing from previous article about Python and we’ll learn more about Python.
Read moreStart with Python and Pandas – Part 1
Hello Friends!! recently I started with Python again. I’ll share basic intro to python. I’m be using Jupyter notebook for the tutorial. This will require a basic understanding of programming knowledge to understand the flow. Syntax are bit similar to R so if you know it will be easy to catch.
Read moreAlteryx Tips & Tricks – Part 2
Hello friends!! This is part 2 of the Alteryx Tips and Tricks. You can Check out the Alteryx tips and tricks- Part I here. Received a very good response for the Alteryx Tips and Tricks part I. We’ll be learning few more quick and very helpful Alteryx tips & tricks.
Read moreJammu & Kashmir in India map in Tableau
Hello friends!! We’ll be learning how to show Jammu & Kashmir (J&K) in India map in Tableau. This is super quick way to show Jammu & Kashmir in India map.
Read moreSave Each Worksheet as a Separate PDF in VBA
Hello friends!! We’ll be learning quick way to convert Excel sheets to PDF in VBA . These quick VBA tip will help you to save lot of time.
Read more