MS Excel Basic and Intermediate

automotiveTimings : 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

Hi! Click one of our representatives below to chat on WhatsApp or send us email to info@piiq-edu.org

Chat with us on WhatsApp
Close and go back to page
No Internet Connection