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.
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.
Content
-
Lecture 1: Intro
1 minute 3 seconds -
Lecture 2: Getting Started
4 minutes 8 seconds -
Lecture 3: Tabs
4 minutes 49 seconds -
Lecture 4: Navigation
3 minutes 14 seconds -
Lecture 5: Paste
3 minutes 47 seconds -
Lecture 6: Symbols
1 minute 50 seconds -
Lecture 7: Cell Type
3 minutes 35 seconds -
Lecture 8: Tables
3 minutes 54 seconds -
Lecture 9: Freeze
1 minute 15 seconds -
Lecture 10: Protect
2 minutes 16 seconds -
Lecture 11: Formatting
9 minutes -
Lecture 12: Conditional Formatting
5 minutes 43 seconds -
Lecture 13: Formulas (Equal)
2 minutes 28 seconds -
Lecture 14: Dollar Sign
6 minutes 34 seconds -
Lecture 15: Formulas (IF)
4 minutes 2 seconds -
Lecture 16: Formulas (IFs)
5 minutes 43 seconds -
Lecture 17: Sum/Sumifs, Average/Averageifs, Count/Countifs
7 minutes 6 seconds -
Lecture 18: Vlookup, Hlookup
11 minutes 2 seconds -
Lecture 19: Max/Min, Large/Small
5 minutes 21 seconds -
Lecture 20: Charts
8 minutes 10 seconds -
Lecture 21: Conclusion
4 minutes 22 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.