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 Health Care Provider

Schedule

Introduction

04 Feb 2018

12:00 AM to 11:00 PM

Data Entry 1

04 Feb 2018

07:00 PM to 11:00 PM

Data Entry 2

04 Feb 2018

07:00 PM to 11:00 PM

Creating Formulas

04 Feb 2018

07:00 PM to 11:00 PM

Comment & Saving

04 Feb 2018

07:00 PM to 11:00 PM

Practice Exercise 1

04 Feb 2018

12:00 AM to 11:55 PM

Tables

11 Feb 2018

12:00 AM to 11:00 PM

Filter

11 Feb 2018

12:00 AM to 11:00 PM

Sort

11 Feb 2018

12:00 AM to 11:00 PM

Format Data

11 Feb 2018

12:00 AM to 11:00 PM

Practice Exercise 2

11 Feb 2018

12:00 AM to 11:52 PM

IF Formula

18 Feb 2018

12:00 AM to 11:00 PM

Conditional Formatting

18 Feb 2018

12:00 AM to 11:00 PM

Reference cells

18 Feb 2018

12:00 AM to 11:00 PM

Deal with Data

18 Feb 2018

12:00 AM to 11:00 PM

Practice Exercise 3

18 Feb 2018

12:00 AM to 11:00 PM

Charts

25 Feb 2018

12:00 AM to 11:00 PM

Charts II

25 Feb 2018

12:00 AM to 11:00 PM

Sparklines

25 Feb 2018

12:00 AM to 11:00 PM

IF Function

25 Feb 2018

12:00 AM to 11:00 PM

IF function with the AND, OR functions

25 Feb 2018

12:00 AM to 11:00 PM

Practice Exercise 4

25 Feb 2018

12:00 AM to 11:00 PM

Pivot Table

04 Mar 2018

12:00 AM to 11:00 PM

Pivot Table II

04 Mar 2018

12:00 AM to 11:00 PM

Pivot Table III

04 Mar 2018

12:00 AM to 11:00 PM

Practice Exercise 5

04 Mar 2018

12:00 AM to 11:00 PM

COUNTIF

11 Mar 2018

12:00 AM to 11:00 PM

COUNTIFS

11 Mar 2018

12:00 AM to 11:00 PM

Statistical Equations-COUNTIFS

11 Mar 2018

12:00 AM to 11:00 PM

Statistical Equations- SUMIF&SUMIFS

11 Mar 2018

12:00 AM to 11:00 PM

Statistical Equations- Pivot Table

11 Mar 2018

12:00 AM to 11:00 PM

Practice Exercise 6

11 Mar 2018

12:00 AM to 11:00 PM

Data Validation

18 Mar 2018

12:00 AM to 11:00 PM

Text to Columns

18 Mar 2018

12:00 AM to 11:00 PM

Link Data

18 Mar 2018

12:00 AM to 11:00 PM

Remove Duplicates

18 Mar 2018

12:00 AM to 11:00 PM

Goal Seek

18 Mar 2018

12:00 AM to 11:00 PM

Practice Exercise 7

18 Mar 2018

12:00 AM to 11:00 PM

Vlookup

25 Mar 2018

12:00 AM to 11:00 PM

Link Papers and Work Files

25 Mar 2018

12:00 AM to 11:00 PM

Print and Document Layout Tools

25 Mar 2018

12:00 AM to 11:00 PM

Document Protection Tools

25 Mar 2018

12:00 AM to 11:00 PM

Practice Exercise 8

25 Mar 2018

12:00 AM to 11:00 PM

Macro

01 Apr 2018

12:00 AM to 11:00 PM

Making Interactive buttons using Macro

01 Apr 2018

12:00 AM to 11:00 PM

VBA

01 Apr 2018

12:00 AM to 11:00 PM

Examples of Prefix Codes

01 Apr 2018

12:00 AM to 11:00 PM

Practice Exercise 9

01 Apr 2018

12:00 AM to 11:00 PM

Price

Course Fee

FREE

FREE
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