₦airaland Forum

Welcome, Guest: Join Nairaland / LOGIN! / Trending / Recent / New
Stats: 1,928,018 members, 3,969,954 topics. Date: Friday, 15 December 2017 at 01:50 AM

3 Key Uses Of Microsoft Excel At Work - Career (1) - Nairaland

Nairaland Forum / Nairaland / General / Career / 3 Key Uses Of Microsoft Excel At Work (15536 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)

Re: 3 Key Uses Of Microsoft Excel At Work by fcacfc(m): 10:18am On Nov 12
designVATExcel:
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


pls I am an accounting graduate....I need to know excel...how can u help.... I will prefer the material.
Re: 3 Key Uses Of Microsoft Excel At Work by wonlasewonimi: 10:36am On Nov 12
fcacfc:



pls I am an accounting graduate....I need to know excel...how can u help.... I will prefer the material.

You don't need anyone to teach you. You have a laptop with MS Office, I will gladly provide you with a book that will teach you step by step (if you cant afford to stream YouTube)

3 Likes

Re: 3 Key Uses Of Microsoft Excel At Work by Kokaine(m): 10:44am On Nov 12
what of microsoft access
Re: 3 Key Uses Of Microsoft Excel At Work by kmaxx(m): 10:44am On Nov 12
Wow... I would love to be perfect in the use/application of Excel.

1 Like

Re: 3 Key Uses Of Microsoft Excel At Work by kmaxx(m): 10:46am On Nov 12
wonlasewonimi:


You don't need anyone to teach you. You have a laptop with MS Office, I will gladly provide you with a book that will teach you step by step (if you cant afford to stream YouTube)


This book, is it a soft copy? 'cause I would love to have access to one.
Re: 3 Key Uses Of Microsoft Excel At Work by phemoluv02(m): 11:18am On Nov 12
is it like this one?
whyx06:
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 wonlasewonimi: 11:20am On Nov 12
kmaxx:



This book, is it a soft copy? 'cause I would love to have access to one.

Yeah..Who reads hard copy of books these days?
Re: 3 Key Uses Of Microsoft Excel At Work by kmaxx(m): 11:41am On Nov 12
wonlasewonimi:


Yeah..Who reads hard copy of books these days?


Lol.

I still do, and I know I am not alone.
So, how do I get a copy of the book?

.

.

<kmax4real@gmail.com>
Re: 3 Key Uses Of Microsoft Excel At Work by YemziAdez(m): 11:47am On Nov 12
wonlasewonimi:


You don't need anyone to teach you. You have a laptop with MS Office, I will gladly provide you with a book that will teach you step by step (if you cant afford to stream YouTube)


Hi, good morning.

Please, I'm also very much interested in the e-book on how to make use of ms-excel.

I'll be super-excited if you can kindly send it to me via email (yemiadetimehin@gmail.com).

Many thanks for your kind attention.


Lest I forget, nice one Op.

1 Like

Re: 3 Key Uses Of Microsoft Excel At Work by fcacfc(m): 11:52am On Nov 12
wonlasewonimi:


You don't need anyone to teach you. You have a laptop with MS Office, I will gladly provide you with a book that will teach you step by step (if you cant afford to stream YouTube)


thanks , I can't afford to stream on YouTube.....I av a small lappy ..I av learnt some basic excel stuffs like calculation,subtraction,multiplication, plotting some graphs,


so I need sth related to accounting.....


I will be glad if you can help me with d book
Re: 3 Key Uses Of Microsoft Excel At Work by drmingler(m): 12:01pm On Nov 12
Verified Cash Network CPA Account Needed Contact Me Via Whatsapp @ 07062235480 If You Have.
Re: 3 Key Uses Of Microsoft Excel At Work by designVATExcel: 12:42pm On Nov 12
crazygod:
All true. But I think access stores database more efficiently than excel. Both are easy to use sha

True to some extent, particularly as you mentioned, with regards to storage.
I love ms Access, the forms are also more user friendly.
That said, Excel offers so much more particularly in terms of data anaylsis. Most Relational databases still import data to Excel to be analyzed.
Re: 3 Key Uses Of Microsoft Excel At Work by designVATExcel: 12:46pm On Nov 12
wickyyolo:


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

With One Drive you can do that. The only limit is multi-user functionality.
Re: 3 Key Uses Of Microsoft Excel At Work by wickyyolo: 12:55pm On Nov 12
designVATExcel:


With One Drive you can do that. The only limit is multi-user functionality.

Not in real time though
Re: 3 Key Uses Of Microsoft Excel At Work by sheffy87: 12:58pm On Nov 12
wonlasewonimi:


You don't need anyone to teach you. You have a laptop with MS Office, I will gladly provide you with a book that will teach you step by step (if you cant afford to stream YouTube)


please bro I will also love to ve d e book on excel....thanks
email :oyekanmisheriff74@gmail.com
Re: 3 Key Uses Of Microsoft Excel At Work by careerpluzz: 1:02pm On Nov 12
One of the better threads on Nairaland in recent times.

1 Like

