MS Excel Basic and Intermediate

Timings : Friday 11:00 AM - 02:00 PM
Duration : 10 Weeks
Fee : QAR 500.00
Uniform : QAR 30.00

Click Here to Enroll

Course Outline

LESSON 1 – Getting Started

• Identify the Elements of the Excel Interface
• Create a basic worksheet
• Using the Help System

LESSON 2 – Performing Calculations

• Create Formulas
• Inserting Functions
• Reusing Formulas

LESSON 3 – Modifying Worksheets

• Manipulate data
• Insert, manipulate, and delete cells, columns, and rows
• Search for and replace data
• Spell check a worksheet

LESSON 4 – Formatting a  Worksheet

• Modify fonts
• Add borders and colors to cells
• Apply number formats
• Align cell contents
• Apply cell styles

LESSON 5 – Printing Workbook Contents

• Define the basic page layout for a workbook
• Refine the page layout and apply print options

LESSON 6 – More on Formulas and Functions 1

• Summarizing Data
• • Counting with Criteria (COUNT, COUNTIF)
  • Adding with Criteria (SUM, SUMIF)
• Multiple Worksheets
• • Absolute References
  • Linking Workbooks
  • Consolidating Data
  • 3D Formulas
• Arranging Data
• Filter & Sort
• Conditional Formatting
• Data Validation & Lists
• Text to Columns

LESSON 7 – More on Formulas and Functions 2

• Text and Dates
  • Combining Text (CONCAT, &)
  • Date Calculations (NOW, TODAY)
• Arguments in Formulas
  • IF and OR statements
  • ISBLANK / IFERROR
• Searching for Data
  • VLOOKUP
  • Find and Replace
• Working with Tables
  • Creating and Formatting Tables
  • Named Ranges

LESSON 8 – Pivot Tables

• Working with Pivot Tables
• Advanced Filtering and Sorting
• Using Pivot Tables in Reports

LESSON 9 – Arranging Data

• Working with Large Data
• Data Manipulation and Analysis

LESSON 10 – Charts & Reports Generation

• Working with Charts
• How to Present Data & Prepare Reports