Skip to content
Play overlay
Preview this course

Let's Excel With Microsoft Excel

Learn & Understand Microsoft Excel Tool starting from Fundamental Level to the Most Advanced Level.


Supreet Agrawal

Summary

Price
£12 inc VAT
Study method
Online, On Demand What's this?
Duration
2.5 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Reed Courses Certificate of Completion - Free
Additional info
  • Tutor is available to students

Add to basket or enquire

Overview

'Let's Excel with Microsoft Excel' course would take you through 6 levels:

1. Introduction to Microsoft Excel

2. Basic data entry & understanding of most-frequently used shortcut keys along-with the reference file of all shortcut keys available in Microsoft Excel

3. Understanding of most-frequently used formulae in Microsoft Excel with the help of practical examples along-with reference file for future reference.

4. Pivot tables & charts with the help of practical examples along-with reference file for future reference.

5. Understanding of functionality of every button given under each main function of the Microsoft Excel's Ribbon with the use of practical example along-with reference file for future reference.

6. Understanding of advanced functionalities available in Microsoft Excel such as Advanced Formulae, What-if Analysis, Power Pivot, Power Query, Etc.

WHY YOU SHOULD SPECIFICALLY TAKE THIS COURSE?

This course would particularly help you in gaining confidence while working on Microsoft Excel because of the following reasons:

1. The course starts with the discussion of most basic items such as key terminologies used in Microsoft Excel and goes upto the advanced level of using power pivot, power query, Etc.

2. The course includes understanding of functionality of every button available in Microsoft Excel's Ribbonwith the help of practical example

3. Microsoft Excel & PPT files have been attachedwith the lectures for better understanding as well as future reference.

4. The lectures have been sequentially designed so as to understand all the items in a structured manner.

5. The lectures have been divided into 35 video-lectures with an average duration of 4 mins each for ease of learning & reference.

6. Lifetime Access to the course once you are enrolled.

7. A Verifiable Certificate of Completion is presented to all enrollers who undertake this MS Excel course.

After the completion of this course, you will learn & understand the utility of Microsoft Excel and would be confident while using it in your professional as well as personal lives.

SHOULD YOU TAKE THIS COURSE IF YOU ARE A BEGINNER OR NOT A BEGINNER?

Yes.

The course starts with the understanding of most basic items such as key terminologies used in Microsoft Excel, however it also goes upto the advanced level such as understanding of what-if analysis, power pivot, power query, Etc.

Also, this course includes the understanding of functionality of every button available in Microsoft Excel's Ribbon with the help of practical examples. A lot of these functionalities are not known to people who have been using Microsoft Excel for a long period of time and these functionalities would help you increase your efficiency and effectiveness.

WHAT YOU'LL BE ABLE TO LEARN?

By the end of this course, you'll be confident in showcasing your Microsoft Excel skills in your personal as well as professional lives, allowing you to:

1. Understand utility of Microsoft Excel in personal as well as professional lives

2. Input, analyze & manage data to make informed decisions

3. Use Microsoft Excel hacks to perform your work faster and with more efficiency

4. Create interactive & communicative reports by using Pivot Tables, Charts, Power Pivot, Power Query Etc.

5. Be comfortable with use of frequently-used shortcut keys, formulae along-with some advanced formulae.

6. Automate your day-to-day Microsoft Excel tasks by mastering the power of Macros

Now, if you would like to understand the overall layout and feel of the course, I would request you to go through the preview video of the course.

However, before that, I assure you that this course would be a fun and learning experience for you and it would transform the way you work with numbers.

Enroll for this course to experience yourself how such a vast and detailed tool like Microsoft Excel can be understood along with practical examples with the help of 35 video-lecturs with an average duration of 4 mins each.

Thank you!

Certificates

Reed Courses Certificate of Completion

Digital certificate - Included

Will be downloadable when all lectures have been completed.

Curriculum

7
sections
35
lectures
2h 32m
total
    • 4: 4. Data Entry & Analysis 02:03
    • 5: 5. Most Frequently Used Shortcut Keys 02:57
    • 6: 6. Meaning of Fomulae & Steps to Apply Formulae 00:55
    • 7: 7. Most Frequently Used Formulae 02:12
    • 8: 8. VLOOKUP - Syntax & Rules 01:57
    • 9: 9. VLOOKUP - Practical Example 02:00
    • 10: 10. Basics of Pivot Tables 02:25
    • 11: 11. Pivot Tables - Practical Example 02:02
    • 12: 12. Charts 04:57
    • 13: 1. Special Functionalities - File Tab 03:54
    • 14: 2. Special Functionalities - Home Tab 06:54
    • 15: 3. Special Functionalities - Insert Tab 06:18
    • 16: 4. Special Functionalities - Page Layout Tab 03:39
    • 17: 5. Special Functionalities - Formulas Tab 05:20
    • 18: 6. Special Functionalities - Data Tab 11:12
    • 19: 7. Special Functionalities - Review Tab 06:07
    • 20: 8. Special Functionalities - View Tab 07:31
    • 21: 9. Special Functionalities - Help Tab 01:49
    • 22: 10. Special Functionalities - File Extensions 04:22
    • 23: 1. Advanced Functionalities - Consolidate Button 03:24
    • 24: 2. Advanced Functionalities - Relationships & Power Pivot 03:24
    • 25: 3. Advanced Functionalities - What-if Analysis 06:13
    • 26: 4. Advanced Functionalities - Forecast Sheet & Outline Section 04:06
    • 27: 5. Advanced Functionalities - Advanced Formulae & Cell Referencing 16:16
    • 28: 6. Advanced Functionalities - Microsoft Excel Templates 03:37
    • 29: 7. POWER QUERY - Text Functions 04:00
    • 30: 8. POWER QUERY - Date Functions 02:45
    • 31: 9. POWER QUERY - Merge Tables or VLOOKUP 03:25
    • 32: 10. POWER QUERY - Merge Queries From Different Workbooks 03:53
    • 33: 11. POWER QUERY - Find Only Working Days 04:25
    • 34: 12. Advanced Functionalities - Printing the Workbook 04:26
    • 35: Course Wrap Up & Next Steps 02:31