Re: 3 Key Uses Of Microsoft Excel At Work by noob03saibot(m): 1:09pm 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!
I swear your head dey there. A friend of mine once failed a job interview because he didn't know jack about excel, and the salary they were offering was good.
Re: 3 Key Uses Of Microsoft Excel At Work by ganie(m): 1:09pm On Nov 12
Pls,who will train on computer and its applications? I reside in Surulere and willing to pay though na small money o
Re: 3 Key Uses Of Microsoft Excel At Work by designVATExcel: 1:15pm On Nov 12
ganie:
Pls,who will train on computer and its applications? I reside in Surulere and willing to pay though na small money o

Your request is abit vague, which application in particular?
Youtube has excellent user paced videos. If i know more i can provide some links.
Re: 3 Key Uses Of Microsoft Excel At Work by ganie(m): 1:20pm On Nov 12
designVATExcel:


Your request is abit vague, which application in particular?
Youtube has excellent user paced videos. If i know more i can provide some links.
Basically desktop publishing, Ms word, excel and power point
Re: 3 Key Uses Of Microsoft Excel At Work by designVATExcel: 1:38pm On Nov 12
ganie:

Basically desktop publishing, Ms word, excel and power point

For Excel, my personal favorite is - Excelisfun; https://www.youtube.com/user/ExcelIsFun/playlists - he has several playlists covering different uses of Excel (Accounting, HR, Formulas, etc.)

For Word, except your profession requires some sort of publishing (where mail merge, change tracking, forms, footnotes or TOC is required) , you can learn by playing around with the application.
While tutorial videos exist, you can try Simon Sez it; https://www.youtube.com/user/simonsezittraining/playlists

Desktop publishing - many applications can be used here, at the basic level some people even use Ms word or Power-point. Would recommend Illustrator or Photoshop (most popular). Not really my field so can't recommend here, sorry.

Hope that helps. There's so much material online now, in fact too much material.

2 Likes 1 Share

Re: 3 Key Uses Of Microsoft Excel At Work by eodavids(m): 2:04pm On Nov 12
designVATExcel:
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

Thank you for this timely piece.

Iam familiar with 'word' but not with Excel. I had never paid serious attention to Microsoft Excel, until now that I have business-related tabular work to be performing.

Pls, can you guide me on how I can colonize Microsoft Excel and perform the functions?
Re: 3 Key Uses Of Microsoft Excel At Work by ganie(m): 2:27pm On Nov 12
designVATExcel:


For Excel, my personal favorite is - Excelisfun; https://www.youtube.com/user/ExcelIsFun/playlists - he has several playlists covering different uses of Excel (Accounting, HR, Formulas, etc.)

For Word, except your profession requires some sort of publishing (where mail merge, change tracking, forms, footnotes or TOC is required) , you can learn by playing around with the application.
While tutorial videos exist, you can try Simon Sez it; https://www.youtube.com/user/simonsezittraining/playlists

Desktop publishing - many applications can be used here, at the basic level some people even use Ms word or Power-point. Would recommend Illustrator or Photoshop (most popular). Not really my field so can't recommend here, sorry.

Hope that helps. There's so much material online now, in fact too much material.
Thanks boss
Re: 3 Key Uses Of Microsoft Excel At Work by eldee365: 3:06pm 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...

Boss, you are into freelancing?

How do you feed with excel, i like to know!

Gracias
Re: 3 Key Uses Of Microsoft Excel At Work by preciousnobel(m): 4:21pm On Nov 12
eldee365:
Boss, you are into freelancing?
How do you feed with excel, i like to know!
Gracias
Exactly, same here!
Re: 3 Key Uses Of Microsoft Excel At Work by walexy100: 4:42pm On Nov 12
You can't know everything about Excel; it's too wide and a wonderful software

1 Like

Re: 3 Key Uses Of Microsoft Excel At Work by naijacartoon: 5:23pm On Nov 12
crazygod:
All true. But I think access stores database more efficiently than excel. Both are easy to use sha
i have to quickly pin point this, excel is a spread sheet package while access is a database package.
Re: 3 Key Uses Of Microsoft Excel At Work by sean079: 5:48pm On Nov 12
wonlasewonimi:


You don't need anyone to teach you. You have a laptop with MS Office, I will gladly provide you with a book that will teach you step by step (if you cant afford to stream YouTube)

Bro, I need the material also oludareolaniyi@yahoo.com and d1reloaded@gmail.com .thanks
Re: 3 Key Uses Of Microsoft Excel At Work by splendid2: 7:41pm On Nov 12
Pls help me with dt excell e-book. Excel is abt opening my yansh in my new job. Thank God for this your topic.
splenaija@yahoo.com
Re: 3 Key Uses Of Microsoft Excel At Work by preciousman(m): 8:48pm On Nov 12
wonlasewonimi:



You don't need anyone to teach you. You have a laptop with MS Office, I will gladly provide you with a book that will teach you step by step (if you cant afford to stream YouTube)
please bro I will like to get the book on excel also.Here is my email:preciousopoggen@gmail.com
Re: 3 Key Uses Of Microsoft Excel At Work by automaticgates(m): 9:21pm On Nov 12
pls kindly send d excel ebook to me. i need it too. thanks.
kcnoble3@gmail.com
Re: 3 Key Uses Of Microsoft Excel At Work by onatisi(m): 9:31pm On Nov 12
designVATExcel:


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.
very correct . but i think google too has a similar app

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

Microsoft Nigeria Sacks 34 Workers In Phone Division (Out of 40) / 5 Career Jobs To Avois As An Introvert / The 10 Skills That Will Get You Hired In 2013

(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. 149
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.