MS Office; Excel, Word, Access & PowerPoint - Beginners

BY
Udemy

Develop an in-depth understanding of the fundamental principles and strategies involved with Microsoft Office 365 or office.

Mode

Online

Fees

₹ 3999

Quick Facts

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

Course overview

MS Office; Excel, Word, Access & PowerPoint 2019 - Beginners certification course is designed by Simon Sez IT, a digital learning platform providing courses in information technology which is provided by Udemy, to offer an in-depth understanding of Microsoft Office 2019. MS Office; Excel, Word, Access, and PowerPoint 2019 - Beginners' online classes focus on all of the tools that applicants will be able to use to learn the fundamental and advanced functions and principles of Word, Excel, Access, and PowerPoint.

MS Office; Excel, Word, Access & PowerPoint 2019 - Beginners online course is a self-paced video-based training program that includes over 35.5 hours of comprehensive lectures, 15 articles, and 13 downloadable resources that cover a wide range of Microsoft office tools and principles, including ribbon interfaces, expressions, relationships, operators, charts, tables, animation, graphics, presentation, page appearance, toolbar, envelopes, datasheets, workbooks, and more.

The highlights

  • Certificate of completion
  • Self-paced course
  • 35.5 hours of pre-recorded video content
  • 15 articles 
  • 13 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,999
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Knowledge of excel

After completing the MS Office; Excel, Word, Access & PowerPoint 2019 - Beginners online certification, participants will obtain a practical understanding of how to use Word, PowerPoint, Excel, and Access in Microsoft Office 2019 or Office 365. Participants will study charts, graphs, the ribbon interface, the toolbar, animation, graphics, envelopes, and more in the Microsoft Office environment. Participants will gain a comprehension of concepts like page appearance, expressions, subqueries, and relationships, as well as strategies for working in workbooks, and datasheets as well as creating presentations and reports.

The syllabus

Excel 2019: Introduction

  • Intro to Excel
  • WATCH ME: Essential Information for a Successful Training Experience
  • Course Exercise Files
  • Downloadable Course Transcripts
  • What's New In Excel 2019
  • Course Overview
  • Overview of the Excel window
  • Mouse-Features
  • Back Stage View
  • Section Quiz

Excel 2019 Beginner: Creating Workbooks

  • Entering Text and Numbers
  • Creating Basic Formulas
  • Relative References
  • Order of Operations
  • Working with Ranges
  • Module 2 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Saving Workbooks

  • Working with the-Save and Save As Commands
  • File Extensions, Share, Export and Publish Files
  • Module 3 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Navigating Workbooks

  • Opening a File
  • Working with Larger Files
  • Freeze Panes Option
  • Split Screen Option
  • Module 4 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Page Setup & Print Options

  • Headers and Footers
  • Print Titles
  • Comments
  • Page Setup Options
  • Fit to Print on One Page
  • Printing Workbooks
  • Module 5 - Practice Exercise
  • Section Quiz

Excel 2019 Beginners: Working with Rows, Columns and Cells

  • Adding and deleting rows columns and cells
  • Changing Column and-Row Widths
  • Module 6 - Practice Exercise
  • Section Quiz

Excel 2019 Beginners: Moving Data

  • Cut, Copy and Paste
  • Copying Formulas
  • Module 7 - Practice Exercise
  • Section Quiz

