Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,194,291 members, 7,954,160 topics. Date: Friday, 20 September 2024 at 01:23 PM

Post All Your Microsoft Excel Problems Here - Computers - Nairaland

Nairaland Forum / Science/Technology / Computers / Post All Your Microsoft Excel Problems Here (3928 Views)

Post Your Laptop Problems Here And Get Solution To Fix It Yourself / Post All Laptops And Gadgets Related Problems For Quick Response And Solutions / 5 Selection Methods To Fire Up Your Microsoft Word Skills (2) (3) (4)

(1) (Reply) (Go Down)

Post All Your Microsoft Excel Problems Here by designVATExcel: 5:55pm On May 20, 2016
Hi guys,

Though just recently registered, i'm here to solve all (if possible) your Microsoft Excel problems - so just
- Post any questions you might have
- Templates you need assistance designing, bla bla bla

I'll offer some service free.
I observed that Nigeria has a lot of SMEs - Organisations that cannot afford to purchase relational database management systems like Oracle, SQL etc, or the expertise to use the freeware like MYSQL. Most result to using Microsoft Excel, but are oblivious to its numerous features, uses etc.

Interactive Dashboards (one of the coolest features of Excel) can be created for:
1) Accounting - (Company Budgets, Financial Projections, Store Inventory management, ...
2) Human Resources - Employee details, Payroll Management, Leave, Absenteeism records, ...
3) Clinical Records - Patient Records, Clinical notes management, Medication inventory, automatic prescription sheets, ...
4) Statistical Analysis - Analyse surveys, questionnaries, ...
5) Forms- Design data entry forms,

Interestingly, all these can be designed in Excel and customized to your company specification with logos etc.
The video link below shows some of this functionality.


https://www.youtube.com/watch?v=w3P4CkG_Qqo

I await your questions cool
Re: Post All Your Microsoft Excel Problems Here by Bonethugss: 6:00pm On May 20, 2016
If i want a one designed for my company, you fit do am free
Re: Post All Your Microsoft Excel Problems Here by designVATExcel: 6:01pm On May 20, 2016
Bonethugss:
If i want a one designed for my company, you fit do am free

Whats the nature of your company and what type of template do you want designed?
I can do a basic one free na, that's the point of my post.
Re: Post All Your Microsoft Excel Problems Here by chinkichun: 6:45pm On May 20, 2016
Thanks for your kind gesture... can you send me a good project management template?
Re: Post All Your Microsoft Excel Problems Here by rose54321: 12:51am On May 21, 2016
chinkichun:
Thanks for your kind gesture... can you send me a good project management template?

hmmm
Re: Post All Your Microsoft Excel Problems Here by designVATExcel: 12:56am On May 21, 2016
chinkichun:
Thanks for your kind gesture... can you send me a good project management template?

No problem, i assume you need the template to track the various stages of a project, is there any particular need you want the template to meet, or you just need a generic template designed.
Re: Post All Your Microsoft Excel Problems Here by chinkichun: 8:28am On May 22, 2016
designVATExcel:


No problem, i assume you need the template to track the various stages of a project, is there any particular need you want the template to meet, or you just need a generic template designed.

Thanks for your response, I need the template to show items like planned work done, actual work done, issues/ over due task... mostly generic. I'd prefer something like the excel project management template (dashboard) from chandoo

Please send it to my email: ohikhena27@gmail.com

I really appreciate. Regards
Re: Post All Your Microsoft Excel Problems Here by chinkichun: 8:29am On May 22, 2016
rose54321:


hmmm

What's up? Any issue?
Re: Post All Your Microsoft Excel Problems Here by franashi(f): 3:41pm On May 22, 2016
designVATExcel:
Hi guys,

Though just recently registered, i'm here to solve all (if possible) your Microsoft Excel problems - so just
- Post any questions you might have
- Templates you need assistance designing, bla bla bla

I'll offer some service free.
I observed that Nigeria has a lot of SMEs - Organisations that cannot afford to purchase relational database management systems like Oracle, SQL etc, or the expertise to use the freeware like MYSQL. Most result to using Microsoft Excel, but are oblivious to its numerous features, uses etc.

Interactive Dashboards (one of the coolest features of Excel) can be created for:
1) Accounting - (Company Budgets, Financial Projections, Store Inventory management, ...
2) Human Resources - Employee details, Payroll Management, Leave, Absenteeism records, ...
3) Clinical Records - Patient Records, Clinical notes management, Medication inventory, automatic prescription sheets, ...
4) Statistical Analysis - Analyse surveys, questionnaries, ...
5) Forms- Design data entry forms,
Interestingly, all these can be designed in Excel and customized to your company specification with logos etc.
The video link below shows some of this functionality.


