Master Microsoft Excel, PowerPoint and Word 2013 - 27 Hours

BY
Udemy

Learn the fundamental principles and strategies associated with Microsoft Office 2013 from the ground up.

Mode

Online

Fees

₹ 3699

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, PowerPoint, and Word 2013 - 27 Hours certification course are developed by Simon Sez IT, an online educational platform that offers courses in information technology and is presented by Udemy which is targeted at applicants who want to acquire a comprehensive understanding of the essential fundamentals and functionalities of the MS-Excel, MS-PowerPoint, and MS-Word 2013 edition. The Master Microsoft Excel, PowerPoint, and Word 2013 - 27 Hours online course focuses on formulae, animation, audio, video, and other collaboration tools to create spreadsheets, presentations, and documents.

Master Microsoft Excel, PowerPoint and Word 2013 - 27 Hours online classes feature 34 hours of digital video-based learning material along with 6 articles and 6 downloadable resources which teach about topics like data entry, cell formatting, graphing, data analysis, charting, data protection, document management, document security, editing restrictions, animation. Upon completion of the course, applicants will obtain a certificate that will aid in their study of MS Office desktop apps such as word, excel, and PowerPoint.

The highlights

  • Certificate of completion
  • Self-paced course
  • 34 hours of pre-recorded video content
  • 7 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
₹ 3,699
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

After completing the Master Microsoft Excel, PowerPoint, and Word 2013 - 27 Hours online certification, applicants will develop a better understanding of the fundamentals and features of MS–Excel, MS–Word, and MS–PowerPoint at both a basic and advanced level. Applicants will explore the several features and concepts like ribbon interface, AutoRecover, trust center, worksheet, pivot tables, charting, graphing, data entry, cell formatting, sharing, and collaboration in Microsoft office. Applicants will also learn about document management, document security, data protection, and editing restrictions as well as other operational techniques.

The syllabus

Excel 2013: Introduction

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

Excel 2013: Using Touch

  • Overview of Principles

Excel 2013: Getting Started

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

Excel 2013: Help

  • Course Review
  • Online, Offline, and Contextual Help

Excel 2013: Settings and Preferences

  • Excel Options

Excel 2013: The Ribbon and Toolbars

  • Ribbon Interface
  • Quick Access Toolbar
  • Mini Toolbar

Excel 2013: Backup and Recovery

  • Create Backup Option; Auto-Recover and Autosave

Excel 2013: Entering and Deleting Data

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

Excel 2013: 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

Excel 2013: Copy, Paste and Paste Special

  • Copy, Cut and Paste

Excel 2013: Proofing

  • Spell checking

Excel 2013: Managing Worksheets

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

Excel 2013: Comments

  • Inserting Comments

Excel 2013: Viewing and Printing

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

Excel 2013: Formulas and Functions

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

Excel 2013: Working with Workbooks

  • Multiple Workbooks and Windows; Comparing Workbooks

Excel 2013: Find and Replace

  • Go to; Find and Replace Options

Excel 2013: Conditional Formatting

  • Applying, Clearing and Managing Rules

Excel 2013: Graphing and Charting

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

Excel 2013: File Types

  • Saving Workbooks; PDF and CSV Formats

Excel 2013: Managing Data

  • Sorting
  • Filtering
  • Tables

Excel 2013: Functions Case Study

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

Excel 2013: Analyzing Data

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

Excel 2013: Shapes and Pictures

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

Excel 2013: Sharing and Protecting

  • Protecting Worksheets
  • Protecting Workbooks
  • Sharing and SkyDrive

Excel 2013: More Backstage View Options

  • Trust Center; Export; Inspect Workbook

Excel 2013: Closing

  • Summary; More Help
  • Excel 2013 Course Quiz
  • BONUS Lecture: Dashboards in Excel Live Webinar Recording

Introduction to PowerPoint 2013

  • Acquiring PowerPoint 2013
  • WATCH ME: Essential Information for a Successful Training Experience
  • Course Exercise Files
  • Downloadable Course Transcripts
  • What's New in PowerPoint 2013

PowerPoint 2013: Using Touch

  • Overview of Principles

PowerPoint 2013: Getting Started

  • PowerPoint Workspace; Opening, Saving and Exiting
  • Backstage View; Protecting Presentations; Editing Properties

