Boost Your Microsoft Excel Skills

Introduction

If you do a lot of work in Excel, you know that errors can easily occur into your data. Even a small error can have large consequences. In this concise course, Excel expert Al-Munthir Saffan provides quick and easy tips to help you use the tools in excel and prevent errors from occurring. Al-Munthir begins with the basics—how to display data so that errors can be easily spotted. Next, he offers advanced data entry, and how to create formulas, tables, how to filter, sort and validate your data, and more.

This course provides you everything you need to know about Microsoft Excel. Don't wait too long, join the course and start learning now!

Main theme

This recoded course consist of several sessions. Each session is about 10 mins long, followed by a practice exercise to test that you have learned the material. Each practice exercise include a deadline to help you stay on track. In order to participate in the hands-on portions of this course, you will need to have Microsoft Excel. The course is offered in sessions, every 7 days a new session can be accessed and learners in the same session move through the course together. To see when the next session will begin for this course, check the course schedule section on the top right. You can also discuss your concerns in the discussion section on the top right corner.

Goals and Objectives

By the end of this course, candidates should be able to:
- Navigate around Excel
- Validate Data
- Write formulas easily with the point-and-click method
- Create powerful calculations with Excel functions
- Visually represent your data with charts and graphs in Excel

This Course For :

All Healthcare Providers

Schedule

Introduction

Al-munthir Saffan

04 Feb 2018

12:00 AM to 11:00 PM

Data Entry 1

Al-munthir Saffan

04 Feb 2018

07:00 PM to 11:00 PM

Data Entry 2

Al-munthir Saffan

04 Feb 2018

07:00 PM to 11:00 PM

Creating Formulas

Al-munthir Saffan

04 Feb 2018

07:00 PM to 11:00 PM

Comment & Saving

Al-munthir Saffan

04 Feb 2018

07:00 PM to 11:00 PM

Practice Exercise 1

Al-munthir Saffan

04 Feb 2018

12:00 AM to 11:55 PM

Tables

Al-munthir Saffan

11 Feb 2018

12:00 AM to 11:00 PM

Filter

Al-munthir Saffan

11 Feb 2018

12:00 AM to 11:00 PM

Sort

Al-munthir Saffan

11 Feb 2018

12:00 AM to 11:00 PM

Format Data

Al-munthir Saffan

11 Feb 2018

12:00 AM to 11:00 PM

Practice Exercise 2

Al-munthir Saffan

11 Feb 2018

12:00 AM to 11:52 PM

IF Formula

Al-munthir Saffan

18 Feb 2018

12:00 AM to 11:00 PM

Conditional Formatting

Al-munthir Saffan

18 Feb 2018

12:00 AM to 11:00 PM

Reference cells

Al-munthir Saffan

18 Feb 2018

12:00 AM to 11:00 PM

Deal with Data

Al-munthir Saffan

18 Feb 2018

12:00 AM to 11:00 PM

Practice Exercise 3

Al-munthir Saffan

18 Feb 2018

12:00 AM to 11:00 PM

Charts

Al-munthir Saffan

25 Feb 2018

12:00 AM to 11:00 PM

Charts II

Al-munthir Saffan

25 Feb 2018

12:00 AM to 11:00 PM

Sparklines

Al-munthir Saffan

25 Feb 2018

12:00 AM to 11:00 PM

IF Function

Al-munthir Saffan

25 Feb 2018

12:00 AM to 11:00 PM

IF function with the AND, OR functions

Al-munthir Saffan

25 Feb 2018

12:00 AM to 11:00 PM

Practice Exercise 4

Al-munthir Saffan

25 Feb 2018

12:00 AM to 11:00 PM

Pivot Table

Al-munthir Saffan

04 Mar 2018

12:00 AM to 11:00 PM

Pivot Table II

Al-munthir Saffan

04 Mar 2018

12:00 AM to 11:00 PM

Pivot Table III

Al-munthir Saffan

04 Mar 2018

12:00 AM to 11:00 PM

Practice Exercise 5

Al-munthir Saffan

04 Mar 2018

12:00 AM to 11:00 PM

COUNTIF

Al-munthir Saffan

11 Mar 2018

12:00 AM to 11:00 PM

COUNTIFS

Al-munthir Saffan

11 Mar 2018

12:00 AM to 11:00 PM

Statistical Equations-COUNTIFS

Al-munthir Saffan

11 Mar 2018

12:00 AM to 11:00 PM

Statistical Equations- SUMIF&SUMIFS

Al-munthir Saffan

11 Mar 2018

12:00 AM to 11:00 PM

Statistical Equations- Pivot Table

Al-munthir Saffan

11 Mar 2018

12:00 AM to 11:00 PM

Practice Exercise 6

Al-munthir Saffan

11 Mar 2018

12:00 AM to 11:00 PM

Data Validation

Al-munthir Saffan

18 Mar 2018

12:00 AM to 11:00 PM

Text to Columns

Al-munthir Saffan

18 Mar 2018

12:00 AM to 11:00 PM

Link Data

Al-munthir Saffan

18 Mar 2018

12:00 AM to 11:00 PM

Remove Duplicates

Al-munthir Saffan

18 Mar 2018

12:00 AM to 11:00 PM

Goal Seek

Al-munthir Saffan

18 Mar 2018

12:00 AM to 11:00 PM

Practice Exercise 7

Al-munthir Saffan

18 Mar 2018

12:00 AM to 11:00 PM

Vlookup

Al-munthir Saffan

25 Mar 2018

12:00 AM to 11:00 PM

Link Papers and Work Files

Al-munthir Saffan

25 Mar 2018

12:00 AM to 11:00 PM

Print and Document Layout Tools

Al-munthir Saffan

25 Mar 2018

12:00 AM to 11:00 PM

Document Protection Tools

Al-munthir Saffan

25 Mar 2018

12:00 AM to 11:00 PM

Practice Exercise 8

Al-munthir Saffan

25 Mar 2018

12:00 AM to 11:00 PM

Macro

Al-munthir Saffan

01 Apr 2018

12:00 AM to 11:00 PM

Making Interactive buttons using Macro

Al-munthir Saffan

01 Apr 2018

12:00 AM to 11:00 PM

VBA

Al-munthir Saffan

01 Apr 2018

12:00 AM to 11:00 PM

Examples of Prefix Codes

Al-munthir Saffan

01 Apr 2018

12:00 AM to 11:00 PM

Practice Exercise 9

Al-munthir Saffan

01 Apr 2018

12:00 AM to 11:00 PM

Price

Course Fee

FREE

FREE
VAT Included
See Registration Policies, Cancellations & Refunds

Contact Information

Organization : Virtual Medical Academy
Phone : 558448846
Email : info@medicalacademy.org

  • 04 Feb 2018    To    21 Apr 2018
  • 12:00 AM  To  11:00 PM
  • Certificat Available
  • Online Click Here
  • 352