Microsoft Office Online Course
4 in 1 bundle | Gain competencies in Microsoft Office | Free PDF Certificate | Support
Blackboard Learning
Summary
- Certificate of completion - Free
- Tutor is available to students
Add to basket or enquire
Overview
During the Microsoft Office course, you’ll engage with knowledge and real-life case studies as you develop practical skills and techniques for immediate application to Microsoft Office projects, or within your organization. You will be benefited from the unique pedagogy and multidisciplinary approach of Blackboard Learning—an institution at the forefront of research and online learning—as you develop Microsoft Office skills to better understand the Excel worksheets, values, referencing, and formulas, and Excel pivot table creating and the factors that contribute to career success and failure.
Throughout this Microsoft Office course, developed by industry experts, you’ll get the opportunity to learn from experts with diverse experience. Guided by experts, the Microsoft Office course prepares you to become a change-maker with the skills to drive your career or organization forward.
Microsoft Office course will demystify Microsoft Office and give you the toolkit to make better contributions and become an even greater asset to your organization. It will also allow you to communicate more effectively and confidently about Microsoft Office issues, whether it is with the relevant people in your own business or with those outside your workplace.
After completing Microsoft Office course from Blackboard Learning, you will be more skillful with more knowledge, along with practical tips and advice that will help you to learn the essential aspects of Microsoft Office. Skills development in Microsoft Office leads you to career development in the Microsoft Office sector.
Courses included in this Microsoft Office bundle course:
Enroll in the Microsoft Office course and get started with the Microsoft Office journey!
This Microsoft Office course is a course consisting of 4 courses with many Microsoft Office-related topics.
You will get in this bundle course-
Course 1: Microsoft Office Tips and Tricks Get in Pro Mode
Course 2: Learn Microsoft Excel from A-Z: Beginner To Expert Course
Course 3: Excel Must Know Formulas and Functions
Course 4: Excel Pivot Table - Google Drive
Certificates
Certificate of completion
Digital certificate - Included
Description
The Microsoft Office course contains important modules that teach learners about their professional needs and succession. In the United Kingdom, Blackboard Learning is one of the most popular online Microsoft Office course providers. You will get a solid foundation of knowledge about Microsoft Office in this Microsoft Office course. You will be able to think critically about Microsoft Office and comprehend basic Microsoft Office theories and methods. This Microsoft Office course was created to provide you with the tools and methods you'll need to make a measurable effect in your career, whether your objective is to land a job, improve your abilities, or make a good influence in some other way.
Curriculum for Microsoft Office bundle courses:
Course 1: Microsoft Office Tips and Tricks Get in Pro Mode
- Introduction and Getting Started
- Introduction
- Who We Are
- Microsoft Office Tips and Tricks
- Note
- Install Document and Text Translation
- Multilevel List Trick using One Key
- Tips and Tricks for Microsoft Word
- Certificate using Microsoft Word
- Create A Certificate using Microsoft Word
- Template in Microsoft Word
- Make Your Own Template in Microsoft Word
- Indexing using Microsoft Word
- Automatic Index Table using Microsoft Word
- Use Your Voice for Writing
- Write using Your Voice
- Gifts and Bonuses
- Gifts and Bonuses
Course 2: Learn Microsoft Excel from A-Z: Beginner To Expert Course
- Excel from A-Z Course Introduction
- Excel from A-Z Course Section Overview
- What is Microsoft Excel?
- Who This Course is For
- Microsoft Excel Marketplace
- Microsoft Excel Job Opportunities
- Microsoft Excel Job Types
- Getting Started with Excel
- Finding & Opening Microsoft Excel
- Excel's Start Screen
- Explaining the Excel Interface
- Excel Interface Continued
- Excel Workbook vs. Excel Worksheet
- Saving & Opening Excel Documents
- Values, Referencing, and Formulas
- Creating Excel Labels
- Entering Numeric Values in Excel
- Formatting Date Values in Excel
- Building Basic Formulas in Excel
- Order of Operations
- Relative vs. Absolute Cell References
- Intro to Excel Functions
- Excel Functions Explained
- The SUM() Function
- The MIN() & MAX() Function
- The AVERAGE() Function
- COUNT() Functions
- Adjusting Excel Worksheets
- Moving & Copying Data
- Insert & Delete Rows/Columns
- Adjusting the Width and height of Cells
- Hiding and Unhiding Excel Rows and Columns
- Renaming, Moving & Deleting Excel Worksheets
- Little Slice of Pie Charts
- Excel's Printing Options
- Print Preview Options
- Excel's Page Layout View
- Printing a Specific Range of Cells
- Converting Spreadsheets to PDF Files
- Benefits of Using Excel Templates
- Why Create an Excel Template
- How to Create an Excel Template
- Working with Excel Datasets
- How to Prepare Data for Analysis
- How to Sort Data in Excel
- Multi-Level Sorting
- Custom Sorting Datasets in Excel
- Applying Filters to Datasets
- Creating Subtotals within a Dataset
- Converting Datasets into Tables
- Finding & Removing Duplicate Values
- Excel Database Functions
- The SUMIF() Function
- The DSUM() Function
- DSUM() Function Cont.
- The SUBTOTAL() Function
- Excel Data Validation
- What is Excel Data Validation?
- Creating a Drop Down List with Data Validation
- Different Types of Excel Data Validation
- Adding Custom Alerts to Data Validation
- Creating a Dynamic Drop Down List
- Complex Validation: Dependent Drop Down List!
- Excel PivotTables
- Creating an Excel Pivot Table
- Modifying Excel PivotTables
- Grouping & Filtering PivotTable Data
- Drilling Down into PivotTable Data
- Creating Pivot Charts & Utilizing Slicers
- Excel's PowerPivot Add-In
- What is PowerPivot?
- Activating the Excel PowerPivot Add-In
- Creating Relationships between Data Tables
- Using Data Models to Create PivotTables
- How to Create PowerPivot KPIs
- Excel's Conditional Functions
- Excel’s IF() Function
- IF() Function with AND() Criteria
- IF() Function with OR() Criteria
- Nesting Multiple IF() Functions
- The COUNTIF() Function
- Key Benefits of Named Ranges
- Excel's Lookup Functions
- VLOOKUP() Function
- The Beauty of Excel’s IFERROR() Function
- HLOOKUP() Function
- INDEX() Function
- MATCH() Function
- INDEX() and MATCH() Combined
- Two-Way Lookup with INDEX() and MATCH()
- Text-Based Functions in Excel
- LEFT(), RIGHT() and MID() Function
- Extracting Specific Text using LEN() & SEARCH()
- Combining Text with CONCATENATE()
- Quick Tips & Other Text-Based Functions
- Auditing Formulas & Custom Views in Excel
- Tracing Precedents & Dependents in Formulas
- Showing Formulas
- Grouping Data
- 3D Referencing in Formulas
- Utilizing the Watch Window in Excel
- How to Freeze Panes in Excel
- Excel’s “What If?” Tools
- Excel’s Scenario Manager Tool
- Goal Seek in Excel
- Compare Results with Excel Data Tables
- Solver Tool
- Welcome to Excel VBA!
- The Power Behind Excel VBA
- A Look Inside the Visual Basic Editor (VBE)
- Recording a Macro
- Saving & Opening a Macro-Enabled Workbook
- The VBA Language
- Modules and Procedures
- Objects, Methods, and Properties
- Excel VBA Variables
- Writing VBA Code
- Referencing a Range
- InputBox & MsgBox
- Using Variables in VBA Code
- If Then Else Statement
- Worksheet Functions inside VBA
- Creating User-Defined Functions
- User-Defined Functions within VBA Scripts
- Important VBA Tools and Logic
- Find the Last Row of the Data
- Find the Last Column of the Data
- With Statement
- Debugging & Error Handling
- Debugging & Error Handling Cont.
- Excel VBA Loops
- For Next Loop
- Do Until Loop
- For Each Loop
- Triggering Macros
- Assigning Macros to Shapes
- Form Controls vs. ActiveX Controls
- Worksheet Events
- Workbook Events
- Fun with VBA Events!
- Excel User Forms
- Creating an Excel User Form
- Adding Controls to User Forms
- How to Show a User Form
- Passing Text Box Values to Desired Cells
- Passing Option Buttons to Desired Cells
- User Form Combo Boxes
- Clearing Values from User Form Controls
- How to Close a User Form
- User Forms and Protected Sheets
- Starting a Career in Excel
- Creating an Excel Resume
- Getting Started with Freelancing
- How to Become an Excel Freelancer
- Top Freelance Websites
- How to Get Your First Client
- Personal Branding
- Networking Do's and Don'ts
- Importance of Having a Website
Course 3: Excel Must Know Formulas and Functions
- Building basic math formulas
- Autosome and relative references
- Absolute references
- Named ranges
- Linking sheets and workbooks
- If, And, Or, and the nested If functions
- County, Sum if Average if, and Count ifs functions
- VLOOKUP and Hookup functions
- Match and Index functions
- Date and time formulas and functions
- Text functions
- Tracing formulas
Course 4: Excel Pivot Table - Google Drive
Why Blackboard Learning:
Blackboard Learning is an online learning platform through which students from any corner of the world can learn their desired course. Using online learning, we assist students in realizing their full potential and advancing their careers. Today, our goal is to be the world's leading provider of online learning experiences with a global impact. By leveraging online learning, we assist students in preparing for bright futures in world-changing jobs. We provide a wide range of categories, including Accounting & IT, Programming, Creative, and more. Our courses are designed to stretch students intellectually through state-of-the-art online learning.
Who is this course for?
This Microsoft Office course is for anyone looking to develop their skills and knowledge in Microsoft Office related fields, as well as for those-
- I Want to enhance Microsoft Office related skills and knowledge.
- Use Microsoft Office related knowledge in his career or profession.
- Needs Microsoft Office related skills for new job applications and opportunities.
- Who wants to learn Microsoft Office and apply it in real life?
- Anyone who wants to demonstrate Microsoft Office to prospective employers or jobs.
- Anyone who wants to apply Microsoft Office course-related skills and dive into relevant career paths.
Requirements
The Microsoft Office course does not require prior knowledge or experience. Anyone with a PC, tablet, or mobile phone can do the Microsoft Office course. It would be ideal for the learner to have:
- An open-minded, a spirit of self-inspection, and a willingness to improve himself/herself.
- A desire to improve business (and personal) knowledge and skills.
- The desire to enhance skills in Microsoft Office.
Career path
This Microsoft Office course is exciting as it opens the doors to many professions related to Microsoft Office. Prospective Microsoft Office course-related career paths that include but are not limited to
- Data entry operator
- Client support specialist
- Data entry clerk
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.