- Read more...
- 0 comments
- 813 views
-
Posts
1,724 -
Joined
-
Last visited
-
Days Won
61
Content Type
Profiles
Forums
Gallery
Downloads
Blogs
Events
Online Conference
The Excel dictionary
Power Query M function dictionary
Blog Entries posted by Saurabh Jain
-
Learn ways of filling series and copying series in Microsoft Excel #excel #exceltutorial #exceltraining #excelbasics
-
- Read more...
- 0 comments
- 2,284 views
-
I asked this on Linkeidn, Facebook, Youtube
Here is the video
Download Template file
- Read more...
- 0 comments
- 2,465 views
-
MAP – REDUCE – SCAN MAKEARRAY –BYROW – BYCOL ISOMITTED These are recently announced functions by Microsoft .where we can pass lambdas as arguments
Download template files
- Read more...
- 0 comments
- 1,596 views
-
We will use setValue() to write data in cell This tutorial will tech you 1 Where to write code 2 How to run the program, 3 Writing data in cell using setValue() ----------------- A good hand on example to start your office script journey
- Read more...
- 0 comments
- 1,779 views
-
- Read more...
- 0 comments
- 541 views
-
Overview of using Power Query in Excel to automate the combining (appending) task Free Advanced MS Excel course
- Read more...
- 2 comments
- 3,092 views
-
Scenario Manager
Goal seek
Data tables
Download practice file
https://bi-analytics.org/files/file/29-tutorial-17-what-if-analysis/
- Read more...
- 1 comment
- 3,197 views
-
- Read more...
- 0 comments
- 1,493 views
-
Download Excel file
- Read more...
- 0 comments
- 4,078 views
-
Download code file
- Read more...
- 1 comment
- 1,280 views
-
- Read more...
- 1 comment
- 709 views
-
Whether you are an analyst doing research, or student making a project, you have to many times extract data from pdf for analysis in excel. Here is a very simple and smart way of doing the same
- Read more...
- 0 comments
- 2,723 views
-
Approve members in Linkedin groups Power Automate Desktop web recording
By Saurabh Jain,
Power Automate DesktopUsing web recorder in power automate desktop
- Read more...
- 0 comments
- 580 views
-
Rename Files in Power automate desktop by reading names from excel worksheet
By Saurabh Jain,
Power Automate DesktopRename Files in Power automate desktop by reading names from excel worksheet
#rpa
- Read more...
- 0 comments
- 1,941 views
-
Learn how to count, sum and display running totals
- Read more...
- 0 comments
- 933 views
-
VBA Tutorial 14 : For loop examples to read data write data & transform data
- Read more...
- 0 comments
- 1,498 views
-
Power Automate Demo : listing files from folder in Excel sheets
By Saurabh Jain,
Power Automate Desktop- Read more...
- 0 comments
- 517 views
-
Please comment if you want to be part of this course
I am In
Meanwhile : please do have a look on Excel tutorials
https://bi-analytics.org/blogs/blog/6-excel-tutorials/
- Read more...
- 39 comments
- 2,904 views
-
- Read more...
- 0 comments
- 628 views
-
Tutorial 19 Power Pivot Overview Dax Formulas – calculated Column
Download the file for practice
- Read more...
- 0 comments
- 2,289 views
-
Report link
https://datastudio.google.com/s/gKoXJ-9rsec
Report embedded
- Read more...
- 1 comment
- 696 views
-
Download practice file
- Read more...
- 4 comments
- 3,456 views
-
- Read more...
- 0 comments
- 1,579 views
-
In this case, we will analyze sales data from two stores and answer the following questions
What percentage of sales occur at each store ? What percentage of sales occur at each month ? How much revenue does each product generated? Which products generate 80 % of revenue? We will also learn the Use of Report Filters & Slicers
Download data set
- Read more...
- 8 comments
- 8,846 views