Excel Functions and Shortcuts - Hands-on with Case Study

Focused View

EDUCBA Bridging the Gap

4:12:36

154 View

1. Introduction

1. Overview.mp4

03:18

2. Opening Excel.mp4

01:26

3. Familiarity With Excel Interface And Ribbons.mp4

08:35

4. Surfing An Excel Worksheet And How To Use Help In Ms Excel.mp4

10:12

2. Populating the Case Study in Excel

1. Case Study.mp4

03:26

2. Data Entry In Excel.mp4

11:40

3. Populating The Case Study In Excel.mp4

09:49

4. Calculations.mp4

08:48

5. Formulas - Part 1.mp4

06:27

6. Formulas - Part 2.mp4

06:43

7. Formatting Number Formats.mp4

08:10

8. Formatting Table Formats.mp4

08:43

9. Updating A Calculation.mp4

03:16

10. Percentages And Absolute References.mp4

09:00

11. Conditional Formatting.mp4

09:05

3. Functions and Graphs

1. If Function.mp4

12:00

2. Countif.mp4

04:32

3. Sumif.mp4

07:50

4. Graphs And Charts Part 1.mp4

07:38

5. Graphs And Charts Part 2.mp4

06:38

6. Graphs And Charts Part 3.mp4

05:02

7. Pie Chart.mp4

06:56

8. Sort Function.mp4

04:51

9. Filter Function.mp4

06:35

10. Pivot Table Part 1.mp4

06:26

11. Pivot Table Part 2.mp4

06:17

12. Freeze And Split.mp4

05:38

13. Table Formats.mp4

05:48

14. Indents And Formatting Charts.mp4

06:00

15. Printing The Worksheet.mp4

06:34

16. Print Layout.mp4

04:43

4. Shortcuts in Excel

1. Shortcuts Part 1.mp4

07:01

2. Shortcuts Part 2.mp4

08:18

3. Shortcuts Part 3.mp4

06:55

4. Shortcuts Part 4.mp4

04:25

5. Shortcuts Part 5.mp4

05:40

6. Shortcuts Part 6.mp4

03:37

7. Common Errors.mp4

04:34

Description

Learn important excel functions and shortcuts hands-on with the help of a case study

What You'll Learn?

you will be able to master the basics and advanced MS Excel and then you can apply the knowledge anywhere you would want
You will get a basic knowledge of statistics and will also learn how to use these tools to analyze a set of data.
you will master how to create reports using MS Excel.
you will learn data analysis using MS Excel

Who is this for?

Students: If you’re doing a bachelor’s degree or pursuing masters, this excel data analysis course would be immensely valuable to you. You may not need everything from this course. But if you just learn the basics and advanced level MS Excel, it would be more than the price you would pay for the course. Professionals & Entrepreneurs: If you have your own business or you’re working in a job, this excel data analysis course would help you analyze data, any set of data that you want to have a sense of.

What You Need to Know?

Willingness to master data analysis: Not everyone needs to learn data analysis. But if you’re willing and committed to learning data analysis, this is your chance. This is the best course on the market that teaches you data analysis using MS Excel. A basic sense of mathematics: You don’t need to know anything to do this course. But if you know a bit of mathematics, that would certainly help.

More details

Description
This particular training is formulated from the perspective of data analysts. Data analysts will be able to solve real-life business problems by making use of data analysis features in Excel, after undergoing this course. The course is designed as such to enable the learners to gain an understanding of advanced data sorting and filtering techniques, usage of lookup functions and other essential functions. The training will serve as a guide to learners about the usage of statistical tools in excel. Thus, training as well as the projects will take you through essential features of excel and their effective usage.
As you can expect, you will learn many tangible skills that you can implement immediately. Here is a list of skills that you will learn from this comprehensive course â€“
Basic & Advanced MS Excel: This is the biggest gain of the course. Once you do this excel data analysis course, you will be able to master the basics and advanced MS Excel and then you can apply the knowledge anywhere you would want â€“ in business, in your profession, or any passion project.
MS Excel Reports: This is an important part of data analysis. If you know how to perform data analysis, but you donâ€™t have any idea about how to represent the results; then it doesnâ€™t matter how well you performed the analysis. In this excel data analysis course, you will master how to create reports using MS Excel.
Statistical Tools: You would be requiring statistical tools to be effectively performing data analysis. Thatâ€™s why we included a separate module on statistical tools in this excel data analysis course. You will get a basic knowledge of statistics and will also learn how to use these tools to analyze a set of data.
In this excel data analysis course, you will learn data analysis using MS Excel. No matter what profession youâ€™re in, the learning would be so very valuable. You donâ€™t need to be a data analyst to take this course. You should know basic mathematics and you would be good to go. Letâ€™s have a look at what skills you will learn in this excel course.
Who this course is for:
Students: If youâ€™re doing a bachelorâ€™s degree or pursuing masters, this excel data analysis course would be immensely valuable to you. You may not need everything from this course. But if you just learn the basics and advanced level MS Excel, it would be more than the price you would pay for the course. Professionals & Entrepreneurs: If you have your own business or youâ€™re working in a job, this excel data analysis course would help you analyze data, any set of data that you want to have a sense of.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Charts

EDUCBA Bridging the Gap

Instructor's Courses

EDUCBA is a leading global provider of skill based education addressing the needs of 1,000,000+ members across 70+ Countries. Our unique step-by-step, online learning model along with amazing 5000+ courses and 500+ Learning Paths prepared by top-notch professionals from the Industry help participants achieve their goals successfully. All our training programs are Job oriented skill based programs demanded by the Industry. At EDUCBA, it is a matter of pride for us to make job oriented hands-on courses available to anyone, any time and anywhere. Therefore we ensure that you can enroll 24 hours a day, seven days a week, 365 days a year. Learn at a time and place, and pace that is of your choice. Plan your study to suit your convenience and schedule.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.