Timings : Friday 11:00 AM - 02:00 PM
Duration : 10 Weeks
Fee : QAR 500.00
Uniform : QAR 30.00
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