What you'll learn
- Microsoft Excel
Requirements
- Basic COmputer Knowledge
Description
Why Study Microsoft Office?
According to academyoflearning
1. Almost Every Company Worldwide Uses Microsoft Office
Microsoft office has users worldwide, wit hover 97139in Canada. Its widespread means it is important in many roles and makes it the best skill.
2. Helps You Step Up Your Game in Job Hunting
Almost all organizations use Microsoft Office, they use it for administration, projects, and communications. Thus, most jobs will require you ti know Microsoft Office.
3. Industry-Recognized Microsoft Office Certification Will Help Advance Your Career
You can demonstrate that you have the skills needed for Microsoft Office by earning Microsoft Office Certifications (MOS) in a specific office program. You can also get certified with SVBook Advanced Certificate in Microsoft Office or SVBook Advanced Certificate in Microsoft Office and Data Analysis using Excel.
This is the bite-size course to learn Microsoft Excel fast.
You will need to know some computer knowledge before learning this course.
You can take the course as follows, and you can take an 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 following 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 analysis using Microsoft Excel Basics Fast.
Content
Getting Started
Download Data set
Read CSV
Bold
Italics
Underline
Text Color
Change 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 Function
Average Function
Min Function
Max Function
Correlation
Variance
Standard Deviation
Kurtosis
SKewness
VLOOKUP
COUNTIF
IF FUnction
More Functions
Find and Replace
Sort Data
Filter Data
Insert Line Chart
Insert Bar Chart
Insert Pie Chart
Insert Scatterplot
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
Instructor
SVBook Pte. Ltd. started in April 2016. SVBook Pte. Ltd. offers affordable, easy to read Data Mining, Text Mining, Data Analytics, Programming books for professional and lifelong learning. SVBook Pte. Ltd. offers courses at EMHAcademy. SVBook Pte. Ltd. developed softwares over the time, and uploaded them at DSTK_Tech. SVBook Pte. Ltd. courses, books and softwares assists people to step into new fields of Data Science, Internet of Things, Smart Cities and etc. before going into more advanced courses at Coursera and EdX, which are at University Level.