Course Description:-

INTRODUCTION:

Having the knowledge of Microsoft office 2013 is must for any working professional. This MS Office 2013 Bundle is a comprehensive course on learning all the features & functionalities of Microsoft Bundle

We bring this comprehensive bundle which will teach you the nuts & bolts of each function. This online course is easy to learn with full of Practical examples. This course begins with Microsoft Excel 2013. 

Some of the topics that you will be learning in excel are as follows:

• Data Entry, formulas, functions, calculations and formatting in Excel 2013
• Graphs & Charts in Excel 2013
• Shortcuts
• Common errors in Excel 2013
• Functions for Working with Text
• Excel 2013 – Pivot Table and Pivot charts
• Names and Dynamic Range
• Auditing and Trouble Shooting Formulas
• Important Excel Tools
• Excel 2013 – Charts & Graphs
• Excel 2013 – Excel Dashboard
• Assigning Macros to Buttons to Navigate and Dashboard
• Financial functions using Excel

Moving forward we will also learn about:

• Microsoft Outlook
• Powerpoint
• Word
• OneNote
• Microsoft Access

MOS on Microsoft Office 2013 the pre-requisites for the course:

• Passion to learn about Microsoft Bundle.
• A computer with internet to view training material
• Any beginner can take this course as this course starts from Scratch for each module

What am I going to get from this MOS on Microsoft Office 2013 course?

• Learn various functions 7 formulas of excel 2013 along with Graphs & Charts.
• Learn Microsoft word from Basic to Advanced level
• Learn Microsoft Powerpoint from Basic to Advanced level.
• Learn what is OneNote and how to use it.
• Learn Outlook and Access in detail

Who should take up this MOS on Microsoft Office 2013 course?

• Students, MBA’s, BBA’s, Gradates & Post- graduates.
• Working Professionals from any business domain.
• Entrepreneurs, Prospective Finance Analyst, Market Analyst, Research Analyst, Investment Banker
• Anyone interested in more powerful features and functions of Microsoft 2013

Benefits of online course:

• High Quality Content
• Learn Anywhere Anytime & at Your Pace
• 24X7 Customer Support
• Complete Student Support Throughout The Program
• Course Completion Certificate 
• Lifetime course access

For any query feel free to call

Mob - 8587999769/9818826705

CURRICULUM

Section 1: Microsoft Excel 2013