Excel 2019 Beginners: Formulas & Functions

  • Overview of Formulas
  • Create Formulas Using Functions Part 1
  • Create Formulas Using Functions Part 2
  • Absolute Values
  • Module 8 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Working with Sheets

  • Working with the Save and Save As Commands
  • Adding Deleting and Renaming Sheets
  • Additional Sheet Tab Options
  • 3 Dimensional Formulas
  • Module 9 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Formatting Worksheets

  • Formatting Cells Part 1
  • Formatting Cells Part 2
  • Formatting Numbers
  • Borders and Shading
  • Format as Table
  • Using Styles
  • Using Format Painter
  • Protecting Sheets
  • Fill Handle and Custom Lists
  • Module 10 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Charts

  • Creating Charts
  • Types of Charts
  • Editing Charts Part 1
  • Editing Charts Part 2
  • Using Graphics to Enhance Charts
  • Linking Chart Titles
  • Module 11 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Working with Names

  • Creating Range Names
  • Managing Names
  • Using Names in Formulas
  • Module 12 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Sorting and Filtering

  • Remove Duplicates
  • Sort Data
  • Filter Data
  • Advanced Filters
  • Module 13 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Outlining and Subtotaling

  • Creating an Outline
  • Subtotals
  • Module 14 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Working with Views

  • Arranging Files
  • New Window Option
  • Custom Views
  • Module 15 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Linking Files

  • Creating Formulas Between File
  • Working with Links
  • Consolidating Data
  • Module 16 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Advanced Formula Creation

  • If Statements
  • VLookups
  • Data Validation
  • Formula Auditing
  • Module 17 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Pivot Tables

  • Pivot Tables
  • Pivot Charts
  • Module 18 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Additional Excel Features

  • Slicers
  • Goal Seeker
  • Text to Columns
  • Watch Window
  • Customizing Ribbons and Tabs
  • Module 19 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Shortcuts

  • Excel Shortcuts Every User Should Know

Excel 2019 Beginner: Closing

  • Closing Video

Word 2019: Introduction

  • Welcome and Overview
  • WATCH ME: Essential Information for a Successful Training Experience
  • Course Exercise Files
  • Downloadable Course Transcripts
  • Overview of the MS Word Screen
  • The Backstage View

Word 2019: Getting Started with Word

  • Creating a New Blank Document
  • Working with Non-Printing Characters and Line Spacing
  • Saving a Document
  • Opening a Document
  • Navigating a Document
  • Go To, Find and Replace
  • Editing a Document
  • Practice Exercise
  • Section Quiz

Character Formatting

  • AutoCorrect Options
  • Selecting Text
  • Cut, Copy and Paste
  • Character Formatting Options
  • Format Painter
  • Working with Numbers
  • Working with Bullets
  • Creating an Outline
  • Practice Exercise

Word 2019: Paragraph Formatting

  • Alignment Options
  • Line Spacing Options
  • Working with Indents
  • Working with Tabs
  • Practice Exercise
  • Section Quiz

Word 2019: Managing Lists

  • Sorting a List

Word 2019: Tables

  • Working with Tables
  • Creating a Table
  • Adding Rows and Columns to a Table
  • Formatting Table Data
  • Borders and Shading
  • Sorting in a Table
  • Drawing in a Table
  • Converting Existing Data to a Table
  • Quick Tables
  • Using Formulas in Tables
  • Practice Exercise
  • Section Quiz

Word 2019: Styles

  • Working with Styles
  • Creating Styles
  • Editing Styles
  • Practice Exercise
  • Section Quiz

Word 2019: Controlling Page Appearance

  • Working with Page Breaks
  • Working with Columns
  • Adding a Watermark
  • Headers and Footers
  • Section Quiz

Word 2019: Sectioning

  • What is Sectioning?
  • Sectioning a document
  • Odd and Even Sections
  • Practice Exercise
  • Section Quiz

Word 2019: Graphics

  • Inserting Pictures
  • Inserting Pictures into Existing Documents
  • Picture Options
  • Working with Shapes
  • Icons and 3D Models
  • SmartArt, Charts and Screenshots
  • Practice Exercise
  • Section Quiz

Word 2019: Envelopes and Labels

  • Working with Envelopes
  • Working with Labels
  • Section Quiz

Word 2019: Mail Merges

  • What is Mail Merge?
  • Creating a Mail Merge Document - Part 1
  • Creating a Mail Merge Document - Part 2
  • Merging a Document with an Existing Data Source
  • Merging Envelopes and Labels
  • Merging a Directory
  • Practice Exercise
  • Section Quiz

Word 2019: Page Setup Options

  • Building Blocks
  • Auto Text
  • Practice Exercise
  • Section Quiz

