The Ultimate Microsoft Office 2013 Training Bundle 71 Hours

BY
Udemy

Master the core principles and functionalities involved with Microsoft Office 2013 including Excel, Word, PowerPoint, Outlook, and more.

Mode

Online

Fees

₹ 599 4099

Quick Facts

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

Course overview

Microsoft Office is the software of interest for so many office professionals, whether they need to generate a spreadsheet for data analysis, a database of client information, or a brochure that highlights their organization's strengths and attractions. The Ultimate Microsoft Office 2013 Training Bundle 71 Hours online certification is created by Simon Sez IT, a virtual learning platform that provides information technology courses and is delivered by Udemy.

The Ultimate Microsoft Office 2013 Training Bundle 71 Hours online course is for students who wish to learn about the more advanced capabilities of Microsoft Office 2013, which will provide them more flexibility and opportunity for creativity. The Ultimate Microsoft Office 2013 Training Bundle 71 Hours online classes include over 71.5 hours of detailed video-based sessions, 15 articles, and 7 downloadable resources that cover a wide range of tools and topics, including the ribbon interface, charts, worksheets, quick access toolbar, hyperlinks, mail merge, SQL database, document protection, financial analysis, and much more.

The highlights

  • Certificate of completion
  • Self-paced course
  • 71.5 hours of pre-recorded video content
  • 15 articles
  • 7 downloadable resources
  • Case studies
  • Quizzes

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
₹ 599  ₹4,099
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

After completing The Ultimate Microsoft Office 2013 Training Bundle 71 Hours certification course, students will be introduced to Microsoft Office 2013's basic as well as advanced concepts and approaches. Students will use MS-ExcelMS-WordMS-PowerpointMS-Access, and MS-Publisher to analyze capabilities such as data analysis and financial analysis. Students will become familiar with charts, tables, hyperlinks, and worksheets, as well as features like the ribbon interface and quick access toolbar. Students will also learn about SQL databases and document security techniques.

The syllabus

Learn Microsoft Excel 2013 Beginner Course

  • Introduction
  • Watch Me: Essential Information for a Successful Training Experience
  • Excel 2013 Exercise Files
  • Downloadable Course Transcripts
  • What's New
  • Overview of Principles
  • Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
  • Templates; Creating, Opening, and Saving a Workbook
  • Online, Offline, and Contextual Help
  • Excel Options
  • Ribbon Interface
  • Quick Access Toolbar
  • Mini Toolbar
  • Create Backup Option; Auto-Recover and Autosave
  • Entering Text and Numbers
  • Date Formats
  • Formatting Cells; Editing and Deleting Data
  • Fill
  • Flash Fill
  • Themes and Cell Styles
  • Inserting, Deleting, Hiding and Adjusting Rows and Columns
  • Wrap Text and Alignment
  • Merging Cells; Applying Themes and Styles
  • Borders
  • Copy, Cut and Paste
  • Spell checking
  • Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets
  • Inserting Comments
  • Workbook Views, Zoom and Freeze
  • Printing; Headers, Footers and Margins
  • Overview of Formulas and Functions
  • Cell References
  • Names
  • Finding Errors; New Excel Functions
  • Multiple Workbooks and Windows; Comparing Workbooks
  • Go to; Find and Replace Options
  • Applying, Clearing and Managing Rules
  • Chart Types; Chart Recommendation
  • Basic Formatting
  • Selecting Data, Positioning and Printing Charts
  • Saving Workbooks; PDF and CSV Formats
  • Sorting
  • Filtering
  • Tables
  • VLOOKUP
  • Text Function
  • Date and Time Functions
  • Logical Functions
  • Financial Analysis Case Study - Part 1
  • Financial Analysis Case Study - Part 2
  • Quick Analysis Tool
  • Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt
  • Protecting Worksheets
  • Protecting Workbooks
  • Sharing and SkyDrive
  • Trust Center; Export; Inspect Workbook
  • Summary; More Help
  • Excel 2013 Quiz

