Duration

Course Outline:

• Introduction, practical use and basic components of Microsoft Excel.
• Open a new, blank workbook.
• Base a new workbook on an existing workbook and on a template.
• Create and edit your own templates.
• What is the office backstage view and what can you do with it?
• Preview worksheets before printing.
• Printing worksheets and workbooks.

Formatting data:

• How to enter, format, edit and view data.
• Copy and moving data.
• How to change the format of numbers?
• How to apply Conditional formatting.
• How to select, navigate and manage worksheets.
• How to add supporting comments in cells.

Managing data and workbooks:

• Introduction to managing data.
• Importing/Exporting data from/to a text file.
• Overview of text import wizard.
• Usage of charts and steps for drawing up charts.
• Types, elements and modification of charts.
• How to find, edit and refresh existing data connections.
• Exchanging or exporting data with different data sources and from excel to word.

Introduction to Microsoft Word:

• Introduction and practical use of Microsoft word.
• Creating and saving a document.
• Page numbers, headers and footers.
• Page breaks and section breaks.
• Page setup.
• Office backstage view of Microsoft word.
• Printing a document.

Formatting, Illustrations and Tables:

• Formatting includes styles, fonts, paragraph settings and sorting lists alphabetically.
• Illustrations includes pictures & clip art, Shapes, Charts, Text boxes, Wordart.
• Creation, editing and deletion of table.

Instructor Name:

Israr ahmad is an accountant at Information technology university of the Punjab. He has more than 7 years of experience of using microsoft excel and microsoft word at different corporate levels. Israr ahmad holds a master’s degree (M.COM) in accounting & finance from university of central Punjab. After this, he completed his certificate named Assessment of fundamental competencies from ICAP, formerly known as CA foundation. In addition, he has worked as freelancer and completed more than 200 projects related to financial analysis, microsoft excel and business plans. His primary goal is to provide a positive and respectful learning environment where he can guide individuals to develop a new skill set, embrace challenges and go beyond their own expectations.