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 Files -
-
Version 2.0.0
4 downloads
Participated as a speaker in The Social Media Confluence 3.O The title of Talk was Social Media Trends, organised by WEAPON BHARAT Sharing with you all the presentation -
In this tutorial, we will learning the use of VLookup HLookup Match Index another video just to go more deeper in VLOOKUP
-
-
-
In this tutorial we will learn to write basic formulas and introduction to cell referencing Relative referencing which is the default referencing Absolute referencing Mixed Referencing Important points 4 type of referencing can be cycle through f4 key - when we are in edit mode of cell - (use f2 to enter into edit mode) - A1 , $a$1 , A$1, $A1 Shortcut Ctrl + ~ (tilde which is just above 1 in windows) pl download file
-
The course has just started and as we progress we want to hear from you... Other then normal flow - what specific you want to learn..... Pl share we will try to take similar examples.... Your participation is important
-
Version 1.0.0
94 downloads
Business Intelligence Buyers Guide -
Where we can use Excel Lets look into various elements of Excel & Ribbon Important shortcuts Ctrl +F1 Page Up Page down with Alt and without Alt Right arrow (Tab) Left Arrow ( Shift + tab) You are requested to add comments for a discussion - How do you use excel
-
lets discuss How many of you given an attempt
-
-
hello every one, Today we are starting with our first tutorial, I just thought to start with creating our first workbook. Please see the video and then do it once on your own.. We did the following 1. Column headers 2. Auto filling of months 3 Formula for growth percent 4 Formatting 4 Converted into table & Added Total Row 5 Created the Chart 6 Save I am also attaching the workbook for your reference Please do share - What you learnt in this tutorial..
-
Welcome @Liaquat Najmi I am sure you will love the journey
-
Welcome @M Ali Khan Nice to hear from you....Welcome on the board
-
Welcome @Onur Uzer Pleasure to have you in class.. we are sure you will enjoy the learning journey
- 1 reply
-
- 1
-
-
Intro
Saurabh Jain replied to Minar's topic in Excel users : Business Intelligence & Analytics with Excel's Introduction Zone
Welcome @Minar This is a right place - stay with full energy and enthusiasm for next two months... -
Welcome @Munzir Imam Excel will always help you in the career path Keep a watch ... we are starting soon
- 1 reply
-
- 1
-
-
Hi @Cristian Dimitrov Welcome on board Hope you will enjoy the journey with us.
-
Intro
Saurabh Jain replied to Nazir's topic in Excel users : Business Intelligence & Analytics with Excel's Introduction Zone
Hi @Nazir Welcome on board We are sure you will enjoy the next couple of month journey -
Welcome @Martin Chay Nice to hear from you .. may be we will have some examples from your side too Yes we will have statistics but at later stage....
-
I thought, lets keep it parallel activity, in tutorials, we will start with very basics....to build the foundation...such as even moving within worksheets As we are waiting for new members to join - Lets begin with a Preliminary Exercise Question. 1. In my class, I give five homework assignments, each worth 25 points, and three exams, each worth 100 points. I currently compute a student’s final grade by giving 75 percent of the weight to exams and 25 percent to homework. Set up a spreadsheet to calculate the final grade for a student that allows you to change the weight given to exams. Give a try Do not post your the solutions... the excel file... just share your experience...
-
Welcome sir... What subjects are you taking
-
Hello
Saurabh Jain replied to CIARA's topic in Excel users : Business Intelligence & Analytics with Excel's Introduction Zone
Welcome @CIARA I have been teaching macros .. and groat to see you on board Here focus will be on excel... and yes... if things works right.... vba then we will look for M as well I am sure you will love to be part of the course... In between... we will like to ask you to share your data work .. the tasks you perform... challenges -
Welcome @Kiril I am sure you will enjoy the course and in later half , we will love to hear more about your work and challenges faced by you make the things more productive....
- 1 reply
-
- 1
-
