By Simpliv
Online
Can be taken anytime
Professional Training Course
Yes (Details)
English
$10
Course Overview
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 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
- Auto size
- 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
- Kurtis
- SKewness
- VLOOKUP
- COUNTIF
- IF Function
- More Functions
- Find and Replace
- Sort Data
- Filter Data
- Insert Line Chart
- Insert Bar Chart
- Insert Pie Chart
- Insert Scatter plot
- Insert Combo Chart
- Insert Pivot Table
- Insert Pivot Tables and Pivot Charts
Basic knowledge:
- Basic Computer Knowledge
Who should take this course
Beginner Computer Passion People who want to learn Microsoft Excel.
Accreditation
Course Completion Certificate
Course content
What will you learn:
- Microsoft Excel and Microsoft System
About Course Provider
Simpliv LLC, a platform for learning and teaching online courses. We basically focus on online learning which helps to learn business concepts, software technology to develop personal and professional goals through video library by recognized industry experts or trainers.
Why Simpliv
With the ever-evolving industry trends, there is a constant need of the professionally designed learning solutions that deliver key innovations on time and on a budget to achieve long-term success.
Simpliv understands the changing needs and allows the global learners to evaluate their technical abilities by aligning the learnings to key business objectives in order to fill the skills gaps that exist in the various business areas including IT, Marketing, Business Development, and much more.