PowerPoint 2013: Help

  • Online and Offline Help

PowerPoint 2013: PowerPoint Options

  • Customize Settings and Preference

PowerPoint 2013: The Ribbon and Toolbars

  • The Ribbon
  • Quick Access Toolbar
  • Mini Toolbar
  • Status Bar

PowerPoint 2013: Backup, AutoSave and AutoRecover

  • Backup Files; Adjust AutoSave; Recover Unsaved Presentation

PowerPoint 2013: Creating a Presentation

  • New Blank Presentation; Slide Size, Orientation and Background
  • Adding Contents; Adding and Deleting Slides

PowerPoint 2013: Views

  • Adjusting View and Adding Notes in Normal View; Promote/Demote and Expand/Collap
  • Moving Slides in Slide Sorter View; Notes Page and Reading View
  • Zoom

PowerPoint 2013: Undo and Redo

  • Undo and Redo Actions; Set Maximum Number of Undos

PowerPoint 2013: Working with Text

  • Adding and Formatting Text; Placeholder Textbox
  • Manual Textbox; Inserting Symbols

PowerPoint 2013: Copy, Cut and Paste

  • Using Clipboard and Mini Toolbar; Paste Option

PowerPoint 2013: Spelling and Grammar Checking

  • AutoCorrect and Proofing

PowerPoint 2013: Masters, Themes and Layouts

  • Templates, Slides and Masters
  • Background Color, Themes and Layouts
  • Header and Footer

PowerPoint 2013: Lists

  • Bulleted and Numbered Lists

PowerPoint 2013: Paragraph Formatting

  • Alignment, Line Spacing, Ruler and Tabs

PowerPoint 2013: Working with Images and Clip Art

  • Inserting Pictures
  • Formatting Pictures
  • Photos and Photo Albums
  • Clip Art
  • Screenshots

PowerPoint 2013: Working with Shapes and Drawings

  • Drawing and Formatting Shapes
  • Creating Complex Shapes
  • SmartArt

PowerPoint 2013: Saving a Presentation

  • Save Options, Create PDF/XPS Document, Change File Type

PowerPoint 2013: Tables

  • Creating and Formatting Tables

PowerPoint 2013: Charts

  • Creating Charts using Excel; Editing Data, Chart Type and Chart Element

PowerPoint 2013: Animation

  • Basics of Animation
  • Controlling Animation; Motion Path
  • Animation of SmartArt

PowerPoint 2013: Printing and Page Setup

  • Printing Slides and Handouts

PowerPoint 2013: Interactivity and Hyperlinks

  • Linking to a Webpage and a Slide

PowerPoint 2013: Laying out Slides

  • Aligning Objects; Grid and Guides; Nudging

PowerPoint 2013: Preparing for a Presentation

  • Spell check; Create Handouts and Videos; Inspect Document; Hide Slide; Custom Sh
  • Transitions and Timings; Setting up and Recording a Slide Show

PowerPoint 2013: Delivering a Presentation

  • Manual Presentation; Presenter View and Tools

PowerPoint 2013: Collaboration

  • Comments

PowerPoint 2013: Sharing

  • Saving your Presentation on SkyDrive
  • PowerPoint Web App; Send Email; Get a Link

PowerPoint 2013: Online Presentation

  • Presenting on the Web

PowerPoint 2013: Working with Multimedia

  • Inserting and Formatting Video; Adding Audio

PowerPoint 2013: Conclusion

  • Protecting your Presentation; Trust Center; Closing
  • Microsoft PowerPoint 2013 Quiz
  • BONUS Lecture: PowerPoint Tips and Tricks Live Webinar Recording

Introduction to Word 2013

  • 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

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: Word Options

  • Settings and Preferences

Word 2013: The Ribbon and Toolbars

  • The Ribbon
  • Quick Access Toolbar
  • Mini Toolbar/Bar

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: Charts

  • Creating Charts

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
  • BONUS Lecture: Advanced Word Live Webinar Recording

Additional Training

  • READ ME: This Additional Training Is Optional
  • Ten Excel Tips and Tricks - Part 1
  • Ten Excel Tips and Tricks - Part 2
  • Ten Excel Tips and Tricks - Part 3

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