Soft Skills

Fundamentals of Excel

This online Excel course introduces the tools needed to navigate worksheets, organize data, and work more confidently with spreadsheet content. It explains the purpose of Excel tabs, paste options, symbols, cell types, formatting, protection, formulas, and functions. Learners also see how tables can make data from different sources easier to review and compare.

What You Will Learn:

- The content and purpose of the main Excel tabs.
- How to navigate an Excel worksheet.
- How to use different paste options for values and formats.
- How to access symbols in Excel.
- How cell types affect work within a worksheet.
- How to format and protect an Excel sheet.
- How formulas and functions support spreadsheet work.
- How to organize data in tables for easier comparison.

This Excel course for beginners is suitable for people who manage data from several sources and need a clearer way to organize and compare it. It also suits learners searching for a Microsoft Excel course that builds practical familiarity with everyday worksheet tools.

Intro

1 minute 3 seconds
Getting Started

4 minutes 8 seconds
Tabs

4 minutes 49 seconds
Navigation

3 minutes 14 seconds
Paste

3 minutes 47 seconds
Symbols

1 minute 50 seconds
Cell Type

3 minutes 35 seconds
Tables

3 minutes 54 seconds
Freeze

1 minute 15 seconds
Protect

2 minutes 16 seconds
Formatting

9 minutes
Conditional Formatting

5 minutes 43 seconds
Formulas (Equal)

2 minutes 28 seconds
Dollar Sign

6 minutes 34 seconds
Formulas (IF)

4 minutes 2 seconds
Formulas (IFs)

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

7 minutes 6 seconds
Vlookup, Hlookup

11 minutes 2 seconds
Max/Min, Large/Small

5 minutes 21 seconds
Charts

8 minutes 10 seconds
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.

Visit Linkedin

Beginner