MS Excel Basics for Professionals : Beginners Course

Name: MS Excel Basics for Professionals : Beginners Course
Rating: 3.2 (26 reviews)

Master working on tables, charts, formulas and XLookup functions (Free pdf on MS Excel shortcuts) with 1-1 support

Last updated 12/2020

English

What you'll learn

What is MS Excel used for? & How to launch MS Excel on your computer?
Know the elements of the layout of the MS Excel workbook along with the functions of the different Tabs
Handling multiple spreadsheets, entering data & sizing options for the row & columns
Use exisitng formulas, create new formulas & use VlookUp & Hlookup functions in MS Excel
Data Formatting in MS Excel
Learn to insert simple charts from your data & format them in required style
How to Save/Print a worksheet & significance of the Page break preview while printing

7 sections • 19 lectures • 56m total length

Introduction1:26
Hello There! Welcome to the Beginners Course on MS Excel for Professionals. In this lecture, we will get to know about MS Excel and how it is an important tool you should learn to use in your personal & professional lives.
Launching MS Excel on your Computer1:28
In this lecture, we will know the different ways in which MS Excel application can be launched from a computer.

Knowing about the MS Excel User Interface4:22
In this lecture, we will know the different elements of the MS Excel User Interface
Ribbon & Groups in MS Excel0:59
In this lecture, we will learn what are Ribbons & Groups in MS Excel.
Various Tabs of the MS Excel User Interface17:49
In this lecture, we willl learn the use of options under the Tabs available in MS Excel viz. Home, Insert, Draw, Page Layout & Formulas

Handling Spreadsheets in MS Excel2:38
In this lecture, we will learn about the spreadsheet handling options in MS Excel :
Navigating through Spreadsheets(with Shortcuts)
Adding/Copying/Moving spreadsheets.
Tab Color & Protecting Spreadsheets.
Entering Data & Autofilling Data1:32
In this lecture, we will learn about entering data into the MS Excel spreadsheet & making an automatic data entry into the spreadsheet cell. (Auto-fill)
Sizing the Cell1:23
In this lecture, we will learn about sizing the cell as per the data within the cell.

Use of Sum, Average, Max, Min1:51
In this lecture, we will learn to implement the formulas for finding out basic Sum, Average, Max & Min in your Excel Spreadsheet.
Use of a Customised Formula1:09
In this lecture, we will learn to implement a custom formula of your choice in the Excel Spreadsheet.
Vlookup & Hlookup in MS Excel3:10
In this lecture, we will learn to implement the Vlookup & Hlookup functions in the Excel spreadsheet.

Save and Save As0:54
In this lecture, we will know the difference between Save & Save As option & understand how to use it.
Print Layout with Preview1:58
In this lecture, we will understand about the print layout along with page setup settings
Significance of the Page Break Preview for Printing1:21
This lecture will help you understand the significance of page break preview while printing a sheet
Congratulations on the Completion of your Course0:26
Congratulations! By now we have mastered the Basics of MS Excel in this course. Also, you can download the free pdf on Basic Shortcuts in MS Excel

*** Whats New!!! ***

"Der Kurs ist jetzt auch mit deutschen Untertiteln verfügbar"

( The course is now available with German(Deutsch) subtitles )

***Attached is a free pdf on MS Excel : Basic Shortcuts***

In this course, you will learn how MS Excel acts as an important tool used in our personal & professional growth.

You will first learn about launching MS Excel on your system, then you shall identify the different elements & tabs on the layout of the Excel workspace & how to use them.
You will learn to use basic things like handling spreadsheets, entering data, autofill etc. After completing the basics, you shall know how to use formulas to make calculations using the data, use of custom formulas & use of Vlookup & Hlookup functions.
After that, you will look at how to do simple data formatting & how to insert simple charts using your data.
Lastly, you shall have a look at the saving & printing options along with the layout settings during printing.
You shall also look at the significance of the Page Break Preview while printing worksheets.
Finally on completion, you receive a certificate by your name and a free pdf on Excel shortcuts to save your time.
You can now finally create and analyse spreadsheets to boost your office productivity or personal growth.

( You can always share your queries, as I am available for 1-1 support )

This course is perfect for beginner level Excel users
Anyone who wants to learn MS Excel as a skill & use it as a tool for their personal & professional life
This course is perfect for graduates studying in their educational program & looking to acquire a new skill for career opportunities
This course can help working professionals who are new to MS Excel & want to acquire this skill for their professional growth