https://www.youtube.com/watch?v=w3P4CkG_Qqo

I await your questions cool
Good afternoon Sir,please,I need your favour.i would like you to send me materials on Microsoft Excel for tutorial on how to use the features,expecially on how to use interactive dashboard.i would appreciate it a lot.thank you.
my email address is francesashioma2@gmail.com.
Re: Post All Your Microsoft Excel Problems Here by designVATExcel: 8:18pm On Jul 10, 2016
franashi:

Good afternoon Sir,please,I need your favour.i would like you to send me materials on Microsoft Excel for tutorial on how to use the features,expecially on how to use interactive dashboard.i would appreciate it a lot.thank you.
my email address is francesashioma2@gmail.com.



Hello there,
I can send you tutorial videos free, though it covers overall functionalities of Excel - Intermediate level, doesn't specialise in dashboards.
Re: Post All Your Microsoft Excel Problems Here by designVATExcel: 3:29am On Jul 15, 2016
franashi:

Good afternoon Sir,please,I need your favour.i would like you to send me materials on Microsoft Excel for tutorial on how to use the features,expecially on how to use interactive dashboard.i would appreciate it a lot.thank you.
my email address is francesashioma2@gmail.com.


Check your email, I've directed someone to send the tutorial videos requested.
Re: Post All Your Microsoft Excel Problems Here by optimised: 10:40pm On Jul 30, 2016
Is there a way of exporting or copying an entire Excel sheet from one file to another. So far, I have only seen how to copy or duplicate a sheet within one excel file?
Re: Post All Your Microsoft Excel Problems Here by engrrichie92(m): 2:47am On Jul 31, 2016
designVATExcel:



Hello there,
I can send you tutorial videos free, though it covers overall functionalities of Excel - Intermediate level, doesn't specialise in dashboards.


would need the videos too ..please forward to my mail mrbizguy6736@gmail.com

plus help me out with this, trying to use vlookup to get names from one sheet on another sheet containing account selected account numbers in another sheet.. but i can seem to get the syntax right
please help me out
Re: Post All Your Microsoft Excel Problems Here by Chrisx1x(m): 12:45pm On Jul 31, 2016
designVATExcel:



Hello there,
I can send you tutorial videos free, though it covers overall functionalities of Excel - Intermediate level, doesn't specialise in dashboards.

pls i also need it.i will appreciate if you can send the materials to me on Ajarichris@gmail.com.
Re: Post All Your Microsoft Excel Problems Here by designVATExcel: 2:41pm On Aug 04, 2016
engrrichie92:


would need the videos too ..please forward to my mail mrbizguy6736@gmail.com

plus help me out with this, trying to use vlookup to get names from one sheet on another sheet containing account selected account numbers in another sheet.. but i can seem to get the syntax right
please help me out


would you be able to send the worksheet to an email address so i can look at it?
Or should i send a link to a video showing how to perform vlookup operations.
Re: Post All Your Microsoft Excel Problems Here by designVATExcel: 3:18pm On Aug 04, 2016
optimised:
Is there a way of exporting or copying an entire Excel sheet from one file to another. So far, I have only seen how to copy or duplicate a sheet within one excel file?

Pardon the delay,
Attached is a no audio video i created showing the process of exporting/ copying an Excel sheet to another file.
Hope this helps smiley


https://www.youtube.com/watch?v=CDh7MNg0k9A
Re: Post All Your Microsoft Excel Problems Here by engrrichie92(m): 9:11pm On Aug 04, 2016
designVATExcel:


would you be able to send the worksheet to an email address so i can look at it?
Or should i send a link to a video showing how to perform vlookup operations.

i would prefer the latter..thank you sir
Re: Post All Your Microsoft Excel Problems Here by designVATExcel: 5:21pm On Aug 11, 2016
engrrichie92:


i would prefer the latter..thank you sir

Sent
Re: Post All Your Microsoft Excel Problems Here by designVATExcel: 7:36pm On Nov 03, 2016
Hmm, is it that most Nairalanders don't use Excel.

Anywho below is a new template: Weekly Events Tracker, what do you guys think?

Pretty nice eh..

Kindly comment, all feedback is appreciated (+ & -)


https://www.youtube.com/watch?v=VQUHVlJD-Eo&feature=youtu.be

1 Like

(1) (Reply)

Is All About Free Browser With Mtn / Very Clean Hp Elitebook Revolve 810 G3 Core I5 8gb Ram / SOLD Nitro 5 i7 9th gen laptop RTX 2060 6gb Nvidia

(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: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

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