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

 

Formatting in Ms-Excel

Formatting in Ms-Excel

In this video, we are going to learn basic formatting in Microsoft Excel:

 

  • Bold
  • Italic
  • Underline
  • Font type
  • Font size
  • Colors
  • Borders
  • Text alignment
  • Copying formatting
  • Keyboard shortcuts

Basic calculation in Ms-Excel

Basic calculation in Ms-Excel

In this video, we are going to learn, with a practical exercise, how to effectively use the four basic operations in Microsoft Excel:

 

  • Adding values
  • Multiplying values
  • Subtracting values
  • Dividing values
  • Using percentage
  • Splitting lines in a cell
  • Applying formatting

 

error: Content is protected !!