Saurabh Jain
-
Posts
1,726 -
Joined
-
Last visited
-
Days Won
61
Content Type
Profiles
Forums
Gallery
Downloads
Blogs
Events
Online Conference
The Excel dictionary
Power Query M function dictionary
Everything posted by Saurabh Jain
-
-
Download used code in this tutorial
-
In 2019 or office 365 https://support.microsoft.com/en-us/office/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c
-
Yes you can ...Start with tutorial 1 In this post we should always ask about Xlook up we have a question section for general questions
-
I cannot see the formula and secondly this question not related to the tutorial pl ask your question https://bi-analytics.org/forum/50-your-questions/ Share the objective and formula you have applied so any 1 can chip in to help you
-
Available to office 365 subscribers https://bi-analytics.org/topic/65-welcome-xlookup-the-successor-of-the-most-ever-powerful-vlookup/?do=findComment&comment=141
-
Overview of table in Excel Download Practice file https://bi-analytics.org/files/file/30-tutorial-18-tables-in-excel/ Make sure you sign in on the site and joined the club
-
-
Report link https://datastudio.google.com/s/gKoXJ-9rsec Report embedded
-
Top 10 Trends in Data and Analytics for 2020 Trend 1: Smarter, faster, more responsible AI. ... Trend 2: Decline of the dashboard. ... Trend 3: Decision intelligence. ... Trend 4: X analytics. ... Trend 5: Augmented data management. ... Trend 6: Cloud is a given. ... Trend 7: Data and analytics worlds collide. ... Trend 8: Data marketplaces and exchanges. Trend 9: Blockchain in data and analytics Trend 10: Relationships form the foundation of data and analytics value(Graph Technologies & algorithms) Feel free to share your views on any of the above or the one you feel can be in trends
-
Scenario Manager Goal seek Data tables Download practice file https://bi-analytics.org/files/file/29-tutorial-17-what-if-analysis/
-
-
Download files for practice
-
-
567 downloads
If you’ve ever wanted to become an #Excel pro, today is the day! Download our handy formula template, and start down the path of spreadsheet bliss. -
Download data set for practice
-
-
* * is for multiplication and ^ is for "raise to power" 2 * 3 = 6 2 ^ 3 = 2 *2*2 = 8
-
23 downloads
New Analytics ecosystem :Transform, evolve and operationalize -
-
Tutorial 7 : Understanding VBA Macro recording
Saurabh Jain posted a blog entry in VBA Macros - Excel Programing's Tutorials
-
Can office scripts replace VBA programming
-
Very Good morning Right now No certificates... but for sure pure learning that develops fundamental concepts ...It is the skill and confidence that will speak for you
-
-
