Microsoft Excel

## Absolute formulas in Ms-Excel

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

• Relative Formulas
• Absolute formulas
• Huge benefits of using absolute formulas

Continue Reading

## 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

Continue Reading

## 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

Continue Reading

## Summation in Ms-Excel

In this video, we are going to learn, with a practical exercise, how 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

Continue Reading

## 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

Continue Reading

## 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

Continue Reading

## 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

Continue Reading

## 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

Continue Reading

©shBW - Copyright 2019