Learn Microsoft Excel 2013 Advanced Training Course

  • Prerequisites of Excel 2013 Advanced Course
  • Watch Me: Essential Information for a Successful Training Experience
  • Excel 2013 Advanced Exercise Files
  • Downloadable Course Transcripts
  • List of Functions; Common Types of Arguments; Basic Use of Functions
  • Advanced Aspects of Functions; Searching for a Function
  • Autosum
  • Payment
  • Future Value
  • Principle Payment
  • Depreciations
  • How Dates and Times are Stored
  • Dates and Times Calculation
  • Exercise on Date and Time Functions; Date and Time Settings
  • Average
  • Percentile
  • Regression
  • LINEST Function
  • Example of Functions for Inferential Statistics
  • Text Function Case Study - 1
  • Text Function Case Study - 2
  • Lookup and Reference Functions
  • Logical Functions
  • Connecting to Other Workbooks
  • Connecting to Access Data
  • Connecting to Web Data
  • Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row
  • Inserting Columns and Rows; Resizing Tables
  • Table Reference
  • Table Styles
  • Table Selection
  • Basic Principles of Pivot Tables
  • Presentational Side of Pivot Tables
  • Filtering in Pivot Tables; Slices
  • What if
  • Scenario Manager
  • Goal Seeker
  • Solver
  • Area Charts
  • Surface Charts
  • Stock Charts - Part 1
  • Stock Charts - Part 2
  • Radar Charts
  • Bubble Charts
  • Regression and Scatter Chart
  • Creating Pivot Charts
  • Using Sparklines
  • Creating Workbooks using a Web App
  • Sharing your Workbook
  • Closing
  • Excel 2013 Advanced Quiz

Learn Microsoft Word 2013

  • Acquiring Word 2013; Information about Installing and Upgrading
  • Watch Me: Essential Information for a Successful Training Experience
  • Word 2013 Exercise Files
  • Downloadable Course Transcripts
  • What's New
  • Overview of Principles
  • Starting and Exiting; Templates; Creating, Opening and Saving Documents
  • Word Workspace; Backstage View
  • Online and Offline Help
  • Settings and Preferences
  • The Ribbon
  • Quick Access Toolbar
  • Mini Toolbar/Bar
  • Setting Up AutoSave and AutoRecover Preferences
  • Typing, Editing, and Deleting Text; Customizing Status Bar
  • Navigation; Word Wrapping; Making a Selection
  • Inserting Symbols, Date and Time, and Document Property
  • Various Methods of Copying, Cutting and Pasting
  • Uses of Navigation Pane
  • Find and Replace; Go to
  • Keyboard Shortcuts and Key Tips
  • Print Layout, Web Layout and Draft Views; Ruler and Gridlines
  • Zoom
  • Read Mode
  • Spelling and Grammar Errors; Language Settings
  • AutoCorrect; Proofing Settings; Spell Checking
  • Fonts, Font Size, and Font Colors; Text Effect and Text Highlight
  • Alignment; Line and Paragraph Spacing; Indent
  • Fill/Shading; Border Tab; Format Painter
  • Bulleted, Numbered and Multilevel Lists
  • File Formats
  • Printing
  • Page Layout, Sections and Margins
  • Headers, Footers and Page Numbers
  • Using Templates
  • Using Themes and Styles
  • Opening and Editing PDFs
  • Creating a Table; Inserting, Selecting and Deleting Rows and Columns
  • Formatting Tables
  • 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
  • Creating Charts
  • Resume Reading and Editing
  • Object Zoom
  • Mail Merge Wizard Part 1
  • Mail Merge Wizard Part 2
  • Send to Email; Post to Blog; SkyDrive; Invite People
  • Restrict Editing, Comments, Simple Markup and Tracking Changes
  • Navigation, Headings, Table of Contents, Update Page numbers and Outline View
  • Watermarks
  • Page Borders
  • Types of Hyperlinks
  • Inspecting and Protecting Documents
  • Microsoft Update; Closing
  • Word 2013 Quiz

Learn Microsoft Outlook 2013

  • Information about Installation and Upgrade
  • Read Me: Essential Information for a Successful Training Experience
  • Downloadable Course Transcripts
  • What's New in Outlook 2013
  • Using Touch
  • Online, Offline, and Contextual Help
  • Outlook 2013 Workspace
  • The Ribbon
  • Quick Access Toolbar
  • Mini Toolbars
  • Contextual Menu
  • Status Bar
  • Customizing Settings and the Use of Outlook
  • List of Keyboard Shortcuts; Using Key Tips
  • Setting Up an Account
  • Sending and Receiving Email
  • Creating Appointments and Scheduling Meetings
  • Adding Contacts
  • Adding Tasks
  • Creating Notes
  • Managing RSS Feeds
  • Printing Emails and Contacts; Print Properties
  • Favorites; PST and OST Files; Folder Size
  • Setting Up Gmail and POP Accounts
  • Adding New Folder, Moving and Deleting Items, and Emptying Folders
  • Backup and Restore a PST file
  • AutoArchive and Manual Archive
  • Import and Export Wizard
  • Calendar Options
  • Calendar Amendments and Rescheduling
  • Calendar Recurrence
  • Calendar Attachments
  • Calendar Events
  • Managing Reminders
  • Basics of Search; Searching Contacts
  • Search Folders
  • Color Categories
  • Managing Tasks
  • Contacts Options
  • Contact Information
  • Outlook Social Connector
  • Contact Views
  • Contact Groups
  • 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
  • Trust Center
  • Microsoft Updates; Closing
  • Outlook 2013 Quiz

