Learn how to master spreadsheets with this free online Microsoft
Excel advanced training course.
This free online Microsoft Excel 2013 advanced training
course will teach you how to use advanced functions and formulas in Excel, and
supercharge your Excel skills. You will learn how to use functions and do a statistical analysis of data in Excel. This course is aimed at learners with an
existing understanding of Excel looking to multiply their spreadsheet
productivity. Start this course today to take your spreadsheeting skills to the
next level.
Description
In this online course Microsoft Excel 2013 - Advanced:
Master Spreadsheets, learn about the advanced features and functions of
Microsoft Excel 2013. The course starts by introducing you to the basic use of
function and their arguments, along with how to find the one you want Then you
are taught about financial functions and how to use them, and about date and
time functions.
Next, the course talks about and demonstrates functions for statistical analysis of your data in Excel, moving to manipulate text with functions. Then the course will discuss how to use lookup functions and apply logical operations into your functions. Finally, the course finishes by teaching you how to import data from external sources to your Excel spreadsheets and how-to convert a selection in a spreadsheet to a table.
If you are interested in a career in data analysis, or you
are a business/lT professional looking to learn new skills, then this is the
course for you. Knowing how to use excel for data analytics is a key skill in
many businesses and IT departments, and this free online course will take your
spreadsheeting skills to the next level. So, start this course today and by the
end of the week, you will have learned how to use advanced functions and
formulas to help you supercharge your Excel skills.
Modules:
Introduction to Advanced Excel 2013
Prerequisites of Excel 2013 Advanced Course
Functions
- ·
Functions - Learning Outcomes
- ·
List of Functions; Common Types of Arguments; Basic Use of Functions
- ·
Advanced Aspects of Functions; Searching for a Function
- ·
Autosum
- ·
Functions Lesson Summary
Personal and Professional Financial Functions
- ·
Personal and Professional Financial Functions - Learning Outcomes
- ·
Payment
- ·
Future Value
- ·
Principle Payment
- ·
Depreciations
- · Personal and Professional Financial Functions - Lesson Summary
- Date and Time Functions - Learning Outcomes
- How Dates and Times are Stored
- Dates and Times Calculation
- Exercise on Date and Time Functions; Date and Time Settings
- Date and Time Functions - Lesson Summary
- Statistical Functions for Description, Prediction and Interference - Learning Outcomes
- Average
- Percentile
- Regression
- UNEST Function
- Example of Functions for Inferential Statistics
- Statistical Functions for Description, Prediction and Interference - Lesson Summary
Text Functions
Text Functions - Learning Outcomes
Text Function Case Study - 1
Text Function Case Study - 2
Text Functions - Lesson Summary
- Lookup and Logical Functions - Learning Outcomes
- Lookup and Reference Functions
- Logical Functions
- Lookup and Logical Functions - Lesson Summary
- Tables - Learning Outcomes
- Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row
- Inserting Columns and Rows; Resizing Tables
- Table Reference
- Table Styles
- Table Selection
- Tables - Lesson Summary
Learning Outcomes:
By the end of this course you will be able to:
- Discuss the use of advanced functions and formulas in Excel
- Illustrate a good understanding of financial functions
- Identify how time and dates are stored and calculated
- Discuss how to use statistical functions to perform regression and percentile calculations
- Explain and understand how text functions work
- Discuss detailed knowledge of logical functions
- Recognize how to connect Excel with external data sources
0 Comments