HomeMy HighlightsDiscover
Sign up
Mr Nobody (Monkey_Junkie_No1)

Mr Nobody (Monkey_Junkie_No1)

@l0alvpkbdbghejse

Ask AI Clone

Joined Sep 6, 2023

0

Following

0

Followers

96

pages

600

highlights

280

views
M
W
F
Dec
Jan
Feb
Mar
All/Weekly/Yearly
Total Days:
Total Weeks:
31-Days 📚
19-Weeks 📚
Tags
Domains
www.reddit.com 20
www.acas.org.uk 8
www.cipd.org 8
community.cipd.co.uk 6
www.legislation.gov.uk 6
www.thrivelaw.co.uk 5
www.pinsentmasons.com 4
www.aihr.com 3
organisemyhouse.com 3
www.hrgrapevine.com 2
www.managementconsulting.blog 2
www.coursera.org 2
www.gov.uk 2
online.hbs.edu 1
www.oakwoodsolicitors.co.uk 1
onefabday.com 1
www.city-academy.com 1
www.thehrdirector.com 1
www.ciphr.com 1
www.brownejacobson.com 1
www.employmentsolicitor.com 1
www.truthlegal.com 1
www.businessbecause.com 1
www.linkedin.com 1
www.trowers.com 1
www.gtlaw.com.au 1
www.wallstreetoasis.com 1
www.blaze.tech 1
www.forbes.com 1
pingax.com 1
medium.com 1
productcoalition.com 1
www.citizensadvice.org.uk 1
gateleyplc.com 1
teambuilding.com 1
www.birkettlong.co.uk 1
webcache.googleusercontent.com 1
www.milkround.com 1
Show All

Atomic Graph

Highlights
Favorite
Kindle
Video
Bookmarks
Hatches
Posts

5 Things I’d Tell Myself Before Entering the HR Industry

medium.com/everything-around-the-sun/5-things-id-tell-myself-before-entering-the-hr-industry-59223f87a1de

Mar 17, 2024

1

r/humanresources - Tips for first job in HR?

www.reddit.com/r/humanresources/comments/11pofud/tips_for_first_job_in_hr/

Mar 17, 2024

34

Tips for starting a new job | Milkround

www.milkround.com/advice/tips-for-starting-a-new-job

Mar 17, 2024

20

Data case shows CAT claims are broadening

www.pinsentmasons.com/en-gb/out-law/analysis/data-case-shows-cat-claims-are-broadening

Mar 8, 2024

6

How to start planning a wedding (without getting completely overwhelmed!)

onefabday.com/starting-wedding-planning/

Feb 23, 2024

1

CIPD | Employee experience roles

www.cipd.org/uk/the-people-profession/careers/roles/employee-experience/

Jan 17, 2024

1

CIPD | Organisational development and design roles

www.cipd.org/uk/the-people-profession/careers/roles/organisational-development-design/

Jan 17, 2024

3

CIPD | Be a force for positive change

www.cipd.org/uk/the-people-profession/careers/why-work/

Jan 17, 2024

3

CIPD | What do HR generalists do?

www.cipd.org/uk/the-people-profession/careers/roles/hr/

Jan 17, 2024

2

Asking for and taking holiday - Holiday entitlement - Acas

www.acas.org.uk/checking-holiday-entitlement/asking-for-and-taking-holiday

Jan 9, 2024

1

The Working Time Regulations 1998

www.legislation.gov.uk/uksi/1998/1833/regulation/15?view=extent

Jan 9, 2024

3

The Working Time Regulations 1998

www.legislation.gov.uk/uksi/1998/1833/regulation/13A?view=extent

Jan 9, 2024

1

The Working Time Regulations 1998

www.legislation.gov.uk/uksi/1998/1833/regulation/13A

Jan 9, 2024

1

The Working Time Regulations 1998

www.legislation.gov.uk/uksi/1998/1833/regulation/15

Jan 9, 2024

2

If you're being harassed or bullied at work

www.citizensadvice.org.uk/work/discrimination-at-work/discrimination-at-work/checking-if-its-discrimination/if-youre-being-harassed-or-bullied-at-work/

Dec 12, 2023

4

What bullying is - Bullying at work - Acas

www.acas.org.uk/bullying-at-work

Dec 11, 2023

5

Supporting employees - Handling bullying and discrimination - Acas

www.acas.org.uk/handling-a-bullying-discrimination-complaint/supporting-employees

Dec 11, 2023

1

Formal complaints - Handling bullying and discrimination - Acas

www.acas.org.uk/handling-a-bullying-discrimination-complaint/dealing-formally

Dec 11, 2023

1

Informal complaints - Handling bullying and discrimination - Acas

www.acas.org.uk/handling-a-bullying-discrimination-complaint/dealing-informally

Dec 11, 2023

3

Approaching a complaint - Handling bullying and discrimination - Acas

www.acas.org.uk/handling-a-bullying-discrimination-complaint

Dec 11, 2023

11

HR Data Analysis in Excel: A Step-by-Step Guide

www.aihr.com/blog/hr-data-analysis-excel/

Dec 10, 2023

29

Understanding the data analytics project life cycle

pingax.com/understanding-data-analytics-project-life-cycle/

Dec 10, 2023

19

How to Create a Skills Matrix for Success [Free Template]

www.aihr.com/blog/create-skills-matrix-competency-matrix/

Dec 6, 2023

1

Sunsetting & fragmentation: TUPE drafting in 2023 | theHRD

www.thehrdirector.com/legal-updates/legal-updates-2023/sunsetting-fragmentation-tupe-drafting-2023/