Learn Microsoft PowerPoint 2013

  • Acquiring PowerPoint 2013
  • Watch Me: Essential Information for a Successful Training Experience
  • PowerPoint 2013 Exercise Files
  • Downloadable Course Transcripts
  • Course Review
  • What's New in PowerPoint 2013
  • Using Touch
  • PowerPoint Workspace; Opening, Saving and Exiting
  • Backstage View; Protecting Presentations; Editing Properties
  • Online and Offline Help
  • Customize Settings and Preference
  • The Ribbon
  • Quick Access Toolbar
  • Mini Toolbar
  • Status Bar
  • Backup Files; Adjust AutoSave; Recover Unsaved Presentation
  • New Blank Presentation; Slide Size, Orientation and Background
  • Adding Contents; Adding and Deleting Slides
  • Adjusting View and Adding Notes in Normal View; Promote/Demote
  • Moving Slides in Slide Sorter View; Notes Page and Reading View
  • Zoom
  • Undo and Redo Actions; Set Maximum Number of Undos
  • Adding and Formatting Text; Placeholder Textbox
  • Manual Textbox; Inserting Symbols
  • Using Clipboard and Mini Toolbar; Paste Option
  • AutoCorrect and Proofing
  • Templates, Slides and Masters
  • Background Color, Themes and Layouts
  • Header and Footer
  • Bulleted and Numbered Lists
  • Alignment, Line Spacing, Ruler and Tabs
  • Inserting Pictures
  • Formatting Pictures
  • Photos and Photo Albums
  • Clip Art
  • Screenshots
  • Drawing and Formatting Shapes
  • Creating Complex Shapes
  • SmartArt
  • Save Options, Create PDF/XPS Document, Change File Type
  • Creating and Formatting Tables
  • Creating Charts using Excel; Editing Data, Chart Type and Chart Element
  • Basics of Animation
  • Controlling Animation; Motion Path
  • Animation of SmartArt
  • Printing Slides and Handouts
  • Linking to a Webpage and a Slide
  • Aligning Objects; Grid and Guides; Nudging
  • Spell check; Create Handouts and Videos; Inspect Document; Hide Slide
  • Transitions and Timings; Setting up and Recording a Slide Show
  • Manual Presentation; Presenter View and Tools
  • Comments
  • Saving your Presentation on SkyDrive
  • PowerPoint Web App; Send Email; Get a Link
  • Presenting on the Web
  • Inserting and Formatting Video; Adding Audio
  • Protecting your Presentation; Trust Center; Closing
  • PowerPoint 2013 Quiz

Learn Microsoft Access 2013 Beginner Course

  • Acquiring Access 2013; Course Overview
  • Watch Me: Essential Information for a Successful Training Experience
  • Access 2013 Exercise Files
  • Downloadable Course Transcripts
  • What's New in Access 2013
  • Using Touch
  • Database Templates; Creating, Opening and Saving Databases
  • Workspace and Backstage View
  • Online, Offline, and Contextual Help
  • Finding Keyboard Shortcuts and Key Tips
  • Customizing the Settings and Use of Access 2013
  • The Ribbon
  • Quick Access Toolbar
  • Customizing the Status Bar
  • Overview of the Main Features of Access Database
  • Web App Basics
  • Creating Tables - Part 1
  • Creating Tables - Part 2
  • Relationships Between Tables - Part 1
  • Relationships Between Tables - Part 2
  • Inserting and Formatting Fields; Field Validation; Navigation Buttons
  • Sorting, Filtering and Finding Data
  • Entering Data; Changing the Order of Columns, Field Width and Height
  • Design View; Field Properties
  • Saving Data; Data Types, Attachments and Field Size
  • Input Masks; More on Field Properties
  • Creating Forms; Form Wizard
  • Single Forms; Insert, Delete, Modify, Sort and Filter Records
  • Layout View; Adding Existing Fields
  • Design View; Arranging Fields
  • Controls
  • Form Design
  • Query Design
  • Joins and Query Wizard
  • Query Types
  • Operators and Expressions - Part 1
  • Operators and Expressions - Part 2
  • Operators and Expressions - Part 3
  • Subforms
  • Report Wizard; Previewing a Report
  • Report Design
  • Grouped and Summary Reports; Modifying a Report
  • Adding Subreports
  • Documenter; Print Properties and Options
  • Import and Append; Copy and Paste; Export Access Database
  • Database Templates and Application Parts
  • Navigation Form
  • Modal Dialogs - Part 1
  • Modal Dialogs - Part 2
  • Modal Dialogs - Part 3
  • Actions; Example of VBA; Creating AutoExec Macro
  • More Access Options
  • Info Tab
  • Trust Center
  • Updates; Closing
  • Access 2013 Quiz

