# data[].attributes.body
Reflection on your learning and discussion of the impact of analytics on working life.- Action research is used in HRM in the workplace to evaluate its potential contribution to the field. Action research is well suited to the development of theories and excels at producing scholarly knowledge that is relevant to specific circumstances and informs practitioners. It helps HRM by highlighting the importance of context and the dynamic nature of HRM design, implementation, and assessment, as well as demonstrating the efficacy of systemic interventions. Guidelines for conducting HRM action research projects are provided, stressing the necessity of incorporating key stakeholders, detailed memos of the study process, and self - awareness on both academics' and professionals' goals.
Bleijenbergh I , Mierlo J, Bondarouk T, (2021),  Closing the gap between scholarly knowledge and practice: Guidelines for HRM action research, Human Resource Management Review,  Vol.31 ,( Issue 2), p.100764, Available from : https://www-sciencedirect-com.uow.idm.oclc.org/science/article/pii/S1053482220300371 (Accessed 31st March 2022)

Reflection on how Excel is used in the areas of HR
N/A.

# data[].attributes.body
Excel is used by most HR professionals to do their daily tasks because of its powerful analysis capabilities and flexibility.

Excel can be used to store data of the employees, to manage the payrolls, to schedule the employee's rota, and to track the daily expenses of the business.

https://library-collections-search.westminster.ac.uk/permalink/44WST_INST/1b7kp0c/cdi_webofscience_primary_000304043500005CitationCount

https://www.investopedia.com/articles/personal-finance/032415/importance-excel-business.asp

# data[].attributes.body
Marketing and Product Management

While marketing and product professionals look to their finance teams to do the heavy lifting for financial analysis, using spreadsheets to list customer and sales targets can help you manage your salesforce and plan future marketing strategies based on past results.

Using a pivot table, users can quickly and easily summarize customer and sales data by category with a quick drag-and-drop.

Investopedia. 2022. The Importance of Excel in Business. [ONLINE] Available at: https://www.investopedia.com/articles/personal-finance/032415/importance-excel-business.asp. [Accessed 31 March 2022].

# data[].attributes.body
HR professionals choose excel for daily activities such as keeping track of the absences and also to sort the data. Excel is also used by HR to store personal data of the employees. Excel can be used to manage payroll and employee data, exporting that data to Excel allows users to spot trends, summarise expenses and hours by pay period, month, or year, and gain a better understanding of how their workforce is distributed by function or pay level.

Investopedia. 2022. The Importance of Excel in Business. [ONLINE] Available at: https://www.investopedia.com/articles/personal-finance/032415/importance-excel-business.asp

# data[].attributes.attachment_link.description
Microsoft Excel is an indispensable tool for any business.

# data[].attributes.attachment_caption
Economic demographics can be presented in excel / can be used for market segmentation and representing data

# data[].attributes.body
https://web.p.ebscohost.com/ehost/pdfviewer/pdfviewer?vid=0&sid=5c422d63-812a-4c87-b077-24f2b58f17a5%40redis

# data[].attributes.attachment_link.title
Let's put demography back into economics: Population pyramids in Excel.

# data[].attributes.attachment_caption
 Excel is used in economics when creating company forecasts 

# data[].attributes.body
https://ebookcentral.proquest.com/lib/westminster/reader.action?docID=5741757

# data[].attributes.attachment_link.readable_text
Microsoft Excel was first introduced in 1985, and it has since become one of the most important computer programmes in offices all around the world. Excel makes it simple to save, analyse, and interpret our data. It helps numerous departments and sectors in making efficient decisions.
Excel's applications in various aspects of business:
1. Finance and Accounting - Walk into any large corporation's finance department and you'll see computer displays full of spreadsheets. Data handling becomes a matter of minutes with the help of Excel. Initially, financial records were kept manually in books. This increased the risk of human error and required the utilisation of a significant amount of time to crunch figures. However, by using Excel, errors are minimised to a minimum, and data interpretation is simplified.

