Excel : Microsoft Excel Courses

During the Excel : Microsoft Excel course, you’ll engage with knowledge, real life case studies as you develop practical skills and techniques for immediate application to MS excel projects, or within your organization. You will benefit from the unique pedagogy and multidisciplinary approach of Blackboard Learning – an institution at the forefront of research and online learning – as you develop MS excel skills to better understand the linking sheets and workbooks, date and time formulas and functions , and managing the sheets and the factors that contribute to career success and failure.

Throughout this Excel : Microsoft Excel course, developed by industry experts you’ll get the opportunity to learn from experts with diverse experience. Guided by experts, Excel : Microsoft Excel prepares you to become a change-maker with the skills to drive your career or organization forward.

Excel : Microsoft Excel course will demystify MS excel and give you the toolkit to make better contributions and to become an even greater asset to your organization. It will also allow you to communicate more effectively and confidently about MS excel issues, whether it is with the relevant in your own business or with outside your workplace.

After completing Excel : Microsoft Excel course from Blackboard Learning, you will be more skillful with more knowledge along with practical tips and advice, which will help you to learn the essential aspects of MS excel. Skills development on MS excel leads you to career development in the MS excel sector.

Courses included in this Excel : Microsoft Excel bundle course:

Enrol in Excel : Microsoft Excel course and get started with the Excel : Microsoft Excel journey!

This Excel : Microsoft Excel course is a course consisting of 7 courses with many Excel : Microsoft Excel related topics.

You will get in this bundle course-

Course 1: Excel Must know Formulas and Functions

Course 2: Building Your First Excel Spreadsheet

Course 3: Excel Data Analysis

Course 4:Excel Vlookup, Xlookup, Match and Index

Course 5: Excel Pivot Table

Course 6: Excel Power Query and PowerPivot

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

Certificate of completion

Digital certificate - Included

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

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

• Count if, Sum if, Average if, Count ifs functions

• Vlookup and Hlookup functions

• Match and Index functions

• Date and time formulas and functions

• Text functions

• Tracing formulas

Course 2: Building Your First Excel Spreadsheet

• Tour of the excel screen

• Entering data

• Autofill speed fil

• Saving the file

• Autosum

• Formula basics

• Copying formulas - Relative formulas

• Totals and averages

• Formatting the spreadsheets

• Managing the sheets

• Copying formulas - absolute formulas

• Linking the sheets together

• Introduction to functions

Course 3: 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 4:Excel Vlookup, Xlookup, Match and Index

• 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 5: Excel Pivot Table

• 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 Maneuvers

• How to remove “Row Labels” or “Column Labels”?

• How to sort the Total Revenue columns: select “Row Labels”!

• How to format numbers in 1 go?

• How to show Subtotals at the top or bottom?

• How to fix changing column width?

• How to solve “PivotTable field name already exists”?

• Intermediate Taming Maneuvers

• How to show % of Grand Total?

• How to insert a blank row?

• How to add customized formulas?

• How to group/ungroup rows or columns?

• How to expand/collapse groups?

• Why does it Count instead of Sum?

• Best Practices of Pivot Table

• Pivot Table Best Practice (No. 1)

• Pivot Table Best Practice (No. 2)

• Pivot Table Best Practice (No. 3)

• Pivot Table Best Practice (No. 4)

• Pivot Table Best Practice (No. 5)
  Pivot Table Best Practice (No. 6)

• Conclusion

• Takeaways

• Next Course and Q&A

Course 6: 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

• Pivot table power query power pivot-11

• Pivot table power query power pivot-12

• Pivot table power query power pivot-13

• Pivot table power query power pivot-14

• Pivot table power query power pivot-15

• Pivot table power query power pivot-16

• Pivot table power query power pivot-17

• Pivot table power query power pivot-18

• Pivot table power query power pivot-19

• Pivot table power query power pivot-20

• Pivot table power query power pivot-21

• Pivot table power query power pivot-22

• Pivot table power query power pivot-23

• Pivot table power query power pivot-24

• Pivot table power query power pivot-25

• Pivot table power query power pivot-26

Course 7: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

• Sorting and filtering the pivot tables

• Creating a dashboard with slicers, timelines and pivot charts

• Reporting by day, month, qtr., or year within the pivot table

• Refreshing the pivot data with new data

• Adding your own calculation into the pivot table

• The power of the filter section in the pivot table

• Power query

• Power pivot

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 Excel : Microsoft Excel course is for anyone looking to develop their skills and knowledge in MS excel related fields, as well as for those-

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

Excel : Microsoft Excel course does not require prior knowledge or experience, anyone with a PC, tablet or mobile phone can do the Excel : Microsoft Excel 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 inExcel : Microsoft Excel

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

• Office Administrator
• Data Analyst
• Marketing Professional

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