Microsoft Excel – The Complete Training for Beginners

Excel Step by Step Tutorial, Excellent for Beginners – Excel Commands, Formula, Functions – Uses with Example

Designed and Developed By

What you’ll learn

  • if you are a beginner and not knowing excel , this course is perfectly suited for you, after the completion, you will be an excel professional.
  • step by step training. In each tools and options, detailed description with example. So the learners can simply learn each topics.
  • excel ribbon – learn each tabs and their various commands – their uses with example.
  • different type of cell reference – learn their uses with example.
  • excel calculations – in worksheet area – learn simple and complex calculations.
  • Excel functions – learn functions in each category, which are essential for an office or a business, learn each one and their uses with example.
  • can learn excel advanced tools like pivot table and chart, table, data validation, scenario, consolidate, macro etc….
  • can learn excel advanced functions Lookup, Index and Match, their uses with detailed example.
  • each video tutorial, will have an index at the beginning of the video, so the learners can simply find out their commands or function without much effort.

Course Content

  • Excel – An Introduction –> 1 lecture • 1min.
  • Excel Basics –> 4 lectures • 13min.
  • Cell Reference –> 3 lectures • 16min.
  • Formula Bar –> 4 lectures • 26min.
  • Excel Ribbon and Tabs –> 26 lectures • 2hr 16min.
  • Excel Functions –> 18 lectures • 1hr 16min.
  • Excel Charts –> 4 lectures • 28min.
  • Pivot Table –> 7 lectures • 31min.
  • Excel Macro –> 3 lectures • 17min.
  • Excel Lookup – Advanced Functions –> 3 lectures • 11min.
  • Excel Keyboard Shortcuts –> 5 lectures • 29min.

Microsoft Excel - The Complete Training for Beginners

Requirements

  • anyone who has a basic knowledge in computer can join this course.

Designed and Developed By

This Excel online Tutorial is designed and developed by  RCCS, Institute of Information Technology to spread their teaching experience and services across the world.

This Course well Suited For

1. The learners who are the beginner, knowing  computer basics, but not knowing excel and their operation

2. The learners who are just learned excel basics, but have no experience and practice, want to enhance knowledge and practice

Course Structure

1. Introduction – Excel an Explanation

2. Excel Basics

a. Worksheet – operation and management (cell, formula, data manipulation, simple calculation etc….)

b. Cell Reference –  Absolute, Missed and Relative Reference ( Application and uses with example)

c.  Formula Bar –  role of formula bar in excel , various calculations and making formula and their operation

3. Excel Ribbon and Tabs  – a detailed explanation

a. Home  – general commands and tools – operation and their uses with example

b. Insert – general commands and tools – operation and their uses with example

c. Page Layout –  general commands and tools – operation and their uses with example

d. Formula Bar – Advanced tools – Name Manager, Formula auditing

d. Data   –   Advanced tools  – Scenario, Data Validation, Consolidate, subtotal and group,

Flash Fill ,text to column, sorting and filtering

other commands and tools – operation and their uses with example

 

e.  Review  – Protect sheet  and  general commands and tools – operation and their uses with example

f. View  – advanced tools – Macro

general commands and tools – operation and their uses with example

4. Excel Functions – explanation and uses with example

a. Mathematical Functions

    b. Statistical functions   

    c. Logical Functions

    d. Text Functions

    e. Date and Time Functions

    f. Financial Functions   

    g. Lookup, Index and Match functions 

5. Excel Charts – Setup and creation of Chart  ( Column Chart, Line Chart, Pie chart, Combo Chart, Spark Line …)

6. Pivot Table and Chart – Setup and Creation

7. Excel Keyboard Shortcuts – frequently used shortcuts and their uses with example

Our Assurance

Since this course is well designed and learning method is step by step from start to end, the learners can grasp simply each topics, and at the end  of each  section, there is a lab assignment – instruction video and downloadable file, for making practice. After the completion of this course, we are ensuring your excel knowledge, for making various statements, reports and their printing, complex calculations etc….

Suggestion for Learners

After watching each video, please practice it yourself, then start the next video. Lab assignment is added in order, so this also you can practice it. By doing this way,  your learnings are step by step and  you will be confident to make any statement , reports , complex calculations and their printing . All the best  – start your learning today itself – enroll now

Get Tutorial