Learn Microsoft Access 2013 Advanced Training Course

  • Prerequisites and Basic Knowledge of Access 2013
  • Watch Me: Essential Information for a Successful Training Experience
  • Access 2013 Advanced Exercise Files
  • Indexes and Introduction to the Movies Database
  • Basics in Working with Datasheet View
  • Controlling the Display and Advanced Sorting and Filtering in Datasheet View
  • Linking to Other Access Database Tables
  • How to Install SQL Server Express
  • Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server
  • Reasons to Split a Database; Splitting a Database to a Front-end and a Back-end
  • Consequences of the Split; Moving a Database; Adding a Trusted Location
  • Access Options relating to Multi-user Issues; Record Locking
  • Basics of Macros and Properties of Macro Editor
  • Examples of Macros; Autoexec
  • More Autoexec
  • Macro Security
  • Customizing the Quick Access Toolbar and the Ribbon
  • Convert Macro to VBA; VBA Editor
  • Reorganizing VBA Workspace; Developing, Debugging and Running VBA Codes
  • Modules, Subs, Options Explicit, and Variables
  • Scope of Variables
  • Branch and Loop
  • Customizing Events
  • Responding to Events and Developing Error Handles
  • More on Events
  • Getting Help with Events
  • Basics of Forms: Review and Tips and Tricks
  • Advanced Features of Forms - Part 1
  • Advanced Features of Forms - Part 2
  • Advanced Features of Forms - Part 3
  • Advanced Features of Forms - Part 4
  • Basics of Queries: Review
  • Main Features and Syntax of SQL Statements
  • Use of Multiple Criteria of a Where Clause
  • How Joins Look in SQL Statements and using Query Grids
  • Update Query
  • Delete and Make Table Queries
  • Append Query
  • Protecting your Database and Codes
  • Making your Database More User-Friendly
  • Setting up an Access Web App
  • Building Basic Web Apps
  • Closing
  • Access 2013 Advanced Quiz

Learn Microsoft Publisher 2013

  • Create a New Publication
  • Watch Me: Essential Information for a Successful Training Experience
  • Course Exercise Files
  • Downloadable Course Transcripts
  • Interface Overview: Backstage View
  • Interface Overview: The Publisher Application
  • Insert, Move, Rename and Delete Pages
  • Viewing and Navigating Pages
  • Rulers, Measurements, and Guidelines
  • Establishing Business Information
  • Setting Preferences
  • Saving Your Publication
  • Inserting a Text Box
  • Formatting a Text Box
  • Character Formatting Options
  • Working with Font Schemes
  • Importing Text from Word
  • Working with Columns
  • Setting Paragraph and Line Spacing Options
  • Inserting Hyperlink Text
  • Inserting Special and Break Characters
  • Performing a Spell Check
  • Using Find and Replace Feature
  • Paragraph Formatting Options
  • Working with Tab Stops
  • Working with Styles
  • Bitmap vs. Vector Images
  • Digital Image File Formats
  • Inserting Images and Image Placeholders
  • Move, Resize and Crop Images
  • Utilizing the Adjustment Settings
  • Adding Captions and Alternate Text to Images
  • Inserting Page Parts, Borders and Accents
  • Inserting a Basic Shape
  • Formatting a Shape
  • Drawing Lines with Line Tools
  • Editing a Shape using Anchor Points
  • Comparing Color Models
  • Exploring RGB, CMYK, and Pantone Colors
  • Using Adobes Kuler Tool
  • Creating and Applying Color Schemes
  • Tints, Gradients, Textures and Patterns
  • Applying Custom Colors
  • Utilizing the Scratch Area
  • Arranging, Grouping and Ungrouping Objects
  • Rotating, Flipping, Nudging and Aligning Objects
  • Wrapping Text around Objects
  • Utilizing the Format Painter
  • Saving an Object as a Building Block
  • Inserting a Table
  • Inserting and Deleting Rows and Columns
  • Formatting a Table
  • Working with Master Pages
  • Applying a Page Background
  • Managing Page Setup Options
  • Starting a Mail Merge
  • Selecting Mail Merge Recipients
  • Inserting Merge Fields
  • Previewing and Completing a Mail Merge
  • Working with Skydrive
  • Running Design Checker and Managing Embedded Fonts
  • Printing a Publication
  • Additional Saving and Print Options
  • Course Summary
  • Publisher 2013 Quiz

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