Word 2019: Indexing and Table of Contents

  • Creating an Index
  • Creating a Table of Contents
  • Practice Exercise
  • Section Quiz

Word 2019: Review and Printing

  • Using the Thesaurus and Spell Check
  • Comments
  • Page Setup Options
  • Printing
  • Practice Exercise
  • Section Quiz

Word 2019: Other Word Options

  • Word Options
  • Protecting a Document
  • Macros

Word 2019: Wrap Up

  • Closing

PowerPoint 2019: Course Introduction

  • Welcome and Overview
  • WATCH ME: Essential Information for a Successful Training Experience
  • Course Exercise Files
  • Downloadable Course Transcripts

PowerPoint 2019: Overview

  • Navigate a PowerPoint Presentation
  • Overview of the Screen and Views
  • Exercise 1

PowerPoint 2019: Getting Started

  • Presentation Tips and Guidelines
  • Creating a New Presentation
  • Working with Slides
  • Saving a Presentation
  • Exercise 02
  • Section Quiz

PowerPoint 2019: Text and Bullet Editing Options

  • Formatting Text
  • Working with Bullets and Numbered Lists
  • Exercise 03
  • Section Quiz

PowerPoint 2019: Adding Graphics

  • Inserting Shapes
  • Inserting Graphics
  • Inserting Icons and 3D Models
  • Inserting Pictures
  • Exercise 04
  • Section Quiz

PowerPoint 2019: Working with objects

  • Selecting Objects
  • Editing Objects
  • Formatting Objects - Part 1
  • Formatting Objects - Part 2
  • Arranging Objects
  • Grouping Objects
  • Exercise 05
  • Section Quiz

PowerPoint 2019: Editing pictures

  • Picture Options
  • Cropping Pictures
  • Formatting Pictures
  • Things You Can Do with Pictures
  • Exercise 06
  • Section Quiz

PowerPoint 2019: Working with SmartArt

  • Creating SmartArt
  • Modifying SmartArt
  • Creating a Flowchart using SmartArt
  • Exercise 07
  • Section Quiz

PowerPoint 2019: Working with Tables

  • Creating Tables
  • Formatting Tables
  • Inserting Tables
  • Exercise 08
  • Section Quiz

PowerPoint 2019: Working with Charts

  • Adding Charts
  • Formatting Charts
  • Inserting Charts from Microsoft Excel
  • Exercise 09
  • Section Quiz

PowerPoint 2019: Unlocking the Power of Masters

  • Using Master Slides
  • Modifying Master Slides
  • Creating a New Master Design Template
  • Exercise 10
  • Section Quiz

PowerPoint 2019: Adding Media

  • Adding Video to a Presentation
  • Adding Audio to a Presentation
  • Exercise 11
  • Section Quiz

PowerPoint 2019: Working with Transitions

  • Applying Transitions
  • Transition Options
  • Exercise 12
  • Section Quiz

PowerPoint 2019: Animation

  • Animating an Object
  • Effect Options
  • Working with the Animation Pane
  • Motion Paths
  • Triggers
  • Exercise 13
  • Section Quiz

PowerPoint 2019: Hyperlinks and Action Buttons

  • Working with Action Buttons
  • Working with Hyperllinks
  • Exercise 14
  • Section Quiz

PowerPoint 2019: Slideshow Options

  • Onscreen Presentation Options
  • Hiding Slides
  • Changing the order of slides
  • Copying slides
  • Slideshow Options
  • Exercise 15

PowerPoint 2019: Preparing a presentation for delivery

  • Rehearse Timings
  • Recording a Presentation
  • Slide Show Settings
  • Creating a Custom Slide Show
  • Exercise 16

PowerPoint 2019: Exploring the Backstage Area

  • Exporting options
  • The Backstage Area
  • Printing a Presentation
  • Exercise 17

PowerPoint 2019: Course Close

  • Conclusion

Access 2019 Beginners: Introduction

  • Introduction to Access 2019
  • WATCH ME: Essential Information for a Successful Training Experience
  • Course Exercise Files
  • Course Demo Files
  • Downloadable Course Transcripts
  • Acquiring Access 2019
  • Structure of the Course
  • Section Quiz