1. Overview
2. Opening Excel
3. Familiarity with excel interface and Ribbons
4. Surfing an excel worksheet and How to use HELP in MS Excel
5. Case Study
6. Data entry in excel
7. Populating the Case Study in Excel
8. Calculations
9. Formulas – part 1
10. Formulas – part 2
11. Formatting Number formats
12. Formatting Table formats
13. Updating a Calculation
14. Percentages and Absolute References
15. Conditional Formatting
16. IF Function
17. COUNTIF
18. SUMIF
19. Graphs and Charts Part 1
20. Graphs and Charts Part 2
21. Graphs and Charts Part 3
22. Pie Chart
23. Sort function
24. Filter Function
25. Pivot table Part 1
26. Pivot table Part 2
27. Freeze and Split
28. Table Formats
29. Indents and Formatting Charts
30. Printing the Worksheet
31. Print Layout
32. Shortcuts Part 1
33. Shortcuts Part 2
34. Shortcuts Part 3
35. Shortcuts Part 4
36. Shortcuts Part 5
37. Shortcuts Part 6
38. Common errors
39. Paste Special
40. Logical fucnitons IF and OR
41. Arithmetic Functions
42. Aggregation Functions
43. Cell Information Functions
44. Choose Function
45. Vlookup
46. Hlookup and Sum product
47. Hlookup and Sum product Continues
48. Match Index
49. Database Functions
50. Forecasting Function
51. One Dimensional Data Table
52. Two Dimensional Data Tables
53. Solver
54. Goal Seek
55. Arrays Introduction Part 1
56. Arrays Introduction Part 2
57. Arrays Rows and Coloumns
58. Arrays Transpose
59. Arrays Frequency
60. Text and String Functions Part 1
61. Text and String Functions Part 2
62. Data Formatting
63. Creating Pivot Table
64. Recommended Data Table
65. Pivoting Pivot Table
66. External Data
67. Consolidation Sheets
68. Managing Pivot Table
69. Totals Display
70. Summary Display
71. Multiple Data Field
72. Data Grouping
73. Drill Down Data
74. Calculated Field
75. Pivot Data Sorting
76. Customised Sorting
77. Limited Data Display
78. Rule Based Sorting
79. Data Slicer
80. Slicer Formatting
81. Filter Area
82. Removing Filters
83. Formatting Pivot Table
84. Layouts In Pivot Table
85. Rule Based Conditional Formatting
86. Top Bottom Rule Based
87. Data Bars
88. Adding Color Scales
89. Icon Indicators
90. Basic Pivot Chart
91. Pivoting Pivot Chart
92. Filter Pivot Chart Data
93. Formatting Pivot Chart
94. Different Chart Types
95. Print Table Part 1
96. Print Table Part 2
97. Print Separate
98. Print Headers
99. First Macro
100. Executingthe Macro
101. Starting With Power Pivot
102. Why Use Power Pivot
103. Adding Table To Power Pivot
104. Creating Relationships Between Tables
105. Pivot TableIn Power Pivot
106. Get External DataIn Power Pivot
107. Introduction To DAX
108. Reference To Dax Functions
109. Adding Calculated Column
110. Adding Calculated Field
111. Introduction To Power View
112. Displaying Data Using Different Controls Part 1
113. Displaying Data Using Different Controls Part 2
114. Formatting Of Controls
115. Filters In Power View
116. Data Display Using Charts In Power View
117. Data Display Using Maps
118. Naming a Cell and a Range
119. Naming Dynamic Ranges
120. Auditing Toolbars
121. Watch Window
122. Text to Columns
123. Grouping Tabs
124. Subtotal Function
125. Hyperlinks
126. Data Validation Part 1
127. Data Validation Part 2
128. Random Numbers
129. Custom View
130. Protecting Worksheet and Workbook
131. Introduction to Excel 2013
132. Excel Chart Concepts
133. Excel Basic Charts
134. Fine Tuning of Charts
135. 04 Changing Chart Options – part 1
136. 04 Changing Chart Options – part 2
137. Column and Line Chart
138. 05 Format Tab Option
139. Pie Diagram
140. Area Chart
141. Doughnut, Bubble and Radar Chart
142. Paste Chart Data
143. Multiple Source Data and Table Chart
144. Basic Dynamic Chart
145. Dynamic Chart with Check boxes
146. Dynamic Pie Chart
147. Pareto Chart
148. Frequency Chart
149. Chart Filter
150. Gantt Chart
151. Advanced dynamic chart
152. Pivot Chart
153. Calculator Chart
154. Map Chart
155. Introduction to Dashboard
156. Concepts of Excel Dashboard
157. Area and Bar Chart
158. 3D Charts
159. Combination Charts
160. Different Types
161. Pivot Table
162. Pivot Chart and Slicer
163. Checkbox
164. Check and Scroll 1
165. Scroll Chart
166. Basic Macro Part 1
167. Basic Macro Part 2
168. Macro Navigation
169. Dashboard End
170. Introduction
171. Understanding Future Value
172. Future Value Continues
173. Calculating Simple and compound Interest
174. SI and CI Continues
175. Understanding PV
176. Calculate NPER and RATE
177. Lender and Borrower FV

Section 2: Microsoft Word 2013

1. Introduction 2013
2. Introduction to Word 2013 and Understanding the Ribbons
3. Backstage View and Quick Access Toolbar 2013
4. Compatibility Mode and Navigation Pane 2013
5. Working with text 2013
6. Selection of Text 2013
7. Find and Replace Text 2013
8. Understanding Fonts 2013
9. Working with Fonts and Applying Basic Formatting 2013
10. Text Effects 2013
11. How to Save a Document 2013
12. Other File Formats 2013
13. Arranging Paper Margins, Paper Orientation and Paper Size 2013
14. Inserting Columns and Page Break up 2013
15. Using Watermarks, Page Colour and Page Borders 2013
16. Checking Spelling and Grammar 2013
17. Using Thesaurus, Word Count and Language Translate 2013
18. Printing a Document 2013
19. Setting Print Options 2013
20. Alignment Justifying and Line Spacing 2013
21. Use of Indents, Tabs and bulleted or Numbering list 2013
22. Demonstrating a Document with Pictures 2013
23. Positioning, Wraping And Re-sizing a Picture 2013
24. Use of Table, Smart art, Charts, Screen Shots 2013
25. Special Effects 2013
26. Customizing a Word and its Ribbons 2013

Section 3: Microsoft Outlook 2013

