Master Microsoft Excel, Outlook and Word 2013 - 26 Hours

BY
Udemy

Develop a deep understanding of the core concepts and functionalities related to Microsoft Excel from the ground up.

Mode

Online

Fees

₹ 499 3099

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

Master Microsoft Excel, Outlook, and Word 2013 - 26 Hours online certification is created by Simon Sez IT, a virtual learning portal that specializes in programs on popular business software like Microsoft Office, Adobe Photoshop, QuickBooks, and Web Design which is delivered by Udemy. With Master Microsoft Excel, Outlook, and Word 2013 - 26 Hours online course, participants will be able to master the core functionalities and principles of Microsoft Excel, Outlook, and Word 2013 edition.

Master Microsoft Excel, Outlook and Word 2013 - 26 Hours online classes incorporate 39 hours of prerecorded video sessions that cover a variety of tools and principles associated with Microsoft Office applications, such as the ribbon interface, editing restrictions, document security, RSS feeds, graphs, charts, SkyDrive, data bars, calculating depreciation, sparklines, pivot tables, and more. Participants will have gained a comprehensive understanding of all the ins and outs of Excel, Word, and Outlook for working on diverse projects at the end of this course.

The highlights

  • Certificate of completion
  • Self-paced course
  • 39 hours of pre-recorded video content
  • 8 articles
  • 6 downloadable resources

Program offerings

  • Online course
  • Learning resources. 30-day money-back guarantee
  • Unlimited access
  • Accessible on mobile devices and tv

Course and certificate fees

Fees information
₹ 499  ₹3,099
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

After completing the Master Microsoft Excel, Outlook, and Word 2013 - 26 Hours certification course, participants will develop a better understanding of MS Excel, MS Outlook, and MS Word's principles and features. Participants will learn about the ribbon interface, graphs, charts, sparklines, data bars, and tables such as Pivot tables in the Microsoft Office platform. Participants will learn about depreciation procedures, RSS feeds, document security, and editing restrictions.

The syllabus

Introduction to Excel 2013

  • Introduction to Excel 2013
  • WATCH ME: Essential Information for a Successful Training Experience
  • DOWNLOAD ME: Course Exercise Files
  • Downloadable Course Transcripts
  • What's New

Using Touch

  • Overview of Principles

Getting Started

  • Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
  • Templates; Creating, Opening, and Saving a Workbook

Help

  • Online, Offline, and Contextual Help

Settings and Preferences

  • Excel Options

The Ribbon and Toolbars

  • Ribbon Interface
  • Quick Access Toolbar
  • Mini Toolbar

Backup and Recovery

  • Create Backup Option; Auto-Recover and Autosave

Entering and Deleting Data

  • Entering Text and Numbers
  • Date Formats
  • Formatting Cells; Editing and Deleting Data
  • Fill
  • Flash Fill

Formatting a Worksheet

  • Themes and Cell Styles
  • Inserting, Deleting, Hiding and Adjusting Rows and Columns
  • Wrap Text and Alignment
  • Merging Cells; Applying Themes and Styles
  • Borders

Copy, Paste and Paste Special

  • Copy, Cut and Paste

Proofing

  • Spell checking

Managing Worksheets

  • Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets

Comments

  • Inserting Comments

Viewing and Printing

  • Workbook Views, Zoom and Freeze
  • Printing; Headers, Footers and Margins

Formulas and Functions

  • Overview of Formulas and Functions
  • Cell References
  • Names
  • Finding Errors; New Excel Functions

Working with Workbooks

  • Multiple Workbooks and Windows; Comparing Workbooks

Find and Replace

  • Go to; Find and Replace Options

Conditional Formatting

  • Applying, Clearing and Managing Rules

Graphing and Charting

  • Chart Types; Chart Recommendation
  • Basic Formatting
  • Selecting Data, Positioning and Printing Charts

File Types

  • Saving Workbooks; PDF and CSV Formats

Managing Data

  • Sorting
  • Filtering
  • Tables

Functions Case Study

  • VLOOKUP
  • Text Function
  • Date and Time Functions
  • Logical Functions

Analyzing Data

  • Financial Analysis Case Study - Part 1
  • Financial Analysis Case Study - Part 2
  • Quick Analysis Tool

Shapes and Pictures

  • Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt

Sharing and Protecting

  • Protecting Worksheets
  • Protecting Workbooks
  • Sharing and SkyDrive

