LevelBasic & Advanced
Coming Batch StartJuly 22, 2017
No. of Students10 availabilities
IncludesCertificate & Practice Material
About the course
Microsoft Excel is a spreadsheet program that is used to record and analyse numerical data. Think of a spreadsheet as a collection of columns and rows that form a table.
What you will learn
- Basic Mathematics in Excel
- Basic Statistics
- Start-up With Formulas
- Basic & Advanced if Formulas
- Look up Formulas
- Working With Charts
- Pivot Table and Pivot Charts with Slicer & Discussion on Errors
More Course Information
We all deal with numbers in one way or the other. We all have daily expenses which we pay for from the monthly income that we earn. For one to spend wisely, they will need to know their income vs. expenditure. Microsoft Excel comes in handy when we want to record, analyze and store such numeric data.
Introduction to Ms Office
Suite of products developed by Microsoft Corporation that includes Microsoft Word, Excel, Access, Publisher, PowerPoint, and Outlook. Each program serves a different purpose and is compatible with other programs included in the package. The suite of programs is compatible with both the Windows and Macintosh operating system.
We can go through documents by headings, pages or images with Navigation Pane in Microsoft Word easily. However, it seems hard to find out similar tool in Excel. Is there such a Navigation pane in Microsoft Excel so that we can locate workbooks, worksheets or names in Excel quickly?
One should try the Navigation Pane tool for the above.
Basic Mathematics in Excel
This tutorial covers the basic math operations in Excel. If you want to know how to add, subtract, multiply, or divide numbers in Excel, this session will show you how to create formulas to do so.
Let Excel be your calculator. Take this course to learn how to add, subtract, multiply, and divide using formulas and functions.
Perhaps the most common Data Analysis tool that you’ll use in Excel is the one for calculating descriptive statistics. To see how this works, take a look at this session.
Start-up With Formulas
Formulas are the real workhorses of an Excel worksheet. If you set up a formula properly, it computes the correct answer when you enter it into a cell. From then on, it keeps itself up to date, recalculating the results whenever you change any of the values that the formula uses.
Look up Formulas
This Excel tutorial explains how to use the Excel LOOKUP function with syntax and examples.
The LOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the LOOKUP function can be entered as part of a formula in a cell of a worksheet.
4.6 / 5.0
90% recommend this course
Average Rating For
- Content 4.5
- Knowledge 4.5
- Assignment 4.2
- Classroom 3.8
- Instructor 4.4