Excel Training – A First Look in Excel 

Excel Training : Starting the Excel program

What is the Active Cell?

The Excel cell referencing system

Entering numbers and text

Default text and number alignment

Adding a column of numbers

Worksheets and Workbooks

Saving a workbook

Closing a workbook

Creating a new workbook

Opening a workbook

Switching between workbooks

Saving a workbook using another name

Saving a workbook using a different file type

Selection Techniques

Why are selection techniques important?

Selecting a cell

Selecting a range of connecting cells

Selecting a range of non-connecting cells

Selecting the entire worksheet

Selecting a row

Selecting a range of connecting rows

Selecting a range of non-connected rows

Selecting a column

Selecting a range of connecting columns

Selecting a range of non-connecting columns

Manipulating Rows & Columns

Inserting rows into a worksheet

Inserting columns into a worksheet

Deleting rows within a worksheet

Deleting columns within a worksheet

Modifying column widths

Modifying column widths using ‘drag and drop’

Automatically resizing the column width to fit contents

Modifying row heights

Copying,Moving & Deleting

Copying the cell or range contents

Deleting cell contents

Moving the contents of a cell or range

Editing cell content

Undo and Redo

AutoFill

Sorting a cell range

Searching and replacing data

Manipulating Worksheets

Switching between worksheets

Renaming a worksheet

Inserting a new worksheet

Deleting a worksheet

Copying a worksheet within a workbook

Moving a worksheet within a workbook

Copying or moving worksheets between workbooks

Font Formating

Font type

Font size

Bold, italic, underline formatting

Cell border formatting

Formatting the background colour

Formatting the font colour

Alignment Formatting

Aligning contents in a cell range

Centering a title over a cell range

Cell orientation

Text wrapping

Format painter

Number Formatting

Number formatting

Decimal point display

Comma formatting

Currency symbol

Date styles

Percentages

Freezing Row & Column Titles

Freezing row and column titles

Formulas 

Creating formulas

Easy way to create formulas

Copying formulas

Operators

Formula error messages

Cell Referencing

Relative cell referencing within in formulas

Absolute cell referencing within formulas

Function

What is a function?

Common functions

Sum function

Average function

Max function

Min function

Count function

What are ‘IF functions’?

Using the IF function

Using Charts

Inserting a column chart

Inserting a line chart

Inserting a bar chart

Inserting a pie chart

Resizing a chart

Deleting a chart

Chart title or labels

Chart background colour

Changing a column, bar, line or pie slice colours

Changing the chart type

Modifying Charts using the Layout tab

Copying and moving charts within a worksheet

Copying and moving charts between worksheets

Copying and moving charts between workbooks

Customizing Excel

Modifying basic options

Minimising the Ribbon

AutoCorrect options

Worksheet Setup

Worksheet margins

Worksheet orientation

Worksheet page size

Headers and Footers

Header and footer fields

Scaling your worksheet to fit a page(s)

Manipulating Data,Named Ranges & Templates

Paste Special Techniques

Importing a text file and delimiting

Subtotals

Creating subtotals

Removing subtotals

Advanced Formatting & Display Techniques

Cell Styles

Table Styles

Conditional Formatting

Custom number formats

Freezing row and column titles

Hiding and un-hiding rows and columns

Hiding / un-hiding worksheets

Sorting & Querying Data

Sorting data by multiple columns

Custom sorts

Using AutoFilter

Using advanced query / filter options

Subtotal, consolidate

Workbook Password Protection

Password for opening a workbook

Read-only recommended

Using One-Input or Two-Input Data Tables / What-If Tables

One input Data Table command

Two input data table command

A First Look at Pivot Tables

Creating a Pivot Table

Dropping data into the Pivot Table

Modifying data and refreshing a Pivot Table

Grouping data within a Pivot table

Scenarios

Creating named Scenarios from defined cell ranges

Viewing an alternative scenario

Creating a scenario summary

Auditing

Tracing precedent cells

Tracing dependents of a cell

Displaying all formulas within a worksheet

Using comment

Lookup

HLookup Function

VLookup Function

Preparing to Print a Worksheet

Visually check your calculations

Gridline display when printing

Printing titles on every page when printing

Printing the Excel row and column headings

Spell checking

Previewing a worksheet

Comparing Workbooks side by side

Zooming the view

Printing options

Duration & Timings :

Duration – 30 Hours.

Training Type: Instructor Led Online Live Interactive Training.

Faculty: Experienced.

Access to Class Recordings.

For Upcoming Schedules Please  Contact Us 

Excel is registered trademarks of the Microsoft Corporation Inc.

 Inquiry Now         Discount Offer 

USA: +1 734 418 2465 | India: +91 40 4018 1306