Basic Excel Course OverView

Section 1

Introduction to Excel
Be an Excel genius with the help of our basic to advance Excel courses in as little as 24 hours! This course outlines a complete guide from the fundamentals of Excel to very powerful complex formulas and functions. Practice our each and every example to master yourself in Excel by watching our interactive videos and using our notes as a reference guide!

Section 2

Excel Transition Phase
What is the difference between 2007, 2010 and 2013 Excel? What interface, ribbons and functionalities are added in different versions of Excel?

Section 3

Interface and Ribbon
What functionalities Excel offers in various tabs: Insert Tab; Formula Tab; Data Tab; Purpose of different Formatting areas within Excel.

Section 4

Use of Excel
What is Excel used for; How to use simple Math functions; Excel file saving techniques; Different formats of saving an Excel file and why do we need that?

Section 5

Formatting Techniques
Art of Formatting Techniques: Format Painter, Font Size, Bold, Italic, Underline, Fill Color, Font Colour, Left, Right and Centre Alighnment, Wrap Text, Merge & Centre, Currency Sign, Numbers, Percentage, Control decimal points; Advance Formatting techniques: General, Number, Currency, Accounting, Date, Percentage, Custom Formatting and few short cuts.

Section 6

Excel Workbook Introduction
Difference between Worksheet and Workbooks. How new Excel file appears; Purpose of Excel tabs; How to create new worksheet; Change worksheet name; Apply different formatting.

Section 7

Important Shortcut Keys
So many important Excel shortcut keys! Purpose of those shortcuts keys; Different types of shortcut keys using CNTRL, ALT, CNTRL + SHIFT, ALT + SHIFT, CNTRL + SHIFT + ENTER; CNTRL + SHIFT + Numbers and so on.

Section 8

Printing Techniques
Printing file correctly is a skill; Learn some new shortcut keys; print previews; repeat titles on each page; page setup; how to print large data sets!

Section 9

Introduction to Excel Formulas
Introduction to some Basic formulas; Learn how to use formulas in Excel; Various different ways of using AUTOSUM function; Learn how and where to use LEFT and RIGHT function; Calculate the length of text using LEN function.

Section 10

Cell Reference
The most important module in Basic Excel course: Learn absolute cell reference; How rows and columns behaves using cell references; Purpose of Dollar sign ($) in a formula; a new F4 shortcut key.!
© Copyright 2016 | All Rights Reserved.