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

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

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

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

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

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

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

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

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

# Get the book about China!

### and having experiences in China.

(See Table of Content) # Get the book about All Prepositions in Spanish!

### You can get the book about All prepositions in Spanish which includes 427 examples.

(See Table of Content) 