Basic and Intermediate 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!

Section 11

Customization
How to change permanent and default Excel settings for Fonts, Colours, Numbers of Worksheets, Ribbons and much more.

Section 12

Workbook Protection
What is the purpose of protecting worksheets, workbook? How do we protect worksheets and Workbook with and without the password? Learn the importance! How to share workbooks in a working environment?

Section 13

Linking Data to Different Sources
How do we link data in Excel to different data source? Learn how to update external links; How to parse data in Excel; How to convert .txt files into Excel format and much more.

Section 14

Risk Assessment Techniques
Some basic principles upon which Excel crashes can be avoided; Monitor and Reduce file size; Learn Excel trouble shooting and some other Risk assessment techniques!

Section 15

Text Functions
Define TEXT functions and their usage? Get introduced to CLEAN() and TRIM() functions. Relativity between LOGICAL conditions and EXACT() function in a case sensitive manner. Thorough understanding of AMBPERCENT[&] to join columns together with DOLLAR() function.

Section 16

Statistical Functions
Multiple ways to use AVERAGE() and COUNT() function in Excel. Use COUNTIF() function on a single criteria and pull values using IF() within SUMIF() functions, combine it with ARRAY formula to make it powerful. When to use AVERAGEIF() function.

Section 17

Logical Functions
Learn the power of Logical Statement that evaluates to TRUE and FALSE using AND() and OR() functions. Use IF() function to calculate the cumulative totals, define different value sets, hardcode a massage in double quotes.

Section 18

Date and Time Functions
Five different techniques of using DATE and TIME functions; Learn YEAR(), MONTH(), DAY() and TEXT() functions to achieve desired results.

Section 19

Math and Trigonometry Functions
Use SUMIF() function and define CELL Reference within the example; Learn the new SUMPRODUCT() function that make tasks simpler.

Section 20

Find and Lookup Functions
Learn few of most important and frequently used Excel functions. Different LOOKUP() techniques using Approximate and Exact match; Two different techniques of using TRANSPOSE() function [Array Formula]; Pull values from various worksheets using simple INDIRECT() function; Combine HLOOKUP() with SUMPRODUCT in Array Form to pull values from a single and multiple ROWS.

Section 21

Array Formulas
Learn principles or ARRAY{} formula; How to connect various Columns and Rows using AMBPERCENT[&]; Learn the art of CNTRL + SHIFT + ENTER in an ARRAY context; Get the desired results through ARRAY Formula!

Section 22

Database Features
Make your data dynamic using TABLE feature; Learn how to use TEXT to STRING functionality and combine it with CONCATENATE() function.

Section 23

Validations Techniques
How to create DROPDOWN and LIST in Excel; What are CONTROL BUTTONS, CHECK BOX for; Learn some other data validation techniques.

Section 24

Conditional Formatting

Learn the art of CONDITIONAL FORMATTING TECHNIQUES using 9 various examples.

Section 25

Macros
Automate frequent used tasks by recording MACRO; Learn MACRO file saving technique; Activate Developer Ribbons; Add and assign buttons to MACRO.

Section 26

Pivot Tables
Make large dataset interactive and create PIVOT TABLES; Learn how to define DATASOURCE; What are major Pivot Table Fields; How to make interactive reports using PIVOT TABLE; Learn STYLING techniques; Introducing TWO more new Ribbon TABs.

Section 27

Pivot Charts
What is PIVOT CHARTs? How to display data interactively using Pivot Charts; Link Chart Titles with the PIVOT TABLE, Formatting technique and much more.

Section 28

Charts and Graphs
How to create charts in Excel; Learn the fundamentals of Charts; What is a series?; What are axis?; Learn different types of charts in Excel.

Section 29

Whatif Scenarios
Take you knowledge beyond next level using WHAT-IF Analysis; Create various Mortgage Payment scenario by creating interactive Mortgage Calculator using PMT() function and DATA TABLE functionality.
© Copyright 2016 | All Rights Reserved.