MS Excel Complete Bundle

Blackboard Learning

Certificate of completion

Digital certificate - Included

MS Excel Complete Bundle 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 MS Excel Complete Bundle course providers. You will get a solid foundation of knowledge about MS Excel in this MS Excel Complete Bundle course. You will be able to think critically about MS Excel Complete Bundle and comprehend basic MS Excel theories and methods. This MS Excel Complete Bundle 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 MS Excel Complete Bundle bundle courses:

Course 1: Microsoft Excel 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

• Customising the Excel Quick Access Toolbar

• Customising the Excel Ribbon

• Excel Shortcut Keys

• 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 & Height of Cells

• Hiding and Unhiding Excel Rows and Columns

• Renaming, Moving & Deleting Excel Worksheets

• Adding Protection to Specific Cells

• Protecting the Structure of a Workbook

• Adding a Workbook Password to Open File

• Visually Pleasing Cell Formatting

• Formatting Fonts and Cell Background Colour

• Adding Cell Borders

• Formatting Data Appropriately

• The Magic behind Excel's Format Painter

• Creating Styles for Formatting Efficiency

• Merging Cells for a Cleaner Look

• The Power of Conditional Formatting

• How to Insert Images and Shapes

• Grab User’s Attention using Illustrations

• Customising Icons

• Create Compelling Graphics with SmartArt

• Visualise Data with Charts

• The Commonly used Column Chart

• Changing the Chart Design

• Formatting Elements of a Chart

• Modifying the Data, Type & Location of a Chart

• 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 & Utilising Slicers

• Excel's PowerPivot Add-In

• What is PowerPivot?

• Activating the Excel PowerPivot Add-In

• Creating Relationships between Data Tables

Course 2: Excel Formulas and Functions

• Building basic math's formulas

• Autosome and relative references

• Absolute references

• Named ranges

• Linking sheets and workbooks

• If, And, Or, and the nested If functions

• Countif, Sumif, Averageif, Countifs functions

• Vlookup and Hlookup functions

• Match and Index functions

• Date and time formulas and functions

• Text functions

• Tracing formulas

Course 3: Building your first Excel spreadsheet

• Tour of the excel screen

• Entering data

• Autofill speedily

• Saving the file

Course 4: Excel Data Analysis

• Excel Data Analysis - Part 1

• Excel Data Analysis - Part 2

• Excel Data Analysis - Part 3

• Excel Data Analysis - Part 4

• Excel Data Analysis - Part 5

• Excel Data Analysis - Part 6

• Excel Data Analysis - Part 7

• Excel Data Analysis - Part 8

• Excel Data Analysis – Part 9

Course 5: Excel Vlookup, Xlookup, Match and Index

• Introduction

• Introduction

• RECAP of Prior Excel Course: Top 5 Excel Skills

• Hierarchy of Excel Techniques

• Instructor

• How is this course compared with “other similar courses”?

• What you will get from this course?

• Pivot Tables (Gen 3) vs. Formulas (Gen 2)

• Excel Reporting Challenges – How to report.

• Pivot Table comes to the rescue.

• Basic Taming Manoeuvres

• Conclusion

• Takeaways

• Next Course and Q&A

Course 6: Excel Pivot Table

• Excel vlookup - Part 1

• Excel vlookup - Part 2

• Excel vlookup - Part 3

• Excel vlookup - Part 4

• Excel vlookup - Part 5

• Excel vlookup - Part 6

• Excel xlookup - Part 7

Course 7: Excel Power Query and PowerPivot

• Pivot table power query power pivot-1

• Pivot table power query power pivot-2

• Pivot table power query power pivot-3

• Pivot table power query power pivot-4

• Pivot table power query power pivot-5

• Pivot table power query power pivot-6

• Pivot table power query power pivot-7

• Pivot table power query power pivot-8

• Pivot table power query power pivot-9

• Pivot table power query power pivot-10

Course 8: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines

• Getting started with your pivot table

• Drill down

• Managing the field list

• Changing the calculation type with value field setting

• Growing the pivot table with multiple fields

• Formatting the pivot tables

Course 9: Building Robust Excel Models with Power Query, formulas and VBA

• Introduction.

• Prepaid expense models (resources).

• Accounting for prepaid expenses.

• Excel formulas detailed (Intro to three Excel models).

• Formula based prepaid expenses model (schedule).

Course 10: Compare two workbooks to find matches and variances with Excel VBA Tool

1: Compare data Workbook - Full Introduction

2: Compare Data Workbook Introduction

3: Ideal Data Types for Comparison

4: Excel as our Chosen tool for Data Comparison

5: Overview of the Compare Data Workbook

Why Blackboard Learning:

Blackboard Learning is an online learning platform by which students from any corner of the world can learn his/her 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.

This MS Excel Complete Bundle course is for anyone looking to develop their skills and knowledge in MS Excel related fields, as well as for those-

• Want to enhance MS Excel Complete Bundle related skills and knowledge.
• Use MS Excel Complete Bundle related knowledge in his career or profession.
• Needs MS Excel Complete Bundle related skills for new job applications and opportunities.
• Who wants to learn MS Excel Complete Bundle and apply in real life.
• Anyone who wants to demonstrate MS Excel Complete Bundle to prospective employers or jobs.
• Anyone who wants to apply MS Excel Complete Bundle related skills and dive into relevant career paths.

MS Excel Complete Bundle course does not require prior knowledge or experience, anyone with a PC, tablet or mobile phone can do the MS Excel Complete Bundle course. It would be ideal if the learner have:

• An open minded, a spirit of self-inspection, and willingness to improve himself/herself.
• A desire to improve business (and personal) knowledge and skills.
• The desire elevate your skills inMS Excel Complete Bundle

MS Excel Complete Bundle career path is exciting as it opens the doors to many professions related to MS Excel. Prospective MS Excel Complete Bundle related careers paths include but not limited to-

• Office Administrator
• Data Analyst
• Marketing Professional
• Business Analyst

Currently there are no Q&As for this course. Be the first to ask a question.