- Creating a Loan Calculator-1
- Creating a Loan Calculator-2
- Creating a Loan Calculator-3
- Function Basics
- Logical Functions
- Mathematical Functions
- Lookup and Reference Functions
- LOOKUP, VLOOKUP, and HLOOKUP Functions
- Introduction to Advanced charts
- Line chart
- Column chart
- Pie chart
- Area Chart
- Converting area chart into line chart
- What is regression analysis ?
- What are chart templates
- What are sparklines
- Sparklines vs charts
- Data in hidden rows and columns
- Introduction to Pivot chart and tables
- Creating pivot charts
- Creating pivot table
- Multiple fields in row, column or data section
- Creating pivot charts
- Creating and using calculated fields
What you'll learn
- The students will learn the basics which are needed to work on excel
Description
Microsoft Excel has the basic features of all spreadsheets,using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives using pivot tables.
In this course you will be learning the basics which is required when you start working with Microsoft Excel. In today's time Microsoft Excel is one of the most important tool used in any organization. This course will definately help you to learn the basics with the practical use of it.
Other Courses
How To Find Buyers by using go4WorldBusiness
This course will give you the tools you need to succeed in international trade.
Understanding Annuities
A guide to the good, the bad, and the ugly of annuities.
Physics: A beginners guide to Kinematics
This introduction course to vectors and kinematics is suitable for interested students with good algebra skills.
Intro to Orofacial Myofunctional Therapy
A beginners guide to learn about the benefits of Myofunctional Therapy
About the instructors
- 4.39 Calificación
- 180597 Estudiantes
- 40 Cursos
MKCL India
Creating a Knowledge Lit World
We are an eLearning company with more than 10 million learners for our courses. Our expertise is in creating eLearning courses which are self paced and rich in instructional design. We focus on the principles of 'learning by doing' in the courses by teaching the concepts and the tools while creating projects or assets.
Student feedback
Course Rating
Reviews
Yes, I had forgotten some items
The content was not satisfactory. You didnot explain hlookup at all. Also, vlookup was explained very superficially. These are important functions that used on daily basis.
Was a good course
Good for Excel foundation
too brief and too basic