image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

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.
Who this course is for:
Anyone who wants to learn working with Excel

What you'll learn

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Basic Excel Course
25
1.1-Creating a Loan Calculator-1
1.2-Creating a Loan Calculator-2
1.3-Creating a Loan Calculator-3
1.4-Function Basics
1.5-Logical Functions
1.6-Mathematical Functions
1.7-Lookup and Reference Functions
1.8-LOOKUP, VLOOKUP, and HLOOKUP Functions
1.9-Introduction to Advanced charts
1.10-Line chart
1.11-Column chart
1.12-Pie chart
1.13-Area Chart
1.14-Converting area chart into line chart
1.15-What is regression analysis ?
1.16-What are chart templates
1.17-What are sparklines
1.18-Sparklines vs charts
1.19-Data in hidden rows and columns
1.20-Introduction to Pivot chart and tables
1.21-Creating pivot charts
1.22-Creating pivot table
1.23-Multiple fields in row, column or data section
1.24-Creating pivot charts
1.25-Creating and using calculated fields