Microsoft Excel Level 1 (Beginner)

About Course

This Microsoft Excel Level 1 (Beginner) course is designed to get you up and running with the world’s most popular spreadsheet software. You will learn the essential skills needed to create, format, and manage workbooks effectively. From navigating the interface and entering data to building basic formulas and printing your work, this course provides a solid foundation for anyone new to Excel.

Navigate the Excel interface confidently, using the Ribbon, Quick Access Toolbar, and Formula Bar.
Create, save, and manage workbooks, including opening existing files and creating new ones from templates.
Enter, edit, and format all types of data, including text, numbers, dates, and special characters.
Build powerful formulas using cell references and essential functions like SUM, AVERAGE, MIN, and MAX.
Format worksheets professionally by adjusting cells, rows, columns, number formats, and preparing them for printing.

Course Content

Module 1: Excel Orientation

Lesson 1: Starting Excel
Lesson 2: The Excel Screen
Lesson 3: Using the Menu/Ribbon
Lesson 4: Using Key Tips
Lesson 5: Using Shortcut Menus
Lesson 6: Understanding Dialog Boxes
Lesson 7: Launching Dialog Boxes
Lesson 8: The Quick Access Toolbar
Lesson 9: Using The Formula Bar And Status Bar
Lesson 10: Exiting Safely From Excel

Module 2: Working With A Workbook

Lesson 1: The Open Dialog Box
Lesson 2: Opening An Existing Workbook
Lesson 3: Navigating With The Keyboard
Lesson 4: Scrolling Through A Worksheet
Lesson 5: Understanding Worksheet Views
Lesson 6: Changing Worksheet Views
Lesson 7: Page Zooming
Lesson 8: Viewing Gridlines And Headings
Lesson 9: Previewing A Workbook
Lesson 10: Counting Cells With Data
Lesson 11: Saving And Closing A Workbook

Module 3: Creating A New Workbook

Module 4: Working With Cells

Lesson 1: Techniques For Selecting Cells
Lesson 2: Selecting Cells Using The Mouse
Lesson 3: Selecting Cells Using The Keyboard
Lesson 4: Selecting Rows And Columns
Lesson 5: Selecting Entire Worksheet
Lesson 6: Editing In Insert Mode
Lesson 7: Editing In Overtype Mode
Lesson 8: Deleting Cell Contents
Lesson 9: Using Undo And Redo
Lesson 10: Using Repeat
Lesson 11: Using AutoFill (Fill Handle)
Lesson 12: Inserting Special Characters
Lesson 13: Understanding Find And Replace
Lesson 14: Finding Words And Numbers
Lesson 15: Replacing Words And Numbers

Module 5: Cutting, Copying, And Pasting

Module 6: Formatting Cells

Lesson 1: Understanding Font Formatting
Lesson 2: Working With Live Preview
Lesson 3: Changing Fonts And Font Size
Lesson 4: Making Text Bold, Italicizing, And Underlining
Lesson 5: Changing Text Color
Lesson 6: Changing Fill Color (Background)
Lesson 7: Adding Borders To Cells
Lesson 8: Using The Format Painter
Lesson 9: Clearing Cell Formatting
Lesson 10: Merging And Centering Cells
Lesson 11: Wrapping Text In Cells

Module 7: Number Formatting And Alignment

Lesson 1: Understanding Number Formatting
Lesson 2: Applying General Format
Lesson 3: Applying Currency Format
Lesson 4: Applying Percentage Format
Lesson 5: Applying Comma Style (Thousands Separator)
Lesson 6: Increasing And Decreasing Decimals
Lesson 7: Text Alignments (Left, Center, Right)
Lesson 8: Vertical Alignment (Top, Middle, Bottom)
Lesson 9: Indenting Cell Contents
Lesson 10: Rotating Text Orientation

Module 8: Working With Columns And Rows

Lesson 1: Changing Column Width
Lesson 2: AutoFitting Column Width
Lesson 3: Changing Row Height
Lesson 4: AutoFitting Row Height
Lesson 5: AutoFitting Row Height
Lesson 6: Inserting Columns And Rows
Lesson 7: Deleting Columns And Rows
Lesson 8: Hiding And Unhiding Columns
Lesson 9: Hiding And Unhiding Rows

Module 9: Basic Formulas

