P.p.docx

PROFESSIONAL PRACTICES

A Guide to Microsoft Excel GROUP MEMBERS

M. Abdullah Rashid` M. Majid Zoya

15091519-020 15091519-054 15091519-148

Faculty of Computer Science & Information Technology University of Gujrat

Topic:

A Guide to Microsoft Excel Introduction Microsoft Excel spreadsheet software has become an integral part of most business organizations across the world.MS Excel is used for various purposes by business establishments. Some organizations use this spreadsheet software for generating memos, track sales trends, and other business data. It’s important to understand why Microsoft Excel has become such a valuable and ubiquitous tool in the business World. Microsoft Excel is extremely valuable for business, which use it to record expenditures and income, plan budgets, chart data and succinctly present fiscal results.

What we will do: Provide complete guidelines about use of MS Excel. o Introduction o Why and where Microsoft Excel skills are important? o Exceptional uses of Microsoft Excel (In work place, In business organization, In home). o Use MS Excel in finance and Accounting. o How to work with multiple worksheets in Microsoft Excel.

o Change the appearance of worksheet data by using a variety of formatting techniques. o Create formulas by using some of Excel's built-in functions. o Plan, create and modify charts Etc. o

Guidelines for the certification of the MOS Exam.

Outcomes The students who want to gain expertise in Microsoft Excel and who want to become the part of business organization this session will be beneficial for them. Also, those students who want to pass the MOS exams, this session is the guideline for them. After that you are able to manipulate, manage and analyze data helping assist in decision making and creating efficiencies that will directly affect your bottom line. Whether you’re using it for business or to help manage personal database and expenses Microsoft Excel gives you the right tools to enable you to accomplish all your needs.

Generation of idea We spent 16 hours for the generation of idea and finalize this idea because this idea is beneficial for people of many fields like students, Teachers, Businessmen etc. We studied different ideas like how to going abroad for further studies, how to manage time, how to work as a team member. But we throw down these ideas and finally choose this idea. After spending much time on this nominated idea, we get the basic understanding of this topic and create our contents.