Excel Course: Beginner to Pro JT

Categories: MS Excel
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

This course is created for Excel beginners and has been designed for computer users who are willing to learn Microsoft Excel in simple steps. At the end of this course you will become an Excel Expert for sure. Also, even Excel Experts can improve their Excel Skills by the help of this course.

Tutorials are with English subtitles. Exercise files are included for each lecture. Shorcut Keys indicated for each lecture if available.

You will begin at beginner level and reach to intermediate level. You will use Excel effectively in your daily life, such as job, personal data usage etc.

Course consists of 13 Chapters. New Chapters will be added.

Please take note that in this course essential properties of Excel is introduced.

You should study each lesson as mentioned in the lecture. Please use exercies files by copying them.

The best way to learn Excel is to use Excel. In this course, learners will solve a broad range of business problems as they apply the Excel skills and techniques they learn along the way. This course uses downloadable Excel workbooks and full data sets with applied examples and practical challenge exercises. This provides learners with countless opportunities to practice their Excel skills while discovering new and useful productivity features of Excel for a variety of business contexts.

Take this course to make your life easy and organized with Excel.

Show More

What Will You Learn?

  • Data Entry Tips
  • Formula and Functions Tips
  • Creating Charts Tips
  • Database Properties
  • Pivot Tables
  • Data Analysis Tools

Course Content

Chapter 1 – Introduction

  • Menu
    01:04
  • Workbook
    01:03
  • Worksheet
    02:19
  • Quick Access Toolbar
    01:31
  • Column Row Cell Status
    01:38

Chapter 2 – Data Entry

Chapter 3 – Formulas and Functions

Chapter 4 – Formatting

Chapter 5 – Worksheet Layout

Chapter 6 – Print

Chapter 7 – Charts

Chapter 8 – Worksheet Views

Chapter 9 – Multiple Worksheets and Workbooks

Chapter 10 – IF, VLOOKUP, and Other Functions

Chapter 11 – Security and Sharing

Chapter 12 – Database Properties

Chapter 13 – Pivot Tables

Chapter 14 – Excel Data Analysis Tools

Chapter 15 – Excel VBA – Macros

Chapter 16 – Excel Advanced Formulas and Functions

Student Ratings & Reviews

No Review Yet
No Review Yet