Jump to content
Business Intelligence & Analytics Community

Blogs

Tutorial 3 - Entering Formula &  introduction to cell referencing

Tutorial 3 - Entering Formula & introduction to cell referencing

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

Saurabh Jain

Saurabh Jain

Tutorial 1 - Creating First workbook - Monthly sales Projection

Tutorial 1 - Creating First workbook - Monthly sales Projection

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 Plea

Saurabh Jain

Saurabh Jain

 

45 Analytic Techniques Used by Data Scientists

These techniques cover most of what data scientists and related practitioners are using in their daily activities, whether they use solutions offered by a vendor, or whether they design proprietary tools The 45 data science techniques   Linear Regression  Logistic Regression  Jackknife Regression * Density Estimation  Confidence Interval  Test of Hypotheses  Pattern Recognition  Clustering - (aka Unsupervised Learning)

Saurabh Jain

Saurabh Jain

 

10 Quick Time-Saving Excel Shortcuts & Mouse Tricks

Improving your Excel skills is a great place to begin to claw back a few minutes on every project, because Excel is a tool used by most of us on a regular basis. It has so many incredible capabilities that are not immediately apparent. Just finding one trick can save you minutes every day. Excel Tip No. 1: Automatically SUM() with ALT + = Quickly add an entire column or row by clicking in the first empty cell in the column. Then enter ALT + ‘=’ (equals key) to add up the numbers in eve

Saurabh Jain

Saurabh Jain

×
×
  • Create New...