₦airaland Forum

Welcome, Guest: Join Nairaland / LOGIN! / Trending / Recent / New
Stats: 1,928,859 members, 3,973,056 topics. Date: Saturday, 16 December 2017 at 05:56 PM

3 Key Uses Of Microsoft Excel At Work - Career - Nairaland

Nairaland Forum / Nairaland / General / Career / 3 Key Uses Of Microsoft Excel At Work (15551 Views)

Nigerian Meat Seller Uses POS (Photo) / Banke, Lady Uses Recycled Tyres To Build Furniture (Photos) / 9 Pictures that Define Some Moments At Work (1) (2) (3) (4)

(0) (1) (2) (3) (Reply) (Go Down)

3 Key Uses Of Microsoft Excel At Work by designVATExcel: 8:36pm On Nov 11
Using Microsoft Excel In The Workplace

Microsoft Excel is an indispensable tool for any business. We all use it, either to create Reports for our boss or to track our daily business activities.

Most Employees however struggle to use Excel.

Excel is ideal for Storing, Analyzing & Presenting Business Data. Below I'll explain each of these in more detail:

1) Storing Data:
Microsoft Excel is the No. 1 Business Tool for storing Company Information - from Textual data like Employee Records, to Numerical Data like Sales Numbers; spreadsheets like Excel provide an affordable "Notepad" to store data.

Employees can take advantage of "Excel's Data Form Functionality" to ease the process of entering data into Excel.
Data Forms provide a user friendly way of entering data into a spreadsheet without having to scroll through cells.

2)Analyzing Data:

Microsoft Excel has inbuilt formulas that enable employees better analyze & retrieve data.

For Instance, Monthly Sales Records can be analyzed to obtain: Top Selling Products, Top Customers, Top Salespersons, Top Selling Month. Basically enabling you draw insight from numbers.
Excel Pivot Tables enable employees summarize & analyze large Data Sets with simple button clicks.
Textual Data functionalities can be added to assist with data retrieval. The employee can easily & quickly (both useful in determining efficiency) extract any business data -

a) Customer's Contact Information
b) Patient's Medical Record Number
c) Product's Rack/bin Storage Location, etc.

This not only saves you time, it increases your efficiency making you more productive.

3) Presenting Data:
In addition to analytics, Microsoft Excel supports the creation of Charts, Graphs and other illustrations.

As the Idiom says "a Picture is worth a thousand words". Charts easily depict trends and make "sense" of numbers.

Humans are generally able to infer meaning from these quicker than from figures.
Presenting information into Graphs allows employees visualize the info, helping them understand it better.

For instance: plotting Monthly Turnover figures or Product Sales Numbers allow companies compare progress over time, easily spotting upwards & downward trends

Graphics also give life to Reports & Presentations. All Employees at some point have to create reports, either to present to their team, or to submit to their superiors. Either way Microsoft Excel steps in as the tool for the job.

- Using Percentages to present Sales Target achieved;

- Using SUM & other aggregate functions to calculate Total Income generated, Sales Income per category;

- Using Bar & Column Charts when presenting budgets, Actuals vs Proposed Spending;

Excel is an immensely Complex Business Tool that has many more functionalities than listed above. However it's flexible nature enables Users mould it to suit their specific business needs.

Source: http://designvat.com/FAQ/Microsoft-Excel-For-Business.html

8 Likes 4 Shares

Re: 3 Key Uses Of Microsoft Excel At Work by yinkeys(m): 5:39am On Nov 12
Continue

1 Like

Re: 3 Key Uses Of Microsoft Excel At Work by numerouno01(m): 7:12am On Nov 12
reminds me of my boss that will be creating excel templates upandan

funny thing is that they are repetitive but in different design. and i must update all

smh grin

2 Likes

Re: 3 Key Uses Of Microsoft Excel At Work by onatisi(m): 7:15am On Nov 12
many will avoid this thread grin grin
op continue jare

7 Likes

Re: 3 Key Uses Of Microsoft Excel At Work by whyx06(m): 7:19am On Nov 12
Thanks op...

Please I need a tutorial on how to use Excel to draw a graph.

1 Like

Re: 3 Key Uses Of Microsoft Excel At Work by wiseboybuska(m): 7:20am On Nov 12
I never knew a thing about Microsoft excel, but now I know. Thanks

1 Like

Re: 3 Key Uses Of Microsoft Excel At Work by barrysome001(m): 7:20am On Nov 12
Ms Excel; One very nice software!

4 Likes

Re: 3 Key Uses Of Microsoft Excel At Work by TEYA: 7:22am On Nov 12
OP we are waiting
Re: 3 Key Uses Of Microsoft Excel At Work by shedy03(m): 7:23am On Nov 12
in electrical engineering designs, excel is used in load calculations and presentation.

1 Like

Re: 3 Key Uses Of Microsoft Excel At Work by designVATExcel: 7:27am On Nov 12
whyx06:
Thanks op...

Please I need a tutorial on how to use Excel to draw a graph.


I assume you already have the data?
If yes, use the bolded part of the URL below
https://youtu.be/eMEhjbhtfxQ)

Btw Thanks to the mod that pushed this to FP. Muchas Gracias...

2 Likes 1 Share

Re: 3 Key Uses Of Microsoft Excel At Work by wickyyolo: 7:38am On Nov 12
Nowadays you can easily create an app that can do whatever office excel can do.

4 Likes

Re: 3 Key Uses Of Microsoft Excel At Work by vedaxcool(m): 7:45am On Nov 12
God please help nairalanders have some brain and read threads like this which will help them improve their career and life.

3 Likes