Lesson 1: Understanding Formulas
Lesson 2: Creating A Formula Using Cell References
Lesson 3: Using Mathematical Operators (+, -, *, /)
Lesson 4: Using The SUM Function (AutoSum)
Lesson 5: Using The AVERAGE Function
Lesson 6: Using The MIN And MAX Functions
Lesson 7: Using The COUNT Function
Lesson 8: Copying Formulas To Other Cells
Lesson 9: Understanding Relative Cell References
Lesson 10: Viewing Formulas Vs. Results

Module 10: Printing

Lesson 1: Understanding Printing
Lesson 2: Print Previewing
Lesson 3: Quick Printing
Lesson 4: Selecting A Printer
Lesson 5: Printing The Current Worksheet
Lesson 6: Printing A Specific Range
Lesson 7: Specifying The Number Of Copies
Lesson 8: Adjusting Page Margins
Lesson 9: Changing Page Orientation
Lesson 10: Scaling To Fit (Width, Height)

Module 11: Managing Worksheets

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Module 1: Excel Orientation

Lesson 1: Starting Excel

Lesson 2: The Excel Screen

Lesson 3: Using the Menu/Ribbon

Lesson 4: Using Key Tips

Lesson 5: Using Shortcut Menus

Lesson 6: Understanding Dialog Boxes

Lesson 7: Launching Dialog Boxes

Lesson 8: The Quick Access Toolbar

Lesson 9: Using The Formula Bar And Status Bar

Lesson 10: Exiting Safely From Excel

Module 2: Working With A Workbook

Lesson 1: The Open Dialog Box

Lesson 2: Opening An Existing Workbook

Lesson 3: Navigating With The Keyboard

Lesson 4: Scrolling Through A Worksheet

Lesson 5: Understanding Worksheet Views

Lesson 6: Changing Worksheet Views

Lesson 7: Page Zooming

Lesson 8: Viewing Gridlines And Headings

Lesson 9: Previewing A Workbook

Lesson 10: Counting Cells With Data

Lesson 11: Saving And Closing A Workbook

Module 3: Creating A New Workbook

Lesson 1: Creating Workbooks in Excel

Lesson 2: Using The Blank Workbook Template

Lesson 3: Typing Text And Numbers

Lesson 4: Inserting A Date

Lesson 5: Saving a New Workbook

Lesson 6: Printing A Worksheet

Lesson 7: Safely Closing A Workbook

Module 4: Working With Cells

Lesson 1: Techniques For Selecting Cells

Lesson 2: Selecting Cells Using The Mouse

Lesson 3: Selecting Cells Using The Keyboard

Lesson 4: Selecting Rows And Columns

Lesson 5: Selecting Entire Worksheet

Lesson 6: Editing In Insert Mode

Lesson 7: Editing In Overtype Mode

Lesson 8: Deleting Cell Contents

Lesson 9: Using Undo And Redo

Lesson 10: Using Repeat

Lesson 11: Using AutoFill (Fill Handle)

Lesson 12: Inserting Special Characters

Lesson 13: Understanding Find And Replace

Lesson 14: Finding Words And Numbers

Lesson 15: Replacing Words And Numbers

Module 5: Cutting, Copying, And Pasting

Lesson 1: Understanding Cutting And Copying

Lesson 2: Cutting And Pasting Cells

Lesson 3: Copying And Pasting Cells

Lesson 4: Drag And Drop Cutting

Lesson 5: Drag And Drop Copying

Lesson 6: Using The Clipboard Task Pane

Lesson 7: Using Paste Special (Values, Formats)

Lesson 8: Copying To Multiple Cells

Module 6: Formatting Cells

Lesson 1: Understanding Font Formatting

Lesson 2: Working With Live Preview

Lesson 3: Changing Fonts And Font Size

Lesson 4: Making Text Bold, Italicizing, And Underlining

Lesson 5: Changing Text Color

Lesson 6: Changing Fill Color (Background)

Lesson 7: Adding Borders To Cells

Lesson 8: Using The Format Painter

Lesson 9: Clearing Cell Formatting

Lesson 10: Merging And Centering Cells

Lesson 11: Wrapping Text In Cells

Module 7: Number Formatting And Alignment

Lesson 1: Understanding Number Formatting

Lesson 2: Applying General Format

Lesson 3: Applying Currency Format

Lesson 4: Applying Percentage Format

Lesson 5: Applying Comma Style (Thousands Separator)

Lesson 6: Increasing And Decreasing Decimals

Lesson 7: Text Alignments (Left, Center, Right)

Lesson 8: Vertical Alignment (Top, Middle, Bottom)