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.
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.
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.
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.
In this chapter, we will cover the naming feature in Excel. We will also see how to jump to the named cell.