Soft Skills

Fundamentals of Excel

In this course you will learn:

- The content of each excel tab.

- How to navigate through your excel sheet.

- How to paste different items either according to their value or format or etc...

- How to access the symbols and the usage of cell types in controlling your activity on an excel sheet.

- How to protect and format your excel sheet using different formulas and functions.

Enroll now

Who takes this course

This course is for a person who have a lot of data from different sources and needs to organize those data in tables to compare them easily. The course help you know how to use excel sheets by showing how data are viewed in it.

Course content

21 Lectures • 1 hour 39 minutes

Lecture 1: Getting Started

4 minutes 8 seconds
Lecture 2: Tabs

4 minutes 49 seconds
Lecture 3: Navigation

3 minutes 14 seconds
Lecture 4: Paste

3 minutes 47 seconds
Lecture 5: Symbols

1 minute 50 seconds
Lecture 6: Cell Type

3 minutes 35 seconds
Lecture 7: Tables

3 minutes 54 seconds
Lecture 8: Freeze

1 minute 15 seconds
Lecture 9: Protect

2 minutes 16 seconds
Lecture 10: Formatting

9 minutes
Lecture 11: Conditional Formatting

5 minutes 43 seconds
Lecture 12: Formulas (Equal)

2 minutes 28 seconds
Lecture 13: Dollar Sign

6 minutes 34 seconds
Lecture 14: Formulas (IF)

4 minutes 2 seconds
Lecture 15: Formulas (IFs)

5 minutes 43 seconds
Lecture 16: Sum/Sumifs, Average/Averageifs, Count/Countifs

7 minutes 6 seconds
Lecture 17: Vlookup, Hlookup

11 minutes 2 seconds
Lecture 18: Max/Min, Large/Small

5 minutes 21 seconds
Lecture 19: Charts

8 minutes 10 seconds
Lecture 20: Conclusion

4 minutes 22 seconds
Lecture 21: Intro

1 minute 3 seconds

Meet your instructor

Omar Barghash

Mechanical Design & Production Engineer, Graduated from Ain Shams University. Have a very good experience in the industrial field. More than 20 months of internships in different multinational corporates such as Henkel, Electrolux, Nestlé & Mars in different departments; Quality, Engineering, Production & Industrial Engineering.

Very interested in the business part of the corporate. Working on enhancing my marketing & sales skills through working and volunteering in several organizations & activities, also reading more and seeking for online and offline courses in those fields as I believe that having experience in both; Supply Chain including the Operations and Business including Marketing, Sales & Finance are mandatory to be effective at your position and lets you take the right decisions knowing the true business needs. Very open to work in both fields though.

Beside this, I'm very interested in sustainability and environmental issues as I believe that we should wisely benefit from our planet's resources and leave the world a better place for the next generations.

Paying forward with my knowledge and experience is one of my core values as I believe that this is the least thing that can be done to thank God for giving me the opportunity to learn and know more and more.

Visit Linkedin