Nov 23, 2023

3

www.trowers.com/insights/2021/march/tupe-and-fragmentation-a-change-of-approach

Nov 23, 2023

1

The Transfer of Undertakings (Protection of Employment) Regulations 2006

www.legislation.gov.uk/uksi/2006/246/regulation/3

Nov 22, 2023

5

Fragmenting employment contracts | Employment law | Browne Jacobson LLP

www.brownejacobson.com/insights/fragmenting-employment-contracts

Nov 22, 2023

12

TUPE - What is an 'Organised Grouping of Employees'? - Birkett Long Solicitors

www.birkettlong.co.uk/site/library/legalnews/TUPE_what_is_an_organised_grouping_of_employees.html

Nov 22, 2023

1

The Transfer of Undertakings (Protection of Employment) Regulations 2006

www.legislation.gov.uk/uksi/2006/246/regulation/4

Nov 22, 2023

1

Gateley - TUPE and Service Provision Changes: key considerations

gateleyplc.com/insight/article/tupe-and-service-provision-changes-key-considerations/

Nov 22, 2023

2

Employees must be part of a "deliberate" grouping to transfer under TUPE, tribunal says

www.pinsentmasons.com/out-law/news/employees-must-be-part-of-a-deliberate-grouping-to-transfer-under-tupe--tribunal-says

Nov 22, 2023

4

TUPE: Do we have to accept this employee? - EmploymentSolicitor.com

www.employmentsolicitor.com/tupe-transfer-employee/

Nov 21, 2023

6

Examples of Business Analytics in Action | HBS Online

online.hbs.edu/blog/post/business-analytics-examples

Nov 12, 2023

1

Implications of relying on flawed workplace investigations

www.pinsentmasons.com/en-gb/out-law/analysis/implications-of-relying-on-flawed-workplace-investigations

Nov 12, 2023

25

UK Supreme Court backs worker-friendly underpayment ruling

www.pinsentmasons.com/en-gb/out-law/news/uk-supreme-court-backs-worker-friendly-underpayment-ruling

Nov 12, 2023

12

A guide to getting employee relations right - Ciphr

www.ciphr.com/advice/a-guide-to-getting-employee-relations-right/

Nov 12, 2023

10

Unraveling the True Cost of Onboarding a New Employee

www.blaze.tech/post/unraveling-the-true-cost-of-onboarding-a-new-employee

Nov 12, 2023

1

CIPD | Employee relations roles

www.cipd.org/uk/the-people-profession/careers/roles/employee-relations/

Nov 12, 2023

3

CIPD | The Profession Map / Specialist knowledge / Employee relations

www.cipd.org/uk/the-people-profession/the-profession-map/explore-the-profession-map/specialist-knowledge/employee-relations/

Nov 12, 2023

6

0

HR Data Analysis in Excel: A Step-by-Step Guide

URL
https://www.aihr.com/blog/hr-data-analysis-excel/

Highlights & Notes

data may be contaminated, contains duplicates, inconsistencies, or other errors

Excel Tables are handy containers for your data. They ensure that the values in a row stay together, which prevents you from accidentally scrambling the data when you sort and filter columns. 

If you are working with Excel Tables, the Table Design tab contains a ‘Remove Duplicates’ button. It removes any rows that contain duplicate values on the selected columns. 

However, if you were to select the ‘Department’ column only, Excel will remove all duplicates (such as Research and Development) and retain only the first rows in which it finds unique values.

In Excel Tables, each column has a sortable filter included in its header. 

Under Home > Sort & Filter, you find Custom Sort, allowing more advanced, multi-column sorting. 

Sometimes, numeric data is accidentally imported as text in Excel. This causes problems in your analysis, as Excel sorts text data differently. 

Note that Excel, by default, aligns text strings to the left. Numeric data is default right-aligned.

giving full control over formatting options

Excel provides many functions that help with “manipulating” text data.

It capitalizes the first letter in a text string and any other letters in the text that follow any character other than a letter (also known as title case). All other letters are converted to lowercase letters.

In those cases, you can use LEFT and RIGHT, which respectively allows you to extract any number of characters from the start (LEFT) or end (RIGHT) of a text string. 

In Excel, you can use the SUBSTITUTE function to replace specific parts of a text string with an alternative text. 

However, you can use Paste Special to instruct Excel to do exactly what you want with the copied data and its formatting. You will find the functionality when you click the right mouse button after you’ve copied any data.

Did you know you can even paste the raw results with any formulas you have copied?

First, you might want to calculate descriptive analytics that summarizes your data to assist in uncovering insightful patterns.

PivotTables

COUNTIF function allows you to count all records in a selection that meet a certain condition.

SUMIF function allows you to summate all values in a selection that meet a certain condition

PivotTables allow you to skip a lot of the manual programming and focus on the data analysis. 

PivotTables offer great versatility, allowing you to create complex, customizable reports in a matter of minutes. 

Data visualization refers to representing information (i.e., data) in the form of a chart or diagram for enhanced interpretation

Using storytelling and data visualization can help your audience process your insights quickly and simply

Want to show change over time? Use a line graph! 

Want to show the proportion of a group to the whole? Use a pie chart! 

Want to compare multiple groups? Use a bar chart or column chart!

Need some tips for choosing the right chart? Use a chart picker like this one:

In general, it’s good practice to use color sparingly and functionally to aid insight and storytelling.

Dashboards combine charts, tables, and KPIs in a useful overview to aid decision-making. Dashboards can be static or interactive – where users can select or change the way data is displayed.