Online Safety Community

Want an Easy Fix for Your Excel Spreadsheet [Techniques?] Read This!

Microsoft Excel is a wonder package, and in saying this, I am not exaggerating or taking sides with Mr. Gates’s developers. They have created a program that is so versatile and so tailor-made for just so many industries that you would wonder from where they got the idea to do this. I reckon they must have worked extensively with the industry closely in understanding its needs and implemented all the details with devilish diligence.

The MS Excel program is simply so exhaustive and comprehensive you would feel lost if you are not familiar with it. Once you gain an element of familiarity, it works wonders for most of your needs. Does it surprise that MS Excel is a superhit with a range of industries from finance and compliance and from teaching to sales? All that is needed is a bit of comfort in understanding MS Excel’s features to get to exploit the program to the limit.

So, do you want an easy fix for your MS Excel spreadsheet techniques? Read this!

Like I said, the uses of MS Excel are extremely varied and vast. So, if one were to write down want an easy fix for your MS Excel spreadsheet techniques, it would take a manual! Let me try to make your usage of MS Excel a little easier by offering you tips on a few key features of MS Excel:



Select all with one click

Often, I have noticed users finding it complicated to drag the arrow to all the areas they want to select in the Excel worksheet. I have myself sometimes lost patience with it! I discovered a very simple method of doing this (apart of course from using Control A): click on the arrow (half triangle) at the left corner of the row and you’re done!

Pivot Tables

Pivot Tables are a quick way of organizing an enormous number of varied and disparate data sets. It helps in areas such as getting to understand the exact number of units sold of a particular item in a shop and the amount earned from the sale. This feature helps to organize the data quickly, meaningfully and insightfully. All that is needed for an easy fix for your MS Excel spreadsheet techniques for Pivot Tables is this:



Report Filter: To create by rows by parameters such as, in this case, pack size, manufacturer, date of arrival of stock into the inventory and expiry date

Column Labels: Helps you give a name or label to the items

Row Labels: Enables you to supplement Report Filter by qualifying the labels from the columns and can be used in any manner that the user finds easy

Value: This is the actual calculating part of the tables. It does any kind of operation you want from it like multiplication of the values based on the units sold, minimum, maximum, average, sum and so on.

Removing duplicates

Some cells can carry duplicate content depending on what kind of data go into them. All that is needed to remove the duplicates is to go to select the row or column from which you want this done; go to Data, go to Tools and hit “Remove Duplicates”.

AutoSum

This is used to obtain the sum of different values in cells. Just go to the far-right corner and click on the AutoSum option. You will have the choice of sum, average, count numbers and so on. Once you set this, it will keep doing the summing up by itself.



Open many MS Excel files and shift between them

This is one hell of a feature from MS Excel! Once you have created different files in the usual file creation mode, just click on each of them and press enter. All files will open simultaneously. And then, if you want to alternate between any of them, keep hitting control tab, just like in MS Word.

Carrier with Excel If you Loose this now? https://goo.gl/bWxnnA

Views: 30

Comment

You need to be a member of Online Safety Community to add comments!

Join Online Safety Community

Take our poll!

Take our poll!

Latest Activity

Martin walker is now a member of Online Safety Community
3 hours ago
Nakul Pratap posted a blog post

How to become an expert Safety Consultants

If you want safety culture at your workplace, you should have certified safety consultantA Safety consultant is the person who gives advices and aides the employees with respect to health and safety of both small and large size such as manufacturing factories, engineering, construction, mining and so on  Likewise the safety consultant guides you to rectify the solution for issues by enhancing the health and safety standards, policies as well as by limiting injuries and mishaps at work…See More
7 hours ago
Adam Fleming posted a blog post

What do Your Customers Really Think About Your Complaint Handling?

Compliance4All, a leading provider of professional training for all the areas of regulatory compliance, is organizing a webinar on the topic, “Complaint Handling” on February 6. Peggy J. Berry, President & CEO at Synergy Consulting, will be the speaker at this webinar.Please visit http://bit.ly/2GFGiXr to enroll for this webinar.—————————————————————————————————————A complaint says a lot about a product. It helps the manufacturer to reflect on where it…See More
8 hours ago
kate smith posted events
Wednesday

Forum

Technology and Safety 1 Reply

What are the most useful tools to have at your fingertips? -Toolbox Talks-JSA-JHA-Daily Reports, etc. What is falling through the cracks that could be an easy fix? Safety Managers, Coordinators and…Continue

Tags: safety

Started by Drew stone. Last reply by Jen McDade 13 hours ago.

Important of Warning sign 1 Reply

Warning sign is a type of traffic sign that guide a hazard ahead on the road. Having proper warning sign on the road provide a healthy environment.Continue

Tags: Signs, Workplace, Safety, Sign, Warning

Started by healthandsafetysigns. Last reply by Jen McDade Jan 14.

Workers paticipation in safety management 2 Replies

Workers paticipation in safety management is the aspect which is required to be implemented in the OHSAS 18001 2007 version. , I invite our experience community members to share their views on the…Continue

Tags: management, safety, in, paticipation, Workers

Started by SafetyRaja. Last reply by Tara safe Dec 27, 2018.

How to improve safety culture of factories 4 Replies

How to improve safety culture of factories having mostly contract and casual ever changing workers for whom training and monitoring both are major issues. Such qorkers are mainly meeting accidents in…Continue

Started by Harkant Dave. Last reply by Jen McDade Dec 24, 2018.

[General Industry] What is your workplace's policy on headphones? Working on one currently. 1 Reply

I have been tasked to create a headphones (and cell phone) policy for my employer. I am relatively new to this company, but so far they've let everyone listen to headphones and mess around with their…Continue

Tags: general, industry, distraction, music, phone

Started by Kyle C. Johnson. Last reply by Jen McDade Dec 19, 2018.

Badge

Loading…

© 2019   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service