Excel : Data Manipulation FINANCEWALK

Excel : Data Manipulation

In Data Manilpulation module, we will see basics of navigation in Excel, how to deal with rows/columns/cells and worksheets as a whole.
We will also see how to switch between different workbooks, worksheets, how to insert/delete/rename worksheets.
Overview
In this chapter, we will see things that we are going to cover as well as the one's that are not in the scope of this module. Finally, we will have a look at the important points to be remembered throughout the Excel module.
Basic Shortcuts-I
In this chapter, we will see some of the basic shortcuts for navigation in Excel,how to create, open, close files. We will also see how to switch between different worksheets as well as different workbooks.
Basic Shortcuts-II
In this chapter, we will see some more shortcuts for navigation in Excel.
Working with Rows and Columns
In this chapter, we will see how to deal with rows and columns. We will cover features like how to select, insert,delete rows and columns.
Working with Cells (Edit & Delete)
In this chapter, we will see how to deal with individual cells in an Excel worksheet. We will cover how to edit, delete as well few other features related to cells.
Group and Hide
In this chapter, we will see how to group, ungroup, hide and unhide rows and columns in Excel.
Freeze and Zoom
In this chapter, we will learn the Freeze and Zooming features in Excel.
Workbook and Worksheets-I
In this first part of Workbook and Worksheet, we will see features like creating a new workbook, inserting,deleting,moving worksheets, to name a few.
Workbook and Worksheets-II
In this part of Workbook and Worksheet, we will see some more features like hide,unhide, rename, color a worksheet.
Naming Cells
In this chapter, we will cover the naming feature in Excel. We will also see how to jump to the named cell.

Login to your account below

Fill the forms bellow to register

Retrieve your password

Please enter your username or email address to reset your password.

>

Get Equity Research Career Guide For Free