What are you going to learn?

This course will give help you to under Microsoft Excel Basics, Various Excel Components definition and how you can use those in various data reporting purposes. Also we covered how to enter, format data, adding charts, various data analysis features, printing with excel etc.

Prequisites

Basic Computer Knowledge

Microsoft Office Installed (Excel Installed)

Have good Internet connection

Chapter 1

Opening an Excel File

Here you will learn different method how you can Open Excel Files.

Chapter 2

Excel Interfaces

Here we are going to explain how you work on different Excel Windows and its feature which you may use while working with excel file. This Excel Lesson is gonna help you to identify the components of the Application & Workbook Window.

Chapter 3

Cell Basics and It’s Formatting

Whenever working with Excel, you will enter information, or content, into cells. Cells are the basic building blocks of a worksheet. Here you will learn the basics of cells and cell content to calculate, analyze, and organize data in Excel.

Chapter 4

Modifying Columns, Rows, Cells

This chapter will help you to understand how you can modify Excel Rows, Insert Columns, Change Cell attributes in excel, Add & Rename Excel Sheets, Move or Copy Excel Sheets etc.

Topic List
Inserting, Deleting, Moving, Hiding Rows & Columns
Resizing the Columns, Rows

Chapter 5

Formulas and Functions

One of the most powerful features in Excel is the ability to calculate numerical information using formulas This chapter covers

Topic List
Relative and Absolute Cell References
Simple and Complex Formulas
Functions and its library

Chapter 6

Working with Data

Learn more about Sorting with Excel Data, Freeze Panes in Excel and Use of Excel Filters

Topic List
Entering Data
Freezing Pain
Sorting Data
Filtering the Data
Creating Dropdowns