Working With Microsoft Excel (Beginner & Intermediate) : 3Days
  • Working With Microsoft Excel (Beginner & Intermediate) : 3Days

Working With Microsoft Excel (Beginner & Intermediate) : 3Days

  • Product Code: Workshop
  • Reward Points: 2
  • Availability:In Stock


Ex Tax: ₦40,000

Price in reward points: 10

Excel Essentials

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. The participants will learn how to use the basic features of Excel. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer. 

With Excel, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information – and better information leads to better decision making!

Course Outline:

Module One: Getting Started


Housekeeping Items

The Parking Lot

Workshop Objectives

Module Two: Opening and Closing Excel

Opening Excel

Understanding the Interface

Using Backstage View

Understanding Worksheets

Understanding Workbooks

Module Three: Your First Worksheet

Entering Data

Editing Data

Using the Wrap Command

Adding Rows and Columns

Checking Your Spelling

Module Four: Working with Excel Files

Saving Files

Publishing Files to PDF

Sending Files via E-Mail

Closing Files

Opening Files

Module Five: Viewing Excel Data

An Overview of Excel’s Views

Switching Views

Creating Custom Views

Using Zoom

Switching Between Open Files

Module Six: Printing Excel Data

An Overview of the Page Layout Tab

Setting Up Your Page

Using Print Preview

Printing Data

Module Seven: Building Formulas

The Math Basics of Excel

Building a Formula

Editing a Formula

Copying a Formula

Relative vs. Absolute References

Module Eight: Using Excel Functions

Formulas vs. Functions

Using the SUM Function

Using Other Basic Excel Functions

Understanding the Formulas Tab

Using the Status Bar to Perform Calculations

Understanding the New Function Names

Module Nine: Using Time Saving Tools

Using AutoFill

Using AutoComplete

Sorting Data

Filtering Data

Adding Sparklines

Module Ten: Formatting Your Data

Changing the Appearance of Text

Changing the Appearance of Numbers

Setting Alignment Options

Using Merge

Removing Formatting

Module Eleven: Advanced Formatting Tools

Adding Borders

Adding Fill Color

Using Cell Styles

Using Conditional Formatting

Changing the Theme

Module Twelve: Wrapping Up

Words from the Wise

Review of Parking Lot

Lessons Learned

Completion of Action Plans and Evaluations

Reviews (0)

Write a review

Note: HTML is not translated!

    Bad           Good