Saurabh Jain

Net Promoter Score: A Net Promoter Score (NPS) is an excellent way of measuring to what degree someone would recommend a service or business to another person. To find out how satisfied employees are with HR’s services, you can measure the NPS of HR. Using the NPS, you can also measure to what degree people recommend working for the organization. Depending on your strategic goals, NPS can be a solid HR KPI.

Internal promotion rate: This KPI is measured by dividing the number of senior functions that were filled through internal promotion by the total number of senior positions filled. Internal hires are often up to speed faster, reduce the risk of a bad hire, and stay longer in the role.

Employee innovation index: Innovation is also measured through attitude or engagement surveys. Innovation is more and more often a key driver of business success. It’s the role of HR to enable this innovation.

Employee engagement index: Employee engagement is also measured through attitude or engagement surveys. High employee engagement predicts higher productivity, better customer service, lower turnover, and many other relevant and positive outcomes.

Employee satisfaction index: Employee satisfaction is measured via employee attitude and engagement surveys. Dissatisfaction is a common cause of employee turnover.

Employee productivity rate: Although this metric is hard to calculate, it says something about the capacity of growth in terms of production of human capital. It often relates to speed, or could reflect accuracy. 

Benefits satisfaction: Satisfaction with employee benefits is usually measured through an employee engagement survey. These can be very helpful in reducing employee turnover.

Absence cost: The total cost of absence is calculated by including employee pay, the cost of managing absence, and replacement cost. This KPI is especially relevant for  countries with strong labor unions and a high degree of employee protection.

Text Functions

• TEXTBEFORE - Returns text that’s before delimiting characters
• TEXTAFTER - Returns text that’s after delimiting characters
• TEXTSPLIT - Splits text into rows or columns using delimiters

Array Manipulation Functions

Combining Arrays

• VSTACK - Stacks arrays vertically
• HSTACK- Stacks arrays horizontally

Shaping Arrays

• TOROW - Returns the array as one row
• TOCOL - Returns the array as one column
• WRAPROWS - Wraps a row array into a 2D array
• WRAPCOLS - Wraps a column array into a 2D array

Resizing Arrays

• TAKE - Returns rows or columns from array start or end
• DROP - Drops rows or columns from array start or end
• CHOOSEROWS - Returns the specified rows from an array
• CHOOSECOLS - Returns the specified columns from an array
• EXPAND - Expands an array to the specified dimensions

Availability 

These functions are currently available to users running Beta Channel, Version 2203 (Build 15104.20004) or later on Windows and Version 16.60 (Build 22030400) or later on Mac.

Sub word_excel_multitable()
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.WorkSheet
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True

Set xlBook = xlApp.Workbooks.Add
Set xlSheet = xlBook.Worksheets(1)


rn = 0
cn = 0
For Each t In ActiveDocument.Tables
For Each r In t.Rows
For Each c In r.Cells

xlSheet.Range("A1").Offset(rn, cn).Value = Left(c, Len(c) - 1)
cn = cn + 1

Next c
cn = 0
rn = rn + 1

Next r

rn = rn + 2
Next t

End Sub

• The code has to be pasted in module of  word document 
• Set reference for Excel object library in word so that word can write in Excel 
• Click Tool > References 

Download the file from the following link

https://bi-analytics.org/files/file/310-mind-reader-vba-example/

• Guess the logic & get chance to win Amazon Gift card $10 (INR 800) subject to availability of Amazon in your country 
• Last date to participate is 5 May 2024
• Those who guesses the right logic... Among them two winners via lucky draw will be selected
• Please post the logic below in the comment box. All comments will be hidden till date so that no one else can read your comments.
• This is just for encouraging participation and to learn how to participate on the website
• try something good, try to give an attempt to solve the logic

All rights reserved.

Call for discussion on same.

A key performance indicator (KPI) is a quantifiable measure of performance over time for a specific strategic objective. Business leaders and senior executives use KPIs to judge the effectiveness of their efforts and make better informed decisions.

Share the one KPI you monitor or your team discuss on a regular basis.

We are unable to access the file...permission is needed

kindly upload file here as attachment

If you don't work with styles, you might be wondering what's so special about them. The easy answer is, they help you work more efficiently. A style is a collection of formats that you can apply simultaneously. For instance, you might want all input cells to have a green background with white font. By using a style, you can apply both formats at the same time. Now, that doesn't sound like a big deal, but there's more. If you decide to change the format for input cells, you don't have to change all those cells individually. You simply change the style and all input cells update automatically—now that's working efficiently.

If you are among the one who use excel style, do share your example with us.

If you do not, give it a try today

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.

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

1. 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

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

Does Spreadsheet (Excel, Google sheet etc) changed your life .. Showcase the same in one or few magical creative lines...

My 90 % of the day revolves around Microsoft Excel and occasionally  on Google sheets ?

How about you ?

All answers posted  will be hidden for a day 

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.

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

Google Spreadsheets vs. Microsoft Excel: What Should You Choose & when ?