More Backstage View Options

  • Trust Center; Export; Inspect Workbook
  • Microsoft Excel 2013 Quiz
  • EXTRA LESSON: Dashboards in Excel - Live Webinar Recording

Closing

  • Course review
  • Summary; More Help

Excel Advanced: Introduction

  • Prerequisites of Excel 2013 Advanced Course
  • WATCH ME: Essential Information for a Successful Training Experience
  • Course Exercise Files
  • Downloadable Course Transcripts

Excel Advanced: Functions

  • List of Functions; Common Types of Arguments; Basic Use of Functions
  • Advanced Aspects of Functions; Searching for a Function
  • Autosum

Excel Advanced: Personal and Professional Financial Functions

  • Payment
  • Future Value
  • Principle Payment
  • Depreciations

Excel Advanced: Date and Time Functions

  • How Dates and Times are Stored
  • Dates and Times Calculation
  • Exercise on Date and Time Functions; Date and Time Settings

Excel Advanced: Text Functions

  • Text Function Case Study - 1
  • Text Function Case Study - 2

Excel Advanced: Lookup Functions

  • Lookup and Reference Functions

Excel Advanced: Logical Functions

  • Logical Functions

Excel Advanced: Connecting to External Data

  • Connecting to Other Workbooks
  • Connecting to Access Data
  • Connecting to Web Data

Excel Advanced: Tables

  • Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row
  • Inserting Columns and Rows; Resizing Tables
  • Table Reference
  • Table Styles
  • Table Selection

Excel Advanced: Pivot Tables

  • Basic Principles of Pivot Tables
  • Presentational Side of Pivot Tables
  • Filtering in Pivot Tables; Slices

Excel Advanced: Data Analysis

  • What if
  • Scenario Manager
  • Goal Seek
  • Solver

Excel Advanced: Charts

  • Area Charts
  • Surface Charts
  • Stock Charts - Part 1
  • Stock Charts - Part 2
  • Radar Charts
  • Bubble Charts

Excel Advanced: Graphs

  • Regression and Scatter Chart

Excel Advanced: Pivot Charts

  • Creating Pivot Charts

Excel Advanced: Sparklines

  • Using Sparklines

Excel Advanced: Web App

  • Creating Workbooks using a Web App
  • Sharing your Workbook

Excel Advanced: Conclusion

  • Closing
  • Learn Microsoft Excel 2013 Advanced - Quiz

Outlook 2013: Introduction

  • Information about Installation and Upgrade
  • READ ME: Essential Information for a Successful Training Experience
  • Downloadable Course Transcripts
  • What's New in Outlook 2013

Outlook 2013: Using Touch

  • Overview of Principles

Outlook 2013: Help

  • Online, Offline and Contextual Help

Outlook 2013: Getting Started

  • Outlook 2013 Workspace

Outlook 2013: The Ribbon and Toolbars

  • The Ribbon
  • Quick Access Toolbar
  • Mini Toolbars
  • Contextual Menu
  • Status Bar

Outlook 2013: Options

  • Customizing Settings and the Use of Outlook

Outlook 2013: Keyboard Shortcut and Key Tips

  • List of Keyboard Shortcuts; Using Key Tips

Outlook 2013: Basic Tasks in Outlook

  • Setting Up an Account
  • Sending and Receiving Email
  • Creating Appointments and Scheduling Meetings
  • Adding Contacts
  • Adding Tasks
  • Creating Notes

Outlook 2013: RSS Feeds

  • Managing RSS Feeds

Outlook 2013: Printing

  • Printing Emails and Contacts; Print Properties

Outlook 2013: Outlook Data Files

  • Favorites; PST and OST Files; Folder Size

Outlook 2013: Account Management

  • Setting Up Gmail and POP Accounts

Outlook 2013: Managing Folders

  • Adding New Folder, Moving and Deleting Items, and Emptying Folders

Outlook 2013: Backup and Restore

  • Backup and Restore a PST file

Outlook 2013: Archiving

  • AutoArchive and Manual Archive

Outlook 2013: Import and Export

  • Import and Export Wizard

Outlook 2013: Calendar Management

  • Calendar Options
  • Calendar Amendments and Rescheduling
  • Calendar Recurrence
  • Calendar Attachments
  • Calendar Events

Outlook 2013: Reminders and To-do Management

  • Managing Reminders

Outlook 2013: Search

  • Basics of Search; Searching Contacts
  • Search Folders

Outlook 2013: Categories

  • Color Categories