Advanced Excel provides users with a large number of formulas that make difficult computations simple and error-free. The use of graphs can also aid in the comprehension of trends. Excel can add, subtract, multiply, and divide for most users, but when used in combination with VLOOKUP, INDEX-MATCH-MATCH, and pivot tables, it can do a lot more.

2. Marketing & Product Management - Marketing entails more than just meeting sales targets; it also includes a variety of other activities aimed at increasing the product's reach among buyers. This is simple to achieve these days due to social media. Excel can be used to track sales, list adwords, prepare budgets, schedule strategies and plans of action, track market trends, and calculate sales volume, creating blogs calender, among other things.

With the use of pivot tables, sorting, and filters, determining which product is having the greatest impact on the market is as simple as clicking a button. We can categorise and summarise customer preferences also. Decision making is effective with the use of excel.

3. Human Resource Planning - While database systems such as Oracle (ORCL), SAP (SAP), and Quickbooks (INTU) can be used to manage payroll and employee data, exporting that data to Excel allows users to spot trends, summarise expenses and hours by pay period, month, or year, and gain a better understanding of how your workforce is distributed by function or pay level.

HR experts may utilise Excel to analyse a large spreadsheet of employee data and determine where the expenditures are coming from, as well as how to effectively plan and control them in the future.

4. Managing Operations - Many organisations rely significantly on Excel to run their day-to-day operations.When it comes to business, logistics can be rather complex. Inventory flows must be managed to keep operations running smoothly - and to avoid overstocking on specific items. This entails keeping track of supplier and customer transactions, putting together a calendar of important dates, and managing time and schedules.

For many small businesses, Microsoft Excel is an essential tool (or parts of larger businesses). Excel has the advantage of being relatively low-tech, allowing it to be utilised by a large number of individuals without the danger of programming flaws.Excel is here to stay, and organisations will continue to utilise it as a major tool for a wide range of tasks and applications, from IT projects to workplace picnics.

5. Administrative Uses - Excel is used by office administrators to enter and store important administrative data. Accounting and financial reporting, as well as business analysis and performance reporting, can all be done with the same data.

Excel is important in office administration for assisting day-to-day duties such as invoicing, paying bills, and contacting suppliers and clients, in addition to recordkeeping. It's a multi-functional tool for tracking and organising workplace operations.

Most office workers today require a decent grasp of Excel, and higher Excel skills can lead to advancement and leadership opportunities. Excel is a strong tool, but it can't do everything by itself. To produce the finest outcomes for their company, a wise computer user must take use of everything Excel has to offer.

# data[].attributes.attachment_link.title
Importance of Microsoft Excel in Business

# data[].attributes.attachment_link.description
Microsoft Excel was first introduced in 1985, and it has since become one of the most important computer programmes in offices all around the world. Excel makes it simple to save, analyse, and interpret our data.

# data[].attributes.body
Excel offers a range of different uses such as charting, inventory tracking, checklists and more which can be useful for entrepreneurs when running their business.

# data[].attributes.attachment_link.readable_text
Excel. Chances are, that word alone inspires visions of lengthy spreadsheets, complicated macros, and the occasional pivot table or bar graph.

It's true-with more than one billion Microsoft Office users globally, Excel has become the professional standard in offices across the globe for pretty much anything that requires management of large amounts of data.

But, if you think Excel is only good for making you cross-eyed while looking at a bunch of numbers and financial reports, think again. As Tomasz Tunguz points out, there are tons of uses of Excel in business (and beyond) outside of simple spreadsheets. In fact, the potential uses are seemingly endless.

There's no way for us to compile a list that captures every one of Excel's possible applications (even if you were up for reading a War and Peace-sized listicle).

However, in an effort to demonstrate the power and flexibility of everybody's favorite spreadsheet tool, we've pulled together different ways that you could use Excel-both professionally, personally, and just for the fun of it.

All about numbers

Of course, the core purpose of Excel all boils down to numbers. If you need to sort, retrieve, and analyze a large (or even small!) amount of data, Excel makes it a breeze.

