When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Microsoft Excel - Features, charts, functions, and Formulas for all levels
Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.
This Course Includes
skillshare
0 (0 reviews )
6 hours 50 minutes 
english
Online - Self Paced
course
SkillShare
About Microsoft Excel - Features, charts, functions, and Formulas for all levels
1.0 General Class Introduction
1.1 Class Content
1.2 Class Structure
1.3 Ribbon
2.0 Chapter Two Introduction
2.1 Straight Forward Formulas
2.2 If and Nested If
2.3 And Or with If Formulas
2.4 Rank, Sumif & Suifs
2.5 Conditional Formatting
2.6 Data Validation
2.7 Match Formula
2.8 Index & Match Formulas
2.9 Choose
2.10 Offset
2.11 Chapter Two Homework
3.0 Chapter Three Introduction
3.1 Straight Forward Formulas
3.2 Concatenate
3.3 Left Right Mid
3.4 Len Text
3.5 Search & Find
3.6 If(Isnumber(Search))
3.7 Right(len(Search))
3.8 Substitute
3.9 Dynamic Checkbox
3.10 Numbers to Words
3.11 Chapter Three Homework
4.0 Chapter Four Introduction
4.1 Straight Forward Formulas
4.2 Yearfrac
4.3 Workingdays
4.4 Chapter Four Homework
5.0 Chapter Five Introduction
5.1 How To Insert Pivot Tables
5.2 How To Edit Pivot Tables
5.3 Pivot Tables Options
5.4 Chapter Five Homework
6.0 Chapter Six Introduction
6.1 Basic Bar Charts
6.2 Basic Column Charts
6.3 Other Column Charts
6.4 Line Charts
6.5 Area Charts
6.6 Pie & Donut Charts
6.7 Treemaps & Sunburst Charts
6.8 Radar Charts
6.9 Waterfall & Funnel Charts
6.10 Histogram & Pareto Charts
6.11 World Map
6.12 Combo Charts
6.13 Heat Maps using Conditional Formatting
6.14 Surface Charts
6.15 Sparklines
6.16 Gant Charts
6.17 Gant Chat with Conditional Formatting
6.18 Advanced Line Charts
6.19 Advanced Column Charts
6.20 Dynamic Donut Chart
6.21 Linked Pictures
6.22 Overlay Image Charts
6.23 Curved Columns
6.24 Infographic Charts
6.25 Scatter, Bubble, Box & Whiskers, and Stock Charts
6.26Dynamic Dashboard with Scroll Bar
7.0 Quiz Sheet
8.0 Financial Tracker
What You Will Learn?
- Learn the skill that matters!!.
- This class is created for those who want to get a sufficient education in Excel to improve their office works, their business, or even their personal life. This course is structured to help the majority of people regardless of their current knowledge of Excel. If you are a beginner or intermediate, then this course is for you..
- In these days, the vast requirements of supply and demand of millions of goods worldwide generate tremendous amount of data that needs to be analyzed, presented and organized in a very frequent paste, and as far as I know, no human brain can do that by itself, but with Excel they can..
- I believe and I since you are reading this, you agree with me, that It became a shame in the job world not to know Excel!! For me literacy in any career is equivalent to the ignorance of Excel in these days!!.
- Therefore, this course is intended to teach you this amazing tool. You will learn the vast amount of the features and functions in Excel as well as some advanced techniques that will help you present your data in a professional way and impress your coworkers, managers and clients..
- You will know how to organize and rearrange any data you have using Pivot table while plotting them in advanced charts and graphs. But most importantly, you will understand how to think like Excel..