Access 2019 Beginners: Getting Started with Access 2019

  • Using Database Templates
  • Creating, Saving and Opening Databases
  • The Access Workspace and Backstage
  • Online Help and Tell Me What You Want To Do
  • Section Quiz

Access 2019 Beginners: The Ribbon and Toolbars

  • Working with the Ribbon
  • The Quick Access Toolbar
  • Contextual Menus
  • The Status Bar
  • Section Quiz

Access 2019 Beginners: Keyboard Shortcuts and Key Tip

  • Keyboard Shortcuts
  • Key Tips
  • Section Quiz

Access 2019 Beginners: Access Options

  • Exploring Access Options
  • Section Quiz

Access 2019 Beginners: Tables

  • Creating a Table and Fields
  • Indexed Field
  • Lookup Wizard
  • Numeric Fields
  • Practice Exercise 01
  • Section Quiz

Access 2019 Beginners: Importing Data

  • Importing Data from Excel
  • Practice Exercise 02
  • Section Quiz

Access 2019 Beginners: Backup, Restore and Repair

  • Backing up your Database
  • Compact and Repair
  • Section Quiz

Access 2019 Beginners: Datasheet View

  • Design in the Datasheet View
  • Sorting and Filtering in Datasheet View
  • Entering and Modifying Data in Datasheet View
  • Section Quiz

Access 2019 Beginners: Relationships

  • Creating a Link Table
  • Setting up Relationships
  • Practice Exercise 03
  • Section Quiz

Access 2019 Beginners: Forms

  • Creating a Form
  • Modifying a Form
  • Practice Exercise 04
  • Forms in Layout View
  • Forms in Design View
  • Form Design
  • Practice Exercise 05
  • Section Quiz

Access 2019 Beginners: Subforms

  • Setting Up Subforms - Part 1
  • Setting Up Subforms - Part 2
  • Setting Up Subforms - Part 3
  • Practice Exercise 06
  • Section Quiz

Access 2019 Beginners: Queries

  • Creating a Query
  • Joins
  • Query Wizard
  • Practice Exercise 07
  • Section Quiz

Access 2019 Beginners: Expressions

  • Setting Up Validations
  • Calculation using Expressions
  • Section Quiz

Access 2019 Beginners: Reports

  • Basic Reports
  • Report Design
  • Complex Reports
  • Practice Exercise 08
  • Section Quiz

Access 2019 Beginners: Printing

  • Printing and Print Properties
  • Section Quiz

Access 2019 Beginners: More Data Types

  • Yes/No, OLE Objects and Hyperlink Data Types
  • Section Quiz

Access 2019 Beginners: More About Forms

  • Form Controls
  • Form Themes
  • Navigation Forms
  • Section Quiz

Access 2019 Beginners: Exporting

  • Exporting an Access Database
  • Section Quiz

Access 2019 Beginners: Application Parts

  • Adding Application Parts to a Database

Access 2019 Beginners: More Access Options

  • Additional Access 2019 Options
  • Section Quiz

Access 2019 Beginners: Info Tab

  • Edit Database Properties and Encrypt with Password
  • Section Quiz

Access 2019 Beginners: Course Close

  • Course Close

Extras

  • EXTRA LESSON: Designing Better Spreadsheets Webinar Recording
  • EXTRA LESSON: Data Cleaning in Excel Webinar Recording
  • EXTRA LESSON: Top Ten Excel Functions You HAVE to Know Webinar Recording
  • EXTRA RESOURCE: The Most Frequently Used Excel Shortcuts - Infographic
  • EXTRA RESOURCE: The Most Frequently Used PowerPoint Shortcuts - Infographic
  • EXTRA RESOURCE: The Most Frequently Used Access Shortcuts - Infographic
  • EXTRA RESOURCE: The Most Frequently Used Word Shortcuts - Infographic

Congratulations!

  • BONUS Lecture

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