What you'll learn

Microsoft Excel

Requirements

Basic COmputer Knowledge

Description

This is the bite size course to learn Microsoft Excel fasts.

You will need to know some COmputer knowledge before learning this course.

You can take the course as follows, and you can take a exam at EMHAcademy to get SVBook Advance Certificate in Microsoft Office:

- Learn Microsoft Word Basics Fast

- Learn Microsoft Powerpoint Basics Fast

- Learn Microsoft Excel Basics Fast

You can take the course as follow and you can take an exam at EMHAcademy to get SVBook Advance Certificate in Microsoft Office and Data Analysis with Excel:

- Learn Microsoft Word Basics Fast

- Learn Microsoft Powerpoint Basics Fast

- Learn Microsoft Excel Basics Fast

- Learn Data Aalysis using Microsoft Excel Basics Fast.

Content

Getting Started

Download Data set

Read CSV

Bold

Italics

Underline

Text Color

Chnage Font

Border

Cells Color

Line Styles

Line COlors

Autosize

Left Align

Center ALign

Right Align

Merge and Center

Format Cells

Conditional Formatting

Format as Tables

Change Cell Styles

Format as Tables vs Change Cell Styles

Sum Fucntion

Average Function

Min Function

Max Function

Correlation

Variance

Standard Deviation

Kurtosis

SKewness

VLOOKUP

COUNTIF

IF FUnction

More Functions

Find and Replace

Sort Data

Filter Dtaa

INsert Line CHart

Insert Bar CHart

INsert Pie CHart

INsert ScatterDescription

INsert COmbo CHart

INsert Pivot Table

INsert Pivot Tables and Pivot Charts

Who this course is for:

Beginner Computer Passion People who want to learn Microsoft Excel