Name: Professional Training Of Microsoft Office For Mac
Brand: eSauver
Price: 29.00 USD
Availability: InStock
Rating: 4.4 (68 reviews)

Professional Training Of Microsoft Office For Mac

Learn MS Office, data handling, data analysis, MS Excel 2011 for Mac, MS Outlook 2011, MS PowerPoint 2011, documentation, process designing, Mac system, reporting, protecting data and much more

By:

EDUCBA

(4.4)

Price : $29.00 ~~$199.00~~

Discount: $170.00

Enroll Now

Days

Hours

mins

secs

Enroll Now

Wishlist

Compare

15-Days

Money Back

Access

Lifetime

Items

Enroll Now

Description

The use for Microsoft has no longer difficult as this course is providing the sufficient knowledge of MS Office for Mac comprehensively. Remember there are some differences between MS Office functionalities using windows and MS Office functionalities using Mac operating system. Hence this course is made with the understanding of MS Office use specifically for Mac operating system. The course starts with scratch and defining the basic know-how about MS Office and then it discusses the advanced use of MS Office with the key features and functions.

Almost we all know the MS Office importance in our life as its smooth use allow us to work perfectly. The course provides the best learning about MS Word through which you can become efficient for making documentation and for making reports. Moreover, MS Excel functionalities including helpful tools allow you to increase your productivity for data handling and data analysis. MS PowerPoint in Mac has also defined in this course. After completing the course, you will also be able to use MS Outlook for Mac. The course key features are mentioned below:

MS Excel Formulas
Data Management
Analysis
Documentation
Templates
Charts and Graphs
Presentation Skills
Mac System
Automation
Email Handling
Auto Email Response
Visuals
Formatting

Rating 4.5 (50 Reviews)

Curriculum

What Inside The Bundle

Become Expert In MS Excel For Mac

Learn MS Excel, MS Excel integration in Mac, inserting data, cells, row, columns, data formatting, formulas, data freezing, adjusting, patterns, automation, charts, graphs, data analysis, data prediction and much more.

This course is made by following the MS Excel integration in Mac. It defines the effective use of MS Excel and elaborates the key features like pivot tables, data handling tool, application, arranges fields applying formulas etc. The main purpose of this course is to increase your productivity within the short span of time.

Furthermore, this courses also explain the shortcut command that actually provides the acceleration to your work. There are much difference between MS Excel use in window PCs and Mac operating system. Therefore you must need to understand the efficient usage of MS Excel for Mac.

Starting with Excel

Introduction to Basic Mac
Exploring the window
Exploring the Ribbon
Customizing the Ribbon
Setting up program preferences
Using help in Excel
Working with workbooks
Using workbook templates

Managing Worksheets

Working with cells
Using Auto-fill to input data
Create an excel table
Using find and replace
Using Data Validation rules
Limiting data entry using lists
Sorting tools
Using filter
Splitting and Feezing
How to manage worksheets
Header and Footer 1 and 2

Using formulas and functions

Introduction to formulas and functions
How to add a formula
Absolute and relative cell references
Using Auto sum formula
Using Status bar to summarize data
Joining text using concatenation
Using IF function 1 and 2
Using SUM IF function
Finding data using V LOOKUP
Goal Seek analysis 1 and 2

Formatting Worksheets

Fonts, colors and borders
Number and date formatting
Using Text Allignment
How to copy cell formats
Creating cell styles
Rule based condtional formatting
Top bottom rules and removing conditional formatting

Introduction to Charts

Column charts and their formatting
Other charts
COMMON ERRORS 1 and 2

Introduction

Course Content

Useful Excel Functions

Paste Special
Count Functions
Cell information functions

Data Functions

Choose Function
Database functions
Offset Function-Example 1
Offset Function-Dynamic use
Forecast function

WhatIfAnalysis

One Dimensional Data Tables
Two Dimensional data table
Solver1

Arrays

Arrays Introduction
Transpose 1 and 2

Pivot Tables

Pivot tables
Pivot Table Styles

Names and Dynamic Range

Naming a range
Dynamic ranges

Important Excel Tools

Text to Columns
Grouping Tabs
Sub-total FUnction
Hyperlinks
Data Validation
Random Function
Custom View
Protecting Sheet
Protecting workbook
Printing the worksheet

Advanced Charts

Sparklines
Two Axis Graph
Average Line
Bar to Pie Chart
Combo Chart Video
Invert Negatives
Scrolling Chart-Step 1 and 2
Scrolling Chart- Step 3 and 4

Rating 4.5 (50 Reviews)

Media heading

incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud
Media heading

incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud
Media heading

incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud
Media heading

incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud

Become Expert in Microsoft Word 2011 for Mac

Learn MS Word, MS Word for Mac, documentation, references, labeling, envelop, inserting data, text style, page layout, heading, designs, graphs, chart, hyperlinks, cross reference and much more.

Microsoft has introduced the MS Word for Mac operating system with new improvement. If you are a Mac user, you don’t need to worry about MS Office Word as this course briefly discusses the key features of MS Word with the consideration of MAC. In this course, you will learn the effective documentation, the use of the table of content, charts, graphs, references etc.

Additionally, you will learn about the page layout, inserting pictures, auto page numbers, symbols and equations. As the use of MS Word is everywhere, hence you need to enroll in this course and increase your productivity. After completing this course, you will become master of using MS Word for Mac.