Re: 3 Key Uses Of Microsoft Excel At Work by designVATExcel: 7:50am On Nov 12
wickyyolo:
Nowadays you can easily create an app that can do whatever office excel can do.

Lol if you are into app development you'll know there's nothing "easy" about creating Apps. Excel beats app creation in 3 ways:

1) Affordability: App design is expensive, most Startups & SMEs in Naija, still struggle to cover more pressing business needs & don't have funds to hire a software developer.

2) Flexibility: Excel can perform a whole lot functions, there's no single App that is even half way close to meeting this.
Applications are usually designed to solve a SINGLE need. Excel solves MULTIPLE needs seamlessly.

3) Availability: Excel is very available. Almost any laptop/ PC you buy has it preinstalled (trial / full version). This makes it convenient to use. You don't need to consult anyone to get it.

My opinion sha o.

24 Likes 5 Shares

Re: 3 Key Uses Of Microsoft Excel At Work by Rexphobia(m): 7:50am On Nov 12
Auditing data embarassed

3 Likes

Re: 3 Key Uses Of Microsoft Excel At Work by crazygod(m): 7:51am On Nov 12
All true. But I think access stores database more efficiently than excel. Both are easy to use sha
Re: 3 Key Uses Of Microsoft Excel At Work by LOVEGINO(m): 7:55am On Nov 12
Heheehehehe! See them dey run lipsrsealed going after meaningless trend.

1 Like

Re: 3 Key Uses Of Microsoft Excel At Work by hopsydboi(m): 7:58am On Nov 12
Excel is the real deal, it indeept knowledge alone can get you a good job.
Power querry, pivot table & charts, vlookup, pivot dashboard... You are g2g!

5 Likes

Re: 3 Key Uses Of Microsoft Excel At Work by Nobody: 8:07am On Nov 12
It can also be used to solve questions on statistics like standard deviation

1 Like 1 Share

Re: 3 Key Uses Of Microsoft Excel At Work by youngelder(m): 8:10am On Nov 12
wickyyolo:
Nowadays you can easily create an app that can do whatever office excel can do.

excel can be automated using VBA codes and macros.

Bros, excel sweet... I no even mention Ms access. that's another powerful tool

5 Likes 1 Share

Re: 3 Key Uses Of Microsoft Excel At Work by shogz89: 8:14am On Nov 12
hopsydboi:
Excel is the real deal, it indeept knowledge alone can get you a good job.
Power querry, pivot table & charts, vlookup, pivot dashboard... You are g2g!
concatenate, duplicate values, h lookup, conditional formatting, text to columns I don't think one person can know the full functions of excel cos it cut across different professions. Accounting, engineering etc.

2 Likes

Re: 3 Key Uses Of Microsoft Excel At Work by Tivgal: 8:14am On Nov 12
Use it for PIT assessments so sweet. I even install it on my phone for easy budgeting.
Re: 3 Key Uses Of Microsoft Excel At Work by Seequadry(m): 8:18am On Nov 12
Have ve been feeding, clothing and sponsoring myself from wat am earnings through excell for the past 6years

I will forever be grateful to Microsoft for this wonderfull application...

6 Likes

Re: 3 Key Uses Of Microsoft Excel At Work by hopsydboi(m): 8:20am On Nov 12
shogz89:
concatenate, duplicate values, h lookup, conditional formatting, text to columns I don't think one person can know the full functions of excel cos it cut across different professions. Accounting, engineering etc.
I agree with you... You can only know as much as you need!
Re: 3 Key Uses Of Microsoft Excel At Work by wickyyolo: 8:22am On Nov 12
youngelder:


excel can be automated using VBA codes and macros.

Bros, excel sweet... I no even mention Ms access. that's another powerful tool

I have used those applications, but it just they cannot be used in real time.

I want to be in St Petersburg and check information of my old and new staffs in real time as information are uploaded
Re: 3 Key Uses Of Microsoft Excel At Work by godfatherx: 8:34am On Nov 12
This is my area of strength
Re: 3 Key Uses Of Microsoft Excel At Work by Nyerhovwo101(m): 8:46am On Nov 12
Tutorial
Re: 3 Key Uses Of Microsoft Excel At Work by biggerboyc(m): 9:04am On Nov 12
Ok
Re: 3 Key Uses Of Microsoft Excel At Work by Crativjosh(m): 9:08am On Nov 12
Are u available to tutor ?
Seequadry:
Have ve been feeding, clothing and sponsoring myself from wat am earnings through excell for the past 6years

I will forever be grateful to Microsoft for this wonderfull application...

Re: 3 Key Uses Of Microsoft Excel At Work by ThundrCork(m): 9:15am On Nov 12
cool
Re: 3 Key Uses Of Microsoft Excel At Work by obonujoker(m): 9:52am On Nov 12
Excel is also used for numerical analysis.... especially for ODEs and PDEs....
Re: 3 Key Uses Of Microsoft Excel At Work by fcacfc(m): 10:16am On Nov 12
Seequadry:
Have ve been feeding, clothing and sponsoring myself from wat am earnings through excell for the past 6years

I will forever be grateful to Microsoft for this wonderfull application...


bro
good morning....I am an accounting graduate....still job hunting.....can you be of help tutoring me on excel or help with d material

I reside in lag

thanks

1 Like

(0) (1) (2) (3) (Reply)

5 Career Jobs To Avois As An Introvert / The 10 Skills That Will Get You Hired In 2013 / Is It Good To Tell Your Boss You Are Resigning Or Take Your Salary And Leave?

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (0) (1) (2) (3) (4) (5) (6) (7) (8) (9)

Nairaland - Copyright © 2005 - 2017 Oluwaseun Osewa. All rights reserved. See How To Advertise. 94
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.