Boost Your Microsoft Excel Skills schedule

Schedule

Session 1

Introduction

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Data Entry 1

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Data Entry 2

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Creating Formulas

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Comment & Saving

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Practice Exercise 1

Al-munthir Saffan

04 Feb 2018 12:00 AM

14 Feb 2018 11:55 PM

Session 2

Tables

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Filter

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Sort

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Format Data

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Practice Exercise 2

Al-munthir Saffan

11 Feb 2018 12:00 AM

21 Feb 2018 11:52 PM

Session 3

IF Formula

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Conditional Formatting

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Reference cells

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Deal with Data

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Practice Exercise 3

Al-munthir Saffan

18 Feb 2018 12:00 AM

28 Feb 2018 11:00 PM

Session 4

Charts

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Charts II

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Sparklines

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

IF Function

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

IF function with the AND, OR functions

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Practice Exercise 4

Al-munthir Saffan

25 Feb 2018 12:00 AM

07 Mar 2018 11:00 PM

Session 5

Pivot Table

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Pivot Table II

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Pivot Table III

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Practice Exercise 5

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Session 6

COUNTIF

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

COUNTIFS

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Statistical Equations-COUNTIFS

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Statistical Equations- SUMIF&SUMIFS

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Statistical Equations- Pivot Table

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Practice Exercise 6

Al-munthir Saffan

11 Mar 2018 12:00 AM

21 Mar 2018 11:00 PM

Session 7

Data Validation

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Text to Columns

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Link Data

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Remove Duplicates

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Goal Seek

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Practice Exercise 7

Al-munthir Saffan

18 Mar 2018 12:00 AM

28 Mar 2018 11:00 PM

Session 8

Vlookup

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Link Papers and Work Files

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Print and Document Layout Tools

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Document Protection Tools

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Practice Exercise 8

Al-munthir Saffan

25 Mar 2018 12:00 AM

04 Apr 2018 11:00 PM

Session 9

Macro

Al-munthir Saffan

01 Apr 2018 12:00 AM

07 Apr 2018 11:00 PM

Making Interactive buttons using Macro

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

VBA

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Examples of Prefix Codes

Al-munthir Saffan

04 Feb 2018 12:00 AM

21 Apr 2018 11:00 PM

Practice Exercise 9

Al-munthir Saffan

01 Apr 2018 12:00 AM

07 Apr 2018 11:00 PM