
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.
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
Chapter 6
Working with Data
Learn more about Sorting with Excel Data, Freeze Panes in Excel and Use of Excel Filters