1. Introduction
2. Types of Email accounts
3. Adding POP,IMAP Account
4. Removing an email account
5. Using Social Connector
6. Reading an E-mail
7. Managing the Inbox looks
8. Adding Columns in inbox
9. Saving and Removing attachments
10. Searching an email
11. Filtering Junk emails
12. Creating and Sending an email
13. Exploring Insert Tab
14. Exploring Insert Tab Part 2
15. Responding E-mails
16. Text Body Formatting
17. Creating E-mail Signature
18. Setting Autoreply by creating Rule
19. Creating Stationary
20. Creating Voting Options in mail
21. Meaning of Address Book
22. Creating New Contact
23. Contact from email
24. Creating Contact Group
25. Working with Categories
26. Searching Contacts in People Hub
27. Creating Contact Folder & Folder Group
28. Forwarding Contact
29. Setting Condition for inbox mails
30. Follow up Flags
31. Assigning Color Category
32. Managing E-mail folders
33. Automate tasks using quick steps
34. Cleanup tools
35. Introduction to Calendar Interface
36. Creating an appointment
37. Meeting Invitation
38. Creating meeting through mail
39. Responding meeting invitation
40. Creating Calendar Group
41. Emailing and Printing your calendar
42. Creating and Assigning Tasks
43. Working with electronic sticky notes
44. Creating Backup File
45. Customizing outlook settings
46. Conclusion

Section 4: Microsoft PowerPoint 2013

1. Introduction to PowerPoint 2013
2. Uses of PowerPoint 2013
3. Getting started with powerpoint 2013
4. learning the backstage of powerpoint
5. Understanding PowerPoint
6. Formatting a presentation using font color, style
7. Adding Bullets and Numberings
8. Removing background and using eyedroper tool
9. Adding tables and Charts
10. Adding Shapes and Smartart
11. Preparing your PPT
12. Packaging and saving 2013
13. Keyboard Shortcut 2013
14. Very Usefull and Simple Keyboard Shortcuts
15. Inserting Video, Audio and Hyperlinks PPT 2013
16. Rolling Credits PPT 2013
17. Rotating an object PPT 2013
18. Creating 3D Objects in PPT 2013

Section 5: Microsoft OneNote 2013

1. OneNote Introduction
2. What is One Note
3. Launching One Note
4. Understanding the interface
5. Sharing Notebook
6. Sharing Notebook- Properties
7. Creating a New Notebook
8. Adding New Sections
9. Working with Pages and Sub-pages
10. Creating a Note
11. Sending Content to One Note
12. Copy data from PDF
13. Screen Clipping
14. Adding Images
15. Adding Media Files
16. Inserting Excel Sheets
17. Adding Equations & Symbols
18. Formatting Text
19. Using Styles
20. Bullets & Numbering
21. Spell Check & Auto Correct Options
22. Customizing the Interface
23. Search Option
24. Uses of Tags
25. Adding new Templates
26. Creating a New Template
27. Making a default template for a Section
28. Page setup
29. Adding Graphics to Background
30. Inserting a Table
31. Inserting Rows & Columns
32. Formatting the Table
33. Converting Table to Excel Spreadsheet
34. Using OneNote Draw Option
35. Converting Handwriting to Text
36. Changing Handwriting and Shapes
37. Ink to Math option
38. Interacting with Outlook
39. Sending Page Information by email
40. Outlook Tasks
41. Saving to other Formats
42. Saving Notebook to PDF Format
43. Saving Notebook on SkyDrive
44. Inviting others
45. Creating a shared link
46. Syncing the Notebook
47. Author Indicators
48. Identifying Recent changes
49. Page Versions
50. Quick access toolbar & Ribbon changes
51. Email Option changes
52. Setting up Password
53. Backup Options for Notebook

Section 6: Learn Microsoft Access 2013

1. Introduction to Microsoft Access
2. Starting Microsoft Access
3. Trusting a file
4. Quick Access toolbar
5. Backstage of Access
6. Exploring the ribbons
7. Navigation Pane
8. Components of a Database
9. Planning and designing the database
10. Create a table in Layout View
11. Understanding the structure of a table
12. Create a table using design view
13. Create a table using calculated field
14. Field Properties
15. Importing data into Access
16. Formatting tools
17. Linking the tables
18. Using Query wizard for Simple Queries
19. Using design Query
20. Sorting data using Queries
21. Building calculated fields
22. Create data entry forms
23. Create compound forms
24. Modifying forms in Layout and design view
25. Report on single table
26. Report on multiple table and formatting
27. Create reports through queries
28. Exporting data from Access
29. Creating a mail merge

Here is a sample for the course completion certificate which you will receive after complete the course. This certificate is widely accepted across industries and will boost your chances to grab the job opportunities.

Mail us at: [email protected] with below details to receive your certificate:

• Name
• Course Name
• Date of Completion
• Address