Quick Guide to Master Advance Excel
- Offered byEduonix
Quick Guide to Master Advance Excel at Eduonix Overview
Duration | 4 hours |
Total fee | ₹1,062 |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Credential | Certificate |
Quick Guide to Master Advance Excel at Eduonix Course details
- Students & IT Professionals
- Those having basic knowledge of excel
- 4 hours on-demand video
- Course Completion Certificate
- Getting the data is actually the easy part. Now that you have the data, the hard part is to analyze it. Data is often found in a mess and the job of sorting it and maintaining it, along with analyzing it was once a difficult task. This is before Microsoft Excel came along ? making it easier to store, organize, sort, filter and even analyze the data.
- Our Excel 2016 course is a complete online tutorial designed to not only familiarize you with the Excel program, but to also teach you all the things that Excel is capable of performing. Our tutorial will also cover the differences between Excel 2013 and the latest version ? the Excel 2016, teaching you all the new features that are available with the 2016 version.
- Microsoft Excel is an interactive spreadsheet that allows users to organize, analyze and store data in a tabular form. Originally designed as an alternative for accounting worksheets, Excel has since then evolved into a more complex piece of software. It has enabled users to easily record and analyze information and offers numerous tools to help along with this process.
Quick Guide to Master Advance Excel at Eduonix Curriculum
SECTION 1 : Course Intro
Welcome and Intro Preview
The Power of Excel Preview
A What you should know before you start the course
B What you should know before you start the course
What is new in Excel 2016
SECTION 2 : Mathmatical functions
Creating basic formulas Preview
Using functions part2
Absolute Values
AVERAGE MODE MEAN and MEDIAN
Area and Volume Calculations
Practice Exercise
SECTION 3 : If Functionality
IF Syntax and Uses Preview
SUMIF for selective Counting
COUNTIF for Selective Counting
AVERAGEIF for the Mean
Nesting the IF Statement Preview
Using the AND and OR Operators in an IF statement
The NOT Operator within AND and OR statements
Practice Exercise
SECTION 4 : Performing Data Lookups
Creating a VLOOKUP Preview
Creating an HLookup
Working with Data Validation
Dealing with missing data in a Lookup
Lookups Nested within Lookups
PracticeExercise
SECTION 5 : Sparklines
What is a Sparkline
Creating a Sparkline
Altering the design of Sparklines
Dealing with empty cells in Sparklines
Removing Sparklines from a Worksheets
Practice
SECTION 6 : Other Mathmatical Functions
Working With Time In Excel
Calculations Using Time
Rounding Decimal Places
MOD and INT Functions and Uses
Generate and Use a Random Number
Loan and Investment Calculations
Forecast Function
SECTION 7 : Outlining
Creating an Outline
Creating an outline Manually
Editing and Removing an Outline
Outlining and Functions
Practice
SECTION 8 : Scenarios
Scenarios
Setting Up a Set of Scenarios
Scenario Summaries
Scenario sand Pivot Tables
Practice
SECTION 9 : Custom Views
Introduction to Custom Views
Creating a Custom View
Use of Outlining to Create Custom Views
Editing and Deleting Custom Views
Practice
SECTION 10 : Wrap up
Closing Video
Other courses offered by Eduonix
Student Forum
Anything you would want to ask experts?