Course media

Description

'Let's Excel with Microsoft Excel' course would take you through 6 levels:

1. Introduction to Microsoft Excel

2. Basic data entry & understanding of most-frequently used shortcut keys along-with the reference file of all shortcut keys available in Microsoft Excel

3. Understanding of most-frequently used formulae in Microsoft Excel with the help of practical examples along-with reference file for future reference.

4. Pivot tables & charts with the help of practical examples along-with reference file for future reference.

5. Understanding of functionality of every button given under each main function of the Microsoft Excel's Ribbon with the use of practical example along-with reference file for future reference.

6. Understanding of advanced functionalities available in Microsoft Excel such as Advanced Formulae, What-if Analysis, Power Pivot, Power Query, Etc.

WHY YOU SHOULD SPECIFICALLY TAKE THIS COURSE?

This course would particularly help you in gaining confidence while working on Microsoft Excel because of the following reasons:

1. The course starts with the discussion of most basic items such as key terminologies used in Microsoft Excel and goes upto the advanced level of using power pivot, power query, Etc.

2. The course includes understanding of functionality of every button available in Microsoft Excel's Ribbonwith the help of practical example

3. Microsoft Excel & PPT files have been attachedwith the lectures for better understanding as well as future reference.

4. The lectures have been sequentially designed so as to understand all the items in a structured manner.

5. The lectures have been divided into 35 video-lectures with an average duration of 4 mins each for ease of learning & reference.

6. Lifetime Access to the course once you are enrolled.

7. A Verifiable Certificate of Completion is presented to all enrollers who undertake this MS Excel course.

After the completion of this course, you will learn & understand the utility of Microsoft Excel and would be confident while using it in your professional as well as personal lives.

SHOULD YOU TAKE THIS COURSE IF YOU ARE A BEGINNER OR NOT A BEGINNER?

Yes.

The course starts with the understanding of most basic items such as key terminologies used in Microsoft Excel, however it also goes upto the advanced level such as understanding of what-if analysis, power pivot, power query, Etc.

Also, this course includes the understanding of functionality of every button available in Microsoft Excel's Ribbon with the help of practical examples. A lot of these functionalities are not known to people who have been using Microsoft Excel for a long period of time and these functionalities would help you increase your efficiency and effectiveness.

WHAT YOU'LL BE ABLE TO LEARN?

By the end of this course, you'll be confident in showcasing your Microsoft Excel skills in your personal as well as professional lives, allowing you to:

1. Understand utility of Microsoft Excel in personal as well as professional lives

2. Input, analyze & manage data to make informed decisions

3. Use Microsoft Excel hacks to perform your work faster and with more efficiency

4. Create interactive & communicative reports by using Pivot Tables, Charts, Power Pivot, Power Query Etc.

5. Be comfortable with use of frequently-used shortcut keys, formulae along-with some advanced formulae.

6. Automate your day-to-day Microsoft Excel tasks by mastering the power of Macros

Now, if you would like to understand the overall layout and feel of the course, I would request you to go through the preview video of the course.

However, before that, I assure you that this course would be a fun and learning experience for you and it would transform the way you work with numbers.

Enroll for this course to experience yourself how such a vast and detailed tool like Microsoft Excel can be understood along with practical examples with the help of 35 video-lecturs with an average duration of 4 mins each.

Thank you!

Who is this course for?

1. Students & Freshers who want to learn & understand Microsoft Excel starting from Fundamentals to Advanced Level.

2. Professionals who want to learn & understand the Advanced functionalities of Microsoft Excel such as Advanced Formulae, Power Pivot, Power Query, Etc.

Requirements

1. No Prior Excel Knowledge Required.

2. You will need a computer or laptop with Windows with any version of Excel installed in it to follow along with Instructor (some techniques might not work on Mac).

3. Willingness to learn, understand and build & enhance confidence while using Microsoft Excel.

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.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.