Outlook 2013: Task Management

  • Managing Tasks

Outlook 2013: Contacts

  • Contacts Options
  • Contact Information
  • Outlook Social Connector
  • Contact Views
  • Contact Groups

Outlook 2013: Email Management and Advanced Features

  • Email Options
  • Email Send and Receive Settings
  • Composing Email
  • Email Signatures
  • Email Inbox
  • Email Actions
  • Touch Action Bar
  • Junk Email
  • Stationery
  • Rules
  • Quick Steps
  • Outlook Journal
  • Mail Merge using Word

Outlook 2013: Safety and Security

  • Trust Center

Outlook 2013: Conclusion

  • Microsoft Updates; Closing
  • Microsoft Outlook 2013 - Quiz

Word 2013: Introduction

  • Acquiring Word 2013; Information about Installing and Upgrading
  • WATCH ME: Essential Information for a Successful Training Experience
  • Course Exercise Files
  • Downloadable Course Transcripts
  • What's New in Word 2013

Word 2013: Using Touch

  • Overview of Principles

Word 2013: Getting Started

  • Starting and Exiting; Templates; Creating, Opening and Saving Documents
  • Word Workspace; Backstage View

Word 2013: Help

  • Online and Offiline Help

Word 2013: Options

  • Settings and Preferences

Word 2013: The Ribbon and Toolbars

  • The Ribbon
  • Quick Access Toolbar
  • Mini Toolbars

Word 2013: Backup, AutoSave and AutoRecover

  • Setting Up AutoSave and AutoRecover Preferences

Word 2013: Entering and Editing Data

  • Typing, Editing, and Deleting Text; Customizing Status Bar
  • Navigation; Word Wrapping; Making a Selection
  • Inserting Symbols, Date and Time, and Document Property

Word 2013: Copy, Cut and Paste

  • Various Methods of Copying, Cutting and Pasting

Word 2013: Navigation and Find

  • Uses of Navigation Pane
  • Find and Replace; Go to

Word 2013: Keyboard Shortcuts

  • Keyboard Shortcuts and Key Tips

Word 2013: Views

  • Print Layout, Web Layout and Draft Views; Ruler and Gridlines; Split and Switch
  • Zoom
  • Read Mode

Word 2013: Spell Checker

  • Spelling and Grammar Errors; Language Settings
  • AutoCorrect; Proofing Settings; Spell Checking

Word 2013: Formatting

  • Fonts, Font Size, and Font Colors; Text Effect and Text Highlight
  • Alignment; Line and Paragraph Spacing; Indent
  • Fill/Shading; Border Tab; Format Painter

Word 2013: Lists

  • Bulleted, Numbered and Multilevel Lists

Word 2013: Managing Document

  • File Formats

Word 2013: Page Setup and Printng

  • Printing
  • Page Layout, Sections and Margins
  • Headers, Footers and Page Numbers

Word 2013: Templates, Themes and Styles

  • Using Templates
  • Using Themes and Styles

Word 2013: PDF in Word

  • Opening and Editing PDFs

Word 2013: Tables

  • Creating a Table; Inserting, Selecting and Deleting Rows and Columns
  • Formatting Tables

Word 2013: Graphics

  • Inserting, Cropping, Resizing and Positioning Pictures
  • Picture Styles; Picture Adjustments, Corrections and Effects
  • Online Pictures and Clipart
  • Inserting and Formatting Shapes and Textbox
  • Smart Art and WordArt
  • Screenshots

Word 2013: Resume

  • Resume Reading and Editing

Word 2013: Read Mode

  • Object Zoom

Word 2013: Mail Merge

  • Mail Merge Wizard Part 1
  • Mail Merge Wizard Part 2

Word 2013: Collaboration, Reviewing and Sharing

  • Send to Email; Post to Blog; SkyDrive; Invite People
  • Restrict Editing, Comments, Simple Markup and Tracking Changes

Word 2013: Long Documents

  • Navigation, Headings, Table of Contents, Update Page numbers and Outline View

Word 2013: Desktop Publishing

  • Watermarks
  • Page Borders

Word 2013: Hyperlinks

  • Types of Hyperlinks

Word 2013: Security

  • Inspecting and Protecting Documents

Word 2013: Conclusion

  • Microsoft Update; Closing
  • Microsoft Word 2013 - Quiz
  • EXTRA LESSON: Advanced Word Tips and Tricks - Live Webinar Recording

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books