Here are a few broad categories to keep in mind when it comes to implementing Excel for anything numbers-related.

1. Calculating

Find yourself running the same calculations over and over again? Build yourself a totally customized calculator in Excel by programming your commonly-used formulas. That way, you just need to punch in your digits and Excel will spit the answer out for you-no elbow grease required.

2. Accounting

Budget plans, forecasts, expense tracking, financial reports, loan calculators, and more. Excel was pretty much designed to meet these different accounting needs. And, considering that 89 percent of companies utilize Excel for its various accounting functions, it obviously fits the bill.

Excel even has numerous different spreadsheet templates to make all of those processes that much easier.

3. Charting

Pie charts, scatter charts, line charts, bar charts, area charts, column charts -the list goes on and on. If you need to find a way to represent data in a more visual and digestible way, Excel's ability to transform rows and columns of digits into beautiful charts is sure to become one of your favorite things about it.

Want more information about the types of charts you can create in Excel? This article is a helpful resource.

Want to learn more?

Take your Excel skills to the next level with our comprehensive (and free) ebook!

4. Inventory tracking

Tracking inventory can be a headache. Fortunately, Excel can help to keep employees, business owners, or even individuals organized and on top of their inventory-before any major problems crop up.

Making a plan

Let's move on from the numbers-there are plenty of things that Excel can help you plan and organize that don't necessarily involve endless rows of digits.

5. Calendars and schedules

Need to map out a content calendar for your blog or website? Lesson plans for your classroom? A PTO schedule for you and all of your co-workers? A daily schedule for you or your family? When it comes to various calendars, Excel can be surprisingly robust.

6. Seating charts

From a large corporate luncheon to a wedding, arranging a seating chart can be a royal headache. Fortunately, Excel can make it a total breeze. If you're a real whiz, you'll be able to automatically create your seating chart using your spreadsheet of RSVPs. Need help getting this done? This article provides a detailed walkthrough of how you can create a seating chart in Excel.

7. Goal planning worksheet

From professional goals to fitness goals to financial goals, it helps to have something to keep you focused and on track. Enter the beauty of Excel. Using the tool, you can create various worksheets, logs, and planning documents to help you monitor your progress-and, hopefully, cross the finish line.

8. Mock-ups

Excel might not be the first platform you think of when it comes to design. But, believe it or not, you can use the tool to put together various mock-ups and prototypes. In fact, it's a surprisingly popular choice for creating website wireframes and dashboards.

Getting stuff done

Want to kick your productivity into high gear? Well, Excel can swoop in and save the day with a variety of uses that can help you tackle your tasks and to-dos with ease and organization.

9. Task list

Say goodbye to your standard pen and paper to-do list. With Excel, you can make a far more robust task list-and even track your progress on those larger to-dos that are currently on your plate.

10. Checklist

Similarly, you can create a simple checklist that allows you to tick off the things you've purchased or accomplished-from a grocery list to a roster of to-dos for an upcoming marketing campaign.

11. Project management charts

We've already touched on the fact that Excel is a total beast when it comes to creating charts. And, this concept holds true when it comes to various charts for project management.

From waterfall charts to manage your team's progress to kanban style boards (just like Trello!) to keep things organized, there are tons of ways that Excel can help keep your project on track.

12. Time logs

You know that tracking time can be a huge asset to you and your productivity. While there are plenty of fancy apps and tools to help meet that need, you can think of Excel as the original tool for logging your time. And, it still serves as a suitable option today.

Involving other people

Need to collect information from other people? Survey tools and forms are one option. But, rest assured, you can also create your own in Excel.

13. Forms

From simple to complicated, Excel is a great option for creating forms. You can even program various drop-down menus so that users can select their choice from a pre-set list.

Image source: Fontstuff.com

14. Quizzes

Trying to test somebody else's-or even your own-knowledge of a subject? In Excel, you can create a bank of questions and answers in one worksheet, and then instruct Excel to quiz you in another.

