Nitin Nayan

Years of Experience in Microsoft Excel Training classes

10

Teaching Experience in detail in Microsoft Excel Training classes

MS OFFICE Sl no Topic to be Covered 1 Overview of MS-Office Application and their usage – 30 min 2 MS-Word- Font formatting – Font effects and Character spacing Paragraph formatting (indentation, line/para spacing) Bullets and numbers, using toolbar, menu and shortcut keys,1hr 3 MS-Word- Working with tables-insert & draw, table properties (Table, Column, Row Cell) options of cells, Repeat heading row/column, text directions, border and shading 30 min 4 MS-Word- Header footer- images, drawing tools, Smart art, Page numbering, Creation of different section in a word file(Page / section breaks), Linking/breaking Previous link of header and footer in next sections, Header footer for Letter Pad, Different header/footer for different sections in a file; Exercises- A single MS-Word file shall have a Letter PAD, Enclosures –I,II…, Annexure-1,2…, Appendix-A,B… shading 01 hr 5 MS-Word- Fields expressions insertion, updation view code for fields (e.g. for page numbering, numpages, section pages, if statement etc), insertion of content table and updating, Resetting of page number at start of every sections. 1hr 30 min Working with columns in same page, protecting documents, Mail merge(Printing Letters, envelope, labels etc using excel datasheet or MS-Word table as database), and window options. 1hr 30 min 06 MS-Excel Introduction to excel, formatting text, Insertion & deletion of Cell(s), Row(s), Column(s) and Sheet(s), Renaming of sheet., Type of addressing (relative and absolute), 1hr 30 min 07 MS-Excel Conditional formatting, using formulae (IF, Sum Avg, Count, Max, Min, concatenate and other string functions, working with charts.Working with data, filter, sorting, sub-totals, Sheet links, freezing panes, split windows, arrange windows, arrange windows, Page setup, Print Area, Repeat row at Top, Repeat column to Left 1hr 30 min 08 MS-Outlook Introduction to Outlook, configuration & Settings, Type of Mail services POP3, IMAP and SMTP Mail functions-Create new mail, send /receive mail, reply / forward mail etc Contacts Functions-add, deletemodify, export & import contacts Calendar – create / Manage events, dairy. Sharing of calendar Tasks- - create manage tasks, set reminders/recurrence Appointments – create / manage appointments Contacts – create / manage contacts3hr