Introduction

Overview of the course

Getting Started with Mac Word 2011

Learning of Menu’s‚ Shortcuts and Toolbars
Understanding the ribbon‚ toolbox and media browser
Understanding of a Side bar and Document views
Learning of navigation pane and document gallery
Creating and Saving a document

Understanding the Basics of Text

Inserting and Deleting a text
Learning of cut‚ copy and paste and inserting of symbols
Copying and Moving of a text and Undo - Redo Actions
Usage of a scrapbook and find and replace option

Understanding the basics of formatting

Basics of formatting
Application of formatting
Use of font dialog and find and replace formatting

Formatting Paragraphs

Basics of paragraph formatting
Use of justification and line spacing
Use of list formats
Use of indentation
Paragraph Formatting Options

Functioning of Tab Tables

Understanding of Tab Tables
Creating a form through tab tables

Styles & Themes

Learning of Styles and Themes
Use of Quick Style sets and Modification of styles
Creating a style set
Continuation of Creating a style set

Various Text Formatting Techniques

Use of format painter
Use of Drop Cap
Usage of Auto format Option

Formatting of Document

Setting Margins and Adding Page break-ups
Setting multiple columns
Continuation of Setting multiple columns
Page Orientation
Inserting page number‚ watermark‚ page colour and border
Inserting header‚ footer and text box

Working with Tables

Cell Tables
Converting to tab tables

Using Borders & Shading

Adding Borders and Shading

Multimedia Elements

Multimedia Elements

Automatic Text Feature

Autocorrect and autoformat
Autotext and auto complete

Using Outline View

Outlines

Writing Tools

Writing tools - spelling and grammar
Writing tool - Footnotes‚ table of content

Working with other users

Working with other users

Creating Letters‚ Envelops & Labels

Creating Letters
Creating Envelops And Labels

Privacy & Security Settings

Security and Privacy

Learning about Printing Documents & Using Macros

Printing Documents
Using Macro
Customizing ribbon and toolbar

Rating 4.5 (50 Reviews)

Media heading

incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud
Media heading

incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud
Media heading

incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud
Media heading

incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud

Become Expert In MS PowerPoint For Mac

Learn PowerPoint for Mac presentation techniques, automation, creating slides, manipulative designs selection, slide animation, object backgrounds, quick style, transition and much more.

The innovative switch of MS PowerPoint for Mac lets you correct the dimension of slides in the regular form and Slide Sorter interpretations. It is the advanced suitable than the toolbar’s amplification menu, which is still here. This course is the much powerful for those who want to Improve skills and want to give persuading presentation but don’t have any idea about how and where to start. The course is discussing all the significant basics and awareness Of MS PowerPoint. The course is set up with the thought of beginners, intermediate and exposure the advanced use of the MS PowerPoint.

By registering in this course, you will study about how to take in slides themes, animations, auto settings, customizations, layout, inserting audio files and much more. The actual module of MS PowerPoint 2016 permits you to make your presentation expressive that engage your audience perfectly.

Introduction to Mac Power Point 2011

Introduction
Navigating
Getting Started

Formatting a Presentation

Layouts and slide master
Using themes and inserting background

Working with Text

Adding text and formatting
Text direction and adding bullets

Adding Tables & Charts

Adding and formatting a table
Inserting and Formatting Chart

Working with Pictures

Adding Drawings and Smartart
Inserting Pictures And Formatting

Animating

Using Template With Animation
Animation and Transition Effects

Checking of Presentation

Checking of Presentation

Preparing & Sharing a Presentation

Preparing for presenting
Sharing Presentation

Inserting Audio & Video in a Presentation

Inserting Audio
Inserting Video

Advance features of Power Point

Rolling Credits
Rotating an Object on the hidden pivot
3D Pictures

Rating 4.5 (50 Reviews)

Media heading

incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud
Media heading

incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud
Media heading

incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud
Media heading

incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud

Become Expert In Microsoft Outlook 2011 for Mac

Learn MS Outlook for Mac, Outlook functionalities specifically for Mac, rules, email handling, auto reply while using Mac, scheduling meetings, calendar, reminder windows, message previews, view settings and much more.

This course is strengthened with the professional use of Outlook 20161 that support you to manage your daily work life. It describes the all in one calendar management, sending and receiving the attachment and powerful features of Outlook 2016.

The use of MS Outlook is very common but not everyone knows the powerful features of Outlook 2016. Even outlook has the ability to integrate with your cellphones. Therefore you should not miss this course as it is made to accelerate your productivity. Outlook 2016 is more updated as compare to outlook 2007 and 2010 as there are many unique features have been added in MS Outlook 2016.

Introduction To Outlook Interface

Welcome‚ Exploring the User Interface

Adding An Account

Adding An Account

Reading an E-Mail

Email Basics in Outlook
Reading an Email

Sending Email Messages

Basic Concepts on Sending Email
Sending Email Messages

Working on contacts

Working on contacts

Calendar and Scheduling

Calendar Concepts in Outlook
Calendar and Scheduling Details
Working on eNotes and Tasks
Exploring Outlook
Conclusion

Rating 4.5 (50 Reviews)

Media heading

incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud
Media heading

incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud
Media heading

incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud
Media heading

incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud

Subtotal

THE PERFECT $10 SALE IS FINALLY HERE! Avail upto 90% OFF
View Offer