Basic Microsoft Excel

Categories: Microsoft Execl
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

 

Course Overview:

From this course you will learn the basics of creating spreadsheets in Excel. Enter data, formulas, format and print workbooks.

 

Class – 01 [Getting Started]
  • Starting Excel
    Opening a Workbook
    Understanding the Display Screen
    Working with the Ribbon
    Exploring the File Tab
    Working with the Quick Access Toolbar
    Working with the Status Bar
    Switching Between Opened Workbooks
    Using Excel Help

Class – 01 [Entering Data]
Moving the Cell Pointer
Selecting a Range of Cells
Creating a New Workbook
Inserting, Renaming, and Deleting Worksheets
Entering Constant Values
Using Auto Fill to Enter Data
Saving a Workbook
Editing Cell Contents
Clearing Cell Contents
Working with Undo and Redo
Closing a Workbook

Using Formulas
Entering Formulas
Using Auto Fill with Formulas
Using the SUM Function
Summing Columns or Rows Automatically
Using Statistical Functions
Working with the Range Finder
Using Formula Error Checking

Working with Constant Values and Formulas
Copying and Pasting Constant Values and Formulas
Cutting and Pasting Constant Values and Formulas
Using Collect and Paste

Formatting Worksheets
Formatting Numbers
Changing the Font Format
Aligning Cell Contents
Merging Cells
Adding Borders
Applying Cell Styles

Modifying Columns and Rows
Changing Column Width
Changing Row Height
Inserting and Deleting Columns or Rows
Hiding Columns or Rows

Editing Workbooks
Working with AutoCorrect
Checking Spelling
Using Find and Replace

Printing Worksheets
Using Print Preview
Working with Print Settings
Using Page Setup Tools
Working in Page Layout View
Creating a Header and Footer
Using Page Break Preview
Printing a Worksheet
Exiting Excel

Show More

Course Content

Shopping Cart