Jump to content
Business Intelligence & Analytics for Digital Transformation

Saurabh Jain

  • Posts

  • Joined

  • Last visited

  • Days Won


Saurabh Jain last won the day on July 31

Saurabh Jain had the most liked content!


Personal Information

  • Location (City)
  • Business Vertical
    Bi & Analytics
  • Industry

Recent Profile Visitors

6,503 profile views

Saurabh Jain's Achievements


Apprentice (3/14)

  • First Post Rare
  • Collaborator Rare
  • Conversation Starter Rare
  • Dedicated Rare
  • Week One Done Rare

Recent Badges



  1. To give it a start I am sharing the screenshot of Spreadsheet report made by me in 2007 The name was given performance cockpit My boss Mr Kuldeep Sharma inspired me to make this report Summary Capacity utilization Status of running orders Shipment performance We used to track the data on a daily basis and in summary sheet MTD and YTD figures were shown automatically.
  2. Do you use Excel, Google sheet or another spreadsheet at you work? Whether it is a dashboard, or a simple monthly sales report or a simple tracking list Engineering analysis or financial analysis Marketing, Sales or HR Analysis Colorful or Simple Charts or Table Your best work or your first work Choose one such spreadsheet which you are proud of and share the same We invite you to showcase the screenshot of same spreadsheet and write few lines describing your spreadsheet which may include logic, formula, type of analysis, name of the report etc. This is a knowledge sharing activity and the idea is to display your passion for the spreadsheet, to make it delight, Guidelines and Rules pl keep one entry (post) per person. Do not post twice... If needed edit your already written post. Pl update your location in your profile Prefeed language is English: you can even translate Collective (joint) effort from all participants will lead to enormous learning Your creative and innovative concise description will lead to an interesting showcase to your spreadsheet screenshot. If your data is confidential, use dummy data to showcase the spreadsheet Looking for active participation.: Posting is one part -liking others work is equally important As of now Last date 21st Oct 21 Thanks, and Regards Saurabh Jain Let see who will be among first five to give this activity a grand start
  3. Hello everyone, I will be soon starting tutorials for Power Query, Before I start, I will happy to hear from you all on the following Do you perform some repetitive tasks in Excel? and would you like to make it automation for that ? Please do share so that in between I can take the same , Looking to hear from you all Trust me Power Query will change the way you work Regards Saurabh Jain
  4. Does Spreadsheet (Excel, Google sheet etc) changed your life .. Showcase the same in one or few magical creative lines...
  5. My 90 % of the day revolves around Microsoft Excel and occasionally on Google sheets ? How about you ?
  6. MAP – REDUCE – SCAN MAKEARRAY –BYROW – BYCOL ISOMITTED These are recently announced functions by Microsoft .where we can pass lambdas as arguments Download template files
  7. Version 1.0.0


    lambda helper finctions MAP Redude Scan Byrow ByCol makearray isomitted
  8. Office has a fresh look. It’s modern and new, designed to help you focus on your best work. This new update includes: Simple, intuitive, and seamless experience across all your Office apps Customizable ribbon that you can change and create shortcuts to everyday commands you use the most Office themes that stays in sync with your Windows light or dark mode setting by default Share your work and collaborate with others in real time by selecting Share and sending your draft to whomever you want.
  9. 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
  10. Hi Sam A delay addon in between each step may be a quick trick to resolve the same Just see how much seconds manually printing take place and then just add delay say of 30 seconds to 1 minutes Hope that helps Regards Saurabh
  11. Google Spreadsheets vs. Microsoft Excel: What Should You Choose & when ?
  12. It will be our pleasure to help you and see you growing in your professional journey
  • Create New...