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.

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)

what of microsoft access

Wow... I would love to be perfect in the use/application of Excel.

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.

is it like this one?

whyx06:
Thanks op...

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

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?

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>

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.

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

Verified Cash Network CPA Account Needed Contact Me Via Whatsapp @ 07062235480 If You Have.

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.

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.

designVATExcel:


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

Not in real time though

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

One of the better threads on Nairaland in recent times.

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 !

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.

Pls,who will train on computer and its applications? I reside in Surulere and willing to pay though na small money o

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.

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

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.

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?

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

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

eldee365:
Boss, you are into freelancing?
How do you feed with excel, i like to know!
Gracias

Exactly, same here!

You can't know everything about Excel; it's too wide and a wonderful software

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.

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

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

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

pls kindly send d excel ebook to me. i need it too. thanks.
kcnoble3@gmail.com

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