Microsoft Excel

By bitizens.net Categories: Computing & Informatics

Wishlist

About Course

0505 | MEX

Modifying Columns, Rows, and Cell
Formatting Cells
Understanding Number Formats
Working with Multiple Worksheets
Using Find & Replace
Page Layout and Printing
Formulas and Functions
Creating More Complex Formulas
Relative and Absolute Cell References
Functions
Working with Data
Freezing Panes and View Options
Sorting Data
Filtering Data
Groups and Subtotals
Tables
Charts
Conditional Formatting
Inspecting and Protecting Workbooks
Intro to Pivot Tables
What-if Analysis

Course Content

Introduction to Excel

Microsoft Excel

00:00

Modifying Columns, Rows, and Cell

Modifying column width

00:00
AutoFit column width

00:00
Modify Row Height

00:00
Modify all Rows or Columns

00:00
Inserting, Deleting, Moving, and Hiding Cell

00:00
Deleting a Row or Column

00:00
Moving Row and Column

00:00
Hide and Unhide a Row or Column

00:00
Wrap Text Automatically

00:00
Merge cells in Excel

00:00

Understanding Number Formats

Working with Multiple Worksheets

Using Find & Replace

Page Layout and Printing

Formulas and Functions

Relative and Absolute Cell References

Functions

Freezing Panes and View Options

Sorting Data

Groups and Subtotals

Tables

Charts

Conditional Formatting

Inspecting and Protecting Workbooks

Pivot Tables

What-if Analysis

Assessment
This Test Assess your understanding of Microsoft Excel for the topics covered so far in this course and it counts as part 1 of 2 of the entire course assessment toward a Certificate in the course

Student Ratings & Reviews

No Review Yet

Microsoft Excel

About Course

What Will You Learn?

Course Content

Introduction to Excel

Microsoft Excel

Modifying Columns, Rows, and Cell

Modifying column width

AutoFit column width

Modify Row Height

Modify all Rows or Columns

Inserting, Deleting, Moving, and Hiding Cell

Deleting a Row or Column

Moving Row and Column

Hide and Unhide a Row or Column

Wrap Text Automatically

Merge cells in Excel

Understanding Number Formats

Number Formats

Working with Multiple Worksheets

Working with Multiple Worksheets

Using Find & Replace

Using Find & Replace

Page Layout and Printing

Page Layout and Printing

Formulas and Functions

Introduction to Formulas

Order of Operations

Relative and Absolute Cell References

Relative References

Absolute References

Functions

Terms in Excel

Arguments

Formulas and Functions Practical Exercises

Freezing Panes and View Options

Freezing Rows and Columns

Sorting Data

Single Level Data Sorting

Multi-Level Data Sorting

Sorting Dates Data

Filtering Data

Groups and Subtotals

Groups and Subtotals

Tables

Creating Tables

Charts

Creating a Chart

Excel Bar Charts

Conditional Formatting

Conditional Formatting

Inspecting and Protecting Workbooks

Pivot Tables

Pivot Tables

What-if Analysis

What-If Analysis with Data Tables in Excel

Assessment This Test Assess your understanding of Microsoft Excel for the topics covered so far in this course and it counts as part 1 of 2 of the entire course assessment toward a Certificate in the course

Excel CA-P1

Student Ratings & Reviews

Your Instructor

bitizens.net

Related Courses

Food Science 101

ICT (CGCE Syllabus)

Web Design & Development

Assessment
This Test Assess your understanding of Microsoft Excel for the topics covered so far in this course and it counts as part 1 of 2 of the entire course assessment toward a Certificate in the course