Basic Ms Excel

In-Person/Online

3 Days

English/Arabic

Learning Objectives

Automate some common excel tasks.
Collaborate on worksheets.
Work with excel functions and formulas.
Secure excel data, files & sheets.
Explore how to analyze data sets and sorting pivot table data.
Discover how to filter data list.
Use conditional formatting to white out errors.
Identify financial formulas and statistical functions.

In-Person/Online

3 Days

English/Arabic

Learning Objectives

Define what is leadership and what is the skill set of an effective leader.
Differentiate between leadership and management.
Discuss resilience

ypes and their impact on leaders.
Identify the four pillars of the resilient leadership model.
Use growth mindset in leading collaborative team.
Apply on taking initiatives in the workplace.

Modules

Module 1: Setting Up A Workbook

Creating and workbooks
Customizing the excel program window
Zooming in a worksheet
Arranging multiple workbook windows
Adding buttons to the quick access toolbar
Customizing the ribbon
Maximizing useable space in the program window

Module 2: Printing

Adding headers and footers to printed pages
Preparing and previewing worksheets for printing
Changing page breaks in a worksheet
Changing the page printing order for worksheets

Module 3: Performing Calculations on Data

Naming groups of data
Creating formulas to calculate values
Summarizing data that meets specific conditions
Finding and correcting errors in calculations

Module 4: Focusing on Specific Data by Using Filters

Limiting data that appears on your screen
Manipulating worksheet data
Selecting list rows at random
Summarizing worksheets with hidden and filtered rows
Finding unique values within a data set
Defining valid sets of values for ranges of cells

Module 5: Reordering and Summarizing Data

Sorting worksheet data
Organizing data into levels
Looking up information in a worksheet

Module 6: Combining Data Form Multiple Sources

Using workbook as templates for other workbooks
Linking to data in other worksheets and workbooks
Consolidating multiple sets of data into a single workbook
Grouping multiple sets of data

Module 7: Financial Formulas

Financial functions
The PV, NPV, and FV functions
The PMT function.
Depreciation functions
Analysis toolpak financial functions

Module 8: Math and Statistical Formulas

Math & trig functions
Statistical functions

Module 9: Lookup, Information, and Text Formulas

Lookup and reference

Module 10: Performing Large-Scale Data Analysis

Creating pivot tables
Formatting a pivot table
Sorting and filtering the pivot table data
Modifying the pivot table
Creating pivot charts
Using the power pivot add-in
Using the 3D map feature
Creating forecast worksheets

Module 11: Filtering and Querying A Data List

Data list filtering
Filtering data
Using the database functions
External data query

Basic Ms Excel

Learning Objectives

Learning Objectives

Modules

Module 1: Setting Up A Workbook

Module 2: Printing

Module 3: Performing Calculations on Data

Module 4: Focusing on Specific Data by Using Filters

Module 5: Reordering and Summarizing Data

Module 6: Combining Data Form Multiple Sources

Module 7: Financial Formulas

Module 8: Math and Statistical Formulas

Module 9: Lookup, Information, and Text Formulas

Module 10: Performing Large-Scale Data Analysis

Module 11: Filtering and Querying A Data List

Our Partners

Quick links

Quick links

Welcome to our beta version!