Manipulating Sheets in Ms-Excel

Manipulating Sheets in Ms-Excel

In this video, we are going to learn how to manipulate Sheets in Microsoft Excel:

 

  • Creating Sheets
  • Renaming Sheets
  • Copying Sheets
  • Deleting Sheets
  • Moving Sheets
  • Inserting rows
  • Deleting rows
  • Inserting columns
  • Deleting columns
  • Assigning colors to Sheets
  • Doing simultaneous actions in several Sheets

 

Three operations in Ms-Excel

Three operations in Ms-Excel

In this video, we are going to learn, with a practical exercise, how multiply, subtract, and divide in Microsoft Excel:

 

  • Multiplying values in different ways
  • Subtracting values
  • Dividing values in different ways
  • Creating formulas
  • Modifying formulas
  • Copying formulas
  • Advantages of using formulas

 

Summation in Ms-Excel

Summation in Ms-Excel

In this video, we are going to learn, with a practical exercise, how to sum in Microsoft Excel:

 

  • Sum values using the AutoSum function
  • Sum values using the Sum() function by highlighting the cell range
  • Sum values using the Sum() function by clicking on each cell addresses
  • Sum values using the Sum() function by typing the initial and end cell addresses
  • Sum values by typing each cell address

 

Manipulating cell content in Ms-Excel

Manipulating cell content in Ms-Excel

In this video, we are going to learn how to manipulate cell content in Microsoft Excel:

 

  • Entering content in cells
  • Modifying cell content
  • Renaming Sheets
  • Creating Books
  • Copying cell content among Cells, Sheets and Books
  • Moving cell content among Cells, Sheets and Books
  • Deleting cell content
  • Content alignment

 

Rows and Columns in Ms-Excel

Rows and Columns in Ms-Excel

In this video, we are going to learn how to work with rows and columns in Microsoft Excel:

 

  • Rows
  • Columns
  • Cells
  • Creating sheets
  • Cells identification
  • Total rows and columns
  • Moving to specific cells
  • Modifying cell content
  • Managing row height
  • Managing column width

 

error: Content is protected !!