Staying in touch

Managing relationships is crucial to your success both professionally and personally. Fortunately, Excel makes it easy to keep in touch.

15. CRM

Need a lightweight CRM to stay top of mind for your customers? You can make one in Excel. And, the best part? Building your own means it will be totally customizable. Sales Hacker also put together a nifty set of free sales excel templates you can use to help get started!

16. Mailing list

Data doesn't just have to involve numbers. Excel is also great at managing and sorting large amounts of names and addresses-making it the perfect solution for your invite list for that company holiday party or the mailing list for that large promotion or campaign.

Using Excel, you can also mail merge-which makes it that much easier to print address labels and other necessary materials.

You can also apply a similar concept to create things like directories, RSVP lists, and other rosters that involve a large amount of information about people.

Just for fun

Excel doesn't need to be all work and no play. There are plenty of other fun things you can create using the spreadsheet tool.

17. Historical logs

Whether you want to keep track of the various craft beers you've tasted, the workouts you've completed, or something else entirely, you can think of Excel as your go-to resource for keeping those things sorted and logged.

18. Sudoku puzzles

Love Sudoku puzzles? As it turns out, you can make your own in Excel. Or, if you find yourself stuck on a particularly challenging one, you can enlist the help of Excel to help you get it figured out!

Need help creating the Sudoku solver and generator? This post will get you well on your way!

19. Word cloud

Word clouds might not be the most scientific representations of data. But, they're a fun (not to mention beautiful way) to gain an understanding of what words are being utilized most. You guessed it-you can create one using Excel. Here's how to use information from Excel to create a word cloud in Wordle.

20. Art and animations

The capabilities of Excel likely extend far beyond what you'd initially anticipate. In fact, many people have used the tool to create some downright awesome art-from pixelated portraits to animations.

21. Trip planner

Have a vacation coming up? Make sure you have everything covered by creating yourself a helpful itinerary before you pack your bags and head out. Excel even has a handy trip planner template you can use to make sure you don't miss anything (from your budget to airline information!).

Over to you

This might seem like a lengthy list. But, rest assured, it barely scratches the surface of all of the different things-aside from simple spreadsheets-that Excel is capable of. From lists to charts to design mock-ups, the different uses of Excel are seemingly limitless.

Feeling intimidated? Don't worry - you can learn Excel online, all at your own pace, and become a spreadsheet ninja in no time.
Do you have something cool you like to create using Excel? Let us know in the comments!

# data[].attributes.attachment_link.description
Excel. Chances are, that word alone inspires visions of lengthy spreadsheets, complicated macros, and the occasional pivot table or bar graph. It's true-with more than one billion Microsoft Office users globally, Excel has become the professional standard in offices across the globe for pretty much anything that requires management of large amounts of data.

# data[].attributes.body
Finance and accounting professionals choose Excel for its complex analytical and computing features.

Microsoft Excel enables users to identify trends and organise and sort data into meaningful categories.

Pivot tables summarise data from a worksheet into a chart.

Most users know that Excel can add, subtract, multiply, and divide, but it can do much more with advanced IF functions when coupled with VLOOKUP, INDEX-MATCH-MATCH, and pivot tables.

Investopedia. 2022. The Importance of Excel in Business. [ONLINE] Available at: https://www.investopedia.com/articles/personal-finance/032415/importance-excel-business.asp. [Accessed 31 March 2022].

# data[].attributes.body
Entrepreneurship
Marketing and Product Management
Using spreadsheet to list customer and sales target can help manage salesforce and plan future marketing

https://www.investopedia.com/articles/personal-finance/032415/importance-excel-business.asp

Excel has many advanced formulas that can mean something that could take hours to do manually can be done in a few minutes.
Forecasts, financial results, creating budgets

# data[].attributes.body
Entrepreneurs use Excel for budgeting, analysis, forecasting, spotting trends, reporting and more.
Excel allows entrepreneurs to store any data- from accounts to merchandise, to phone numbers and view and track it in an organized manner.