get app
    • Home
    • Udemy
    • Courses
    • Microsoft Office Certification Mastery From Novice to Ninja

    Microsoft Office Certification Mastery: From Novice to Ninja

    BY
    Udemy

    Brochure Enquire
    Mode

    Online

    Fees

    ₹ 2499

    Quick Facts

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

    Course and certificate fees

    Fees information
    ₹ 2,499
    certificate availability

    Yes

    certificate providing authority

    Udemy

    The syllabus

    Microsoft Outlook: An Introduction to Outlook

    • A Tour of the screen elements and ribbon
    • Office Management
    • [Trick] Drag and Drop - Trim Redundant Clicks for most repetitive tasks
    • Second Window - Shuffle between your Calendar and Inbox

    Emails - Sending and Receiving

    • Emails Do's and Don'ts
    • Learn the Office Protocols - Autofill, Importance and Email Format
    • Time Saving Tip - Email Signatures
    • Handling Attachments
    • Recall a Message
    • [Trick] Quick Steps Gallery

    Email - Organizing

    • Email Options
    • Voting Buttons
    • Set your own preferences and customize - View Ribbon, Layout Group
    • Groups and Conversations
    • Search for and Color Code Emails - Color coding to make it stand out in a crowd
    • Inbox Sticky Notes
    • Follow-up Flags and Categories
    • Folders and Search Folders - Gather Category of Emails
    • [Trick] Rules and Alerts - Perform time-saving tasks

    Microsoft Outlook: Calendar

    • Various ways of Calendar Views
    • Calendar Display Options
    • Appointments, Meetings and Events
    • Schedule Resources and Schedule View
    • [Trick] Recurring Appointments - Awesome feature
    • Color Code Appointments
    • Search the Calendar quickly
    • Printing and Calendar Best practices
    • Test Yourself!

    Microsoft Outlook: Contacts

    • [Trick] New Contacts - Quick tips to add new contacts
    • Contact Groups aka Distribution Lists
    • Search Contacts & People Pane - Best way to find contact & people activities
    • Contact Folders and Groups - Keep your Contacts organized
    • Contact Categories - Keep your Contacts organized
    • Contact Views - View your contact data to get desired results & make decisions
    • Contacts Backup
    • Test your Knowledge with this Quiz

    Microsoft Outlook: Task and Notes

    • Tasks - New and Recurring
    • Task Assignment to assistant or co-worker and Change View with simple click
    • Task To-Do Bar
    • [Trick] Using Notes - Tips to make the most of your notes
    • Test your Knowledge with this Quiz

    Microsoft Outlook: Advanced Features

    • Email Merge
    • Email Merge - Personalized
    • Email Merge - Full Color Flyers
    • Backup Outlook Folder
    • Store Emails Outside of Outlook
    • Test Yourself!

    Microsoft PowerPoint: Interface and Basics

    • Launching PowerPoint & Choosing a Theme
    • Adding Slides, Changing Layouts & Exploring the Outline Feature
    • Exploring PowerPoint's Views
    • [Trick] Clever Location to add extra text to a slide
    • Customizing the PowerPoint Interface
    • Changing Themes & Colors

    Microsoft PowerPoint: Adding Text and Shapes

    • [Trick] How to quickly add content to your Slides
    • Formatting Text
    • Adding and Manipulating Shapes
    • Duplicate and Add Multiple Shapes
    • Align and Distribute Shapes
    • Group and Ungroup Shapes

    Microsoft PowerPoint: Pictures

    • Working with Pictures
    • Remove Picture Backgrounds
    • [Trick] How to quickly add multiple pictures in presentation

    Microsoft PowerPoint: Info-Graphics and Media

    • [Trick] SmartArt Graphics to quickly add diagrams to your presentation
    • How to select right chart for your data and quickly add, edit and format Charts
    • Advanced Chart Options
    • Add Tabular Data to your Presentation
    • Adding Audio
    • Adding Video

    Microsoft PowerPoint: Animations and Transitions

    • [Trick] Less is More
    • Basic Animation Types
    • Events and Speed
    • Motion Path Animations
    • Transitions

    Microsoft PowerPoint: Slide Tasks

    • Duplicate & Reordering Slides - Reuse existing slides in your presentation
    • Reusing and Copying Slides - Reuse existing slides from another presentation
    • Working with Slide Sections
    • [Trick] Reset - The Magic Button

    Microsoft PowerPoint: Deliver your Presentation

    • [Trick] Printing Slides - Quickly print your slides professionally
    • Practice makes perfect - Rehearsing Slides
    • Exploring Slide Show Options - Setup your show to present in variety of ways
    • Presenter View - Use a Special PowerPoint View

    Microsoft PowerPoint: New Design Features

    • Morph Transitions - Move objects when presenting a slide show
    • Insert Icons Seamlessly
    • 3D Animations
    • Pre-Animated 3D Models
    • [Trick] Zoom - Game Changer Feature

    Microsoft Excel 101 - An Introduction to Excel

    • The Ribbon Commands
    • The Work Surface - Workbook and Worksheets
    • Navigation Tools with 100+ Keyboard Shortcuts

    Getting to Know Excel Step-By-Step

    • Your First File
    • Formatting
    • Work with Alignment and Wrap text
    • Hiding or unhiding of Rows and Columns
    • Basic Math

    Cell Referencing & Excel Functions

    • Formula Anatomy
    • Absolute and Relative Cell Referencing
    • Functions Anatomy
    • Math Functions
    • Statistical Functions
    • Logic Functions
    • Text Functions
    • Understanding Dates & Time

    Microsoft Excel 102 - Intermediate Level Excel

    • Formula Auditing

    Lookup & If Family Functions

    • Conditional Math - SUMIF, COUNTIF & SUMPRODUCT Functions
    • External Links
    • Temporal Functions - EOMONTH & EDATE Functions
    • VLOOKUP with Approximate Match
    • Using lookup with Large Tables
    • VLOOKUP with Exact Match
    • Nesting Lookup Functions
    • Lookup Functions - Hlookup, Index, Match & Index with Match

    Microsoft Excel 103 - Advanced Level Excel

    • Recording Macros

    Optimizing Data: Sorting, Filtering & Tables

    • Basic & Advanced Sorting
    • Basic & Advanced Filtering
    • Naming Ranges
    • Excel Tables

    Quick Insights with Excel Pivot Tables & Data Analysis Tools

    • Creating Pivot Tables
    • Formatting Pivot Tables
    • Calculated Fields in Pivot Tables
    • Slicers to Calculate & Manipulate Fields
    • Grouping by date, time and other factors
    • Pivot Chart
    • What-If analysis & Data Analysis Tools
    • Solver in Excel

    Formatting including Conditional & Number Formatting in Excel

    • Cell Formatting
    • Outlining
    • Build own Custom Number Formats
    • Conditional Formats with Built-in Rules
    • Conditional Formats with Custom Rules

    Working with Excel Charts

    • Column Charts
    • Bar Charts
    • Pie Charts
    • Line Charts
    • Waterfall Charts
    • Sparklines
    • Combination Charts - Area and Line
    • Combination Charts - Column and Line

    Power Query in Excel

    • Unpivot Data from Pivot Tables
    • Build Contiguous Data without Blank Rows & Columns
    • Import Data from Text Files
    • Join Multiple Tables & Create One Master Table
    • Getting Data from Text Files
    • Getting Data from Excel Tables
    • Getting Data from Excel Ranges
    • Getting Data from External Excel Files

    Data Validation and Updating

    • Data Validation
    • Data Validation Lists
    • Comments & Notes
    • Styles

    Preparing to Deploy and Security Considerations

    • Custom Views
    • Page Setup options
    • Security Considerations
    • Sharing Workbooks and Tracking Changes

    More than Just Excel - Unlock the Power of Macros & VBA

    • Difference between Macro vs. VBA
    • Important Compatibility & Setup Information

    Macros in Excel

    • Your First Macro
    • File Types & Saving
    • Running Macros: Using the Macro Dialog
    • Running Macros: Using the Keyboard shortcuts
    • Running Macros: Using Buttons

    Getting started with VBA

    • Visual Basic Editor: What you need to Know
    • VBA Objects & the Object Model
    • Visual view of VBA Object Model
    • Where Do I Put My Code?
    • Understanding Code: Macros Syntax
    • Cleaning Up Recorded Code

    Debugging - Entry Level

    • Step Macro Line by Line & Aid in Debugging
    • Using Breakpoints

    Working with Variables

    • What are Variables?
    • Creating Variables
    • Assign Strings, Values or Objects to Variables & use in code
    • Role of Explicit vs Implicit Variables

    Advanced Debugging

    • Using the Local Window
    • Using the Immediate Window
    • Using the Watch Window
    • Using the Stop Keyword

    Coding Constructs

    • Working "With" Blocks
    • Implement If/Then Choices in VBA
    • Logic Tests - Select Case

    Looping in VBA (Control the Flow of Code)

    • Basic Looping with Do Loops
    • Do While/Until Loops
    • Looping - For X to Y loops
    • Looping - For Each X in Y Loops
    • Setup Master Macro

    VBA Message Box

    • Creating VBA Message Boxes
    • Collecting Feedback from a VBA MsgBox
    • Working with VBA Input Box to prompt user
    • Forcing User to Enter Data

    Error Handling Techniques

    • Error Types
    • Setup an Error Trap to Handle errors
    • Building Error Handlers

    User Defined Functions

    • User Defined Function (UDF) Syntax
    • Creating User Defined Functions (UDFs)
    • Calling a User Defined Function (UDFs)

    An Introduction to Microsoft Word

    • Word Screen Elements
    • Quick Access Toolbar
    • Page Navigation
    • Your First Document
    • Formatting Fonts
    • Basic Letter Layout
    • Cut, Copy and Paste Function

    MS Word - The Home Ribbon

    • Styles Gallery
    • Format text with Fonts & Colors
    • Format Painter Button
    • Font Group
    • Paragraph Formats
    • Functional Paragraph Formats
    • Bullets & Numbering
    • Indents
    • Line Spacing
    • Find & Replace Function

    MS Word - File Ribbon

    • File, New Function
    • File, Recent Function
    • File, Share Button
    • File, Info & Security Features

    MS Word - The Insert Ribbon

    • Insert Page Breaks & Blank Pages in a document
    • Add a Cover Page
    • Working with Pages
    • Insert Pictures & Clip Art
    • Use of Shapes
    • Screenshots
    • Headers & Footers
    • Page Numbers & File Location Notes
    • Word Art
    • Symbols

    MS Word - Page Layout Ribbon

    • Margins
    • Page Orientation & Size
    • Fit the Content in less pages using columns
    • Paragraph Spacing
    • Print Function

    MS Word - The View Ribbon

    • Document Views
    • Navigation Pane
    • Zoom Controls
    • Work with Multiple Windows

    MS Word - Reference Ribbon

    • Create Table of Contents
    • Update the Table of Contents
    • Mark Entry for Table of Contents
    • Footnotes & Endnotes
    • Citations and Bibliography
    • Captions
    • Create an Index

    MS Word - Custom Styles

    • Create & Apply Styles
    • Rename, Modify & Remove Styles
    • Reveal Formatting
    • Selection & Format Pane

    MS Word - Mailings Ribbon

    • Envelopes & Labels
    • Mail Merge to Labels
    • Mail Merge to Envelopes
    • Mail Merge to Form Letters
    • Mail Merge to Emails
    • Mail Merge Tips

    MS Word - Review Ribbon

    • Proofing Section
    • Language & Translation
    • Comments
    • Track Changes
    • Compare Documents

    Free Rewards

    • Free Bonuses

    Trending Courses

    Digital Marketing Courses Fashion Design Courses Data Science Courses Interior Design Courses Graphic Designing Courses Cyber Security Courses Nursing Courses Tally Courses Data Analysis Courses Web Designing Courses Artificial Intelligence Courses Ethical Hacking Courses Free Digital Marketing Courses And certifications Free Artificial Intelligence Courses And Certifications Free Data Analysis Courses And Certifications Free Cyber Security Courses And Certifications Free Data Science Courses And Certifications Free Cloud Computing Courses And Certifications Free Python Courses And Certifications Free Fashion And Textiles Courses And Certifications Free Graphic Designing Courses And Certifications Free Web Designing Courses And Certifications

    Popular Courses

    General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Data Science Courses Cyber Security Courses Programming Courses Digital Marketing Courses Law Courses Leadership Courses Explore all courses

    Popular Platforms

    upGrad Courses Udemy Courses Edx Courses Swayam Courses Coursera Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses IIT Kharagpur Courses NPTEL Courses Emeritus Courses IIT Kanpur Courses Explore all platforms

    Learn more about the Courses

    10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management
    Providers
    Close

    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