Course Description:-

INTRODUCTION:

Why MS Office for MAC Courses Bundle training?

• This is an online course on MS Office for MAC Courses Bundle which will provide you guidance about the usage of Microsoft Office for Mac users. As there are differences between using Microsoft office in windows and using Microsoft office in Mac laptops or PC.
• Through this course on MS Office on MAC Courses Bundle we will be guiding you from scratch level how to use MS Office i.e. word, PowerPoint, excel, outlook and many more.
• The course will highlight the different features and tools which will help you to work smoothly in the Mac system.
• As Microsoft Office is a must use for official work, college work and for various other events, so through this course you will be guided how to use it appropriately and you will be learning its features, functions, tools and various other things in-depth.
• This course will provide you learning about the latest version of Microsoft office i.e. MS Office 2011 for Mac users which will enable you to understand the new and advanced features as well of MS Office 2011.

What you will learn in this MAC Courses Training?

• In this course you will be learning about Microsoft Excel 2011 for Mac users Basics as well as the Advanced features.
• In a similar manner you will be learning basic and advanced function of Microsoft Office Word 2011, Microsoft Office PowerPoint 2011 and also about Microsoft Office Outlook 2011.
• This course will provide you in detail learning about all the features of Microsoft Office 2011 so that you can learn about each concept effectively.
• This online course covers the concepts like exploring the window, exploring the ribbon, customizing the ribbon, working with workbooks, using workbook templates, using data validation rules, limiting data entry using lists, conditional formatting, cell information functions, dimensional data table, protecting the worksheet, tools of Microsoft word, features and functions of Microsoft PowerPoint, and even tools of Microsoft outlook.

Content of the MAC Courses:

• Microsoft Excel 2011 for MAC Users – Basic
• Microsoft Excel 2011 for MAC Users – Advanced
• Online Microsoft Word 2011 for Mac users Training course
• Microsoft Outlook 2011 for MAC Users
• Online Microsoft PowerPoint 2011 for MAC users Training

Who are the target Customers of MAC Courses?

• Students, MBA’s, BBA’s, Gradates & Post- graduates, Working Professionals from HR, Marketing, Sales and Operation etc., Entrepreneurs
• Prospective Finance Analyst, Market Analyst, Research Analyst, Investment Banker
• Anyone Seeking Training with Excel 2011 for Mac Systems

What are the pre-requisites of MAC Courses?

• Basic Computer Knowledge
• A Mac System for practice purpose
• Microsoft Excel installed in the Mac PC
• Passion to learn about MAC Courses

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 2011 for MAC Users - Basic

1. Introduction to Basic Mac
2. Exploring the window
3. Exploring the Ribbon
4. Customizing the Ribbon
5. Setting up program preferences
6. Using help in Excel
7. Working with workbooks
8. Using workbook templates
9. Working with cells
10. Using Auto-fill to input data
11. Create an excel table
12. Using find and replace
13. Using Data Validation rules
14. Limiting data entry using lists
15. Sorting tools
16. Using filter
17. Splitting and Feezing
18. How to manage worksheets
19. Header and Footer 1 and 2
20. Introduction to formulas and functions
21. How to add a formula
22. Absolute and relative cell references
23. Using Auto sum formula
24. Using Status bar to summarize data
25. Joining text using concatenation
26. Using IF function 1 and 2
27. Using SUM IF function
28. Finding data using V LOOKUP
29. Goal Seek analysis 1 and 2
30. Fonts, colors and borders
31. Number and date formatting
32. Using Text Allignment
33. How to copy cell formats
34. Creating cell styles
35. Rule based condtional formatting
36. Top bottom rules and removing conditional formatting
37. Column charts and their formatting
38. Other charts
39. COMMON ERRORS 1 and 2

Section 2: Microsoft Excel 2011 for MAC Users - Advanced

1. Course Content
2. Paste Special
3. Count Functions
4. Cell information functions
5. Choose Function
6. Database functions
7. Offset Function-Example 1
8. Offset Function-Dynamic use
9. Forecast function
10. One Dimensional Data Tables
11. Two Dimensional data table
12. Solver1
13. Arrays Introduction
14. Transpose 1 and 2
15. Pivot tables
16. Pivot Table Styles
17. Naming a range
18. Dynamic ranges
19. Text to Columns
20. Grouping Tabs
21. Sub-total FUnction
22. Hyperlinks
23. Data Validation
24. Random Function
25. Custom View
26. Protecting Sheet
27. Protecting workbook
28. Printing the worksheet
29. Sparklines
30. Two Axis Graph
31. Average Line
32. Bar to Pie Chart
33. Combo Chart Video
34. Invert Negatives
35. Scrolling Chart-Step 1 and 2
36. Scrolling Chart- Step 3 and 4

Section 3: Online Microsoft Word 2011 for Mac users Training course

1. Overview of the course
2. Learning of Menu’s, Shortcuts and Toolbars
3. Understanding the ribbon, toolbox and media browser
4. Understanding of a Side bar and Document views
5. Learning of navigation pane and document gallery
6. Creating and Saving a document
7. Inserting and Deleting a text
8. Learning of cut, copy and paste and inserting of symbols
9. Copying and Moving of a text and Undo – Redo Actions
10. Usage of a scrapbook and find and replace option
11. Basics of formatting
12. Application of formatting
13. Use of font dialog and find and replace formatting
14. Basics of paragraph formatting
15. Use of justification and line spacing
16. Use of list formats
17. Use of indentation
18. Paragraph Formatting Options
19. Understanding of Tab Tables
20. Creating a form through tab tables
21. Learning of Styles and Themes
22. Use of Quick Style sets and Modification of styles
23. Creating a style set
24. Continuation of Creating a style set
25. Use of format painter
26. Use of Drop Cap
27. Usage of Auto format Option
28. Setting Margins and Adding Page break-ups
29. Setting multiple columns
30. Continuation of Setting multiple columns
31. Page Orientation
32. Inserting page number, watermark, page colour and border
33. Inserting header, footer and text box
34. Cell Tables
35. Converting to tab tables
36. Adding Borders and Shading
37. Multimedia Elements
38. Autocorrect and autoformat
39. Autotext and auto complete
40. Outlines
41. Writing tools – spelling and grammar
42. Writing tool – Footnotes, table of content
43. Working with other users
44. Creating Letters
45. Creating Envelops And Labels
46. Security and Privacy
47. Printing Documents
48. Using Macro

Section 4: Microsoft Outlook 2011 for MAC Users

1. Welcome, Exploring the User Interface
2. Adding an Account
3. Email Basics in Outlook
4. Reading an Email
5. Basic Concepts on Sending Email
6. Sending Email Messages
7. Working on contacts
8. Calendar Concepts in Outlook
9. Calendar and Scheduling Details
10. Working on eNotes and Tasks
11. Exploring Outlook
12. Conclusion

Section 5: Online Microsoft Powerpoint 2011 for MAC users Training

1. Introduction
2. Navigating
3. Getting Started
4. Layouts and slide master
5. Using themes and inserting background
6. Adding text and formatting
7. Text direction and adding bullets
8. Adding and formatting a table
9. Inserting and Formatting Chart
10. Adding Drawings and Smartart
11. Inserting Pictures And Formatting
12. Using Template With Animation
13. Animation and Transition Effects
14. Checking your Presentation
15. Preparing for presenting
16. Sharing Presentation
17. Inserting Audio
18. Inserting Video
19. Rolling Credits
20. Rotating an Object on the hidden pivot
21. 3D Pictures

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: shubham.s@youth4work.com with below details to receive your certificate:

• Name
• Course Name
• Date of Completion
• Address