Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Excel comes in a grid of cells that are arranged in numbered rows and letter-named columns. It allows arithmetic operations and also caters to statistical, engineering and financial requirements.
Excel 2016 is a part of the Microsoft Office 2016 suite is the successor to Excel 2013. However, many functions in Excel 2013 are similar to the functions found in Excel 2016.
The course will cover topics such as If statements, Vlookup, Round functions, Time functions, Data lookups, Sparklines, Outlining and even Scenarios. From basic formulas and simple functions to complex statements and operators, this course includes it all. It breaks down all aspects of Excel 2016 to give you a complete understanding of this amazing and useful software.
To give you an optimum learning experience, each section also comes with working files, practice exercises and even quiz questions and answers to help you along on your learning journey.
In this course, you will learn:
There is so much more that you can do with your excel sheet. From simply a tool for organizing, excel can now help with simple calculations to performing complex functions, including creating charts, tables and graphs. Enroll now and learn how Excel can simplify your life.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
Welcome and IntroPreview
The Power of ExcelPreview
What you should know before you start the course Part APreview
What you should know before you start the course Part B
What is new in Excel 2016
|Section 2: Mathmatical functions|
Creating basic formulas
Using functions part 2Preview
AVERAGE MODE MEAN and MEDIANPreview
Area and Volume Calculations
|Section 3: If Functionality|
IF Syntax and Uses
SUMIF for selective Counting
COUNTIF for Selective Counting
AVERAGEIF for the Mean
Nesting the IF Statement
Using the AND and OR Operators in an IF statement
The NOT Operator within AND and OR statements
|Section 4: Performing Data Lookups|
Creating a VLOOKUP
Creating an HLookup
Working with Data Validation
Dealing with missing data in a Lookup
Lookups Nested within Lookups
|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
|Section 6: Other Mathematical 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
|Section 7: Outlining|
Creating an Outline
Creating an outline Manually
Editing and Removing an Outline
Outlining and Functions
|Section 8: Scenarios|
Setting Up a Set of Scenarios
Scenario sand Pivot Tables
|Section 9: Custom Views|
Introduction to Custom Views
Creating a Custom View
Use of Outlining to Create Custom Views
Editing and Deleting Custom Views
|Section 10: Wrap up|
Eduonix creates and distributes high quality technology training content. Our team of industry professionals have been training manpower for more than a decade. We aim to teach technology the way it is used in industry and professional world. We have professional team of trainers for technologies ranging from Mobility, Web to Enterprise and Database and Server Administration.