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.
Master Excel's Powerful Data Functions in this Information-Packed 9-hour Video Training.
The Versatility of Excel
If you have already been using Microsoft Excel then you know that the calculation, graphing and tables available help you track, manipulate and report important data. There is more to excel than a few SUMs, though, and this is the training course to get you into the advanced uses of Excel so you can really use the data and numbers you are tracking to your advantage.
This course is designed for students that are already familiar with Excel, but wish to improve their skills and open the possibilities with this versatile spreadsheet program. Bring your basic knowledge of Excel 2013 or previous software versions to this class and learn how to reach the next level of database tracking and reporting.
Contents and Overview
Through 52 lectures and over 12.5 hours of content, this course will take you through learning how to use functions in everyday work environments. Personal and professional financial functions are covered including payments, future value and depreciations. Students will learn statistical functions like averages, percentiles, and regression.
In order to improve efficiency, students will also cover concepts for connecting to external data like other workbooks or web data; tables including style, selection and sizing. Pivot tables and data analysis will be key concepts helpful to the work environment.
For help with reporting, students will learn surface charts, stock charts, radar charts and bubble charts and graphs. Lastly, students will cover important web applications.
Upon completion of this course, students will be able to create colorful charts and databases that communicate data and financial records efficiently and effectively. Students will be able to apply data to various reporting forms like tables, graphs and pivot tables in order to show important analysis like depreciation, percentiles and regression for use with strategizing and planning. Students who finish this course will have an advanced knowledge of the versatility of Excel that is immediately applicable to their work with the database.
|Section 1: Introduction|
Prerequisites of Excel 2013 Advanced Course
Course exercise files
Microsoft Excel 2013 keyboard shortcuts
Downloadable course MP3 audio files
|Section 2: Functions|
List of Functions; Common Types of Arguments; Basic Use of Functions
Advanced Aspects of Functions; Searching for a Function
|Section 3: Personal and Professional Financial Functions|
|Section 4: Date and Time Functions|
How Dates and Times are Stored
Dates and Times Calculation
Exercise on Date and Time Functions; Date and Time Settings
|Section 5: Statistical Functions for Description, Prediction and Interference|
Example of Functions for Inferential Statistics
|Section 6: Text Functions|
Text Function Case Study - 1
Text Function Case Study - 2
|Section 7: Lookup Functions|
Lookup and Reference Functions
|Section 8: Logical Functions|
|Section 9: Connecting to External Data|
Connecting to Other Workbooks
Connecting to Access Data
Connecting to Web Data
|Section 10: Tables|
Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row
Inserting Columns and Rows; Resizing Tables
|Section 11: Pivot Tables|
Basic Principles of Pivot Tables
Presentational Side of Pivot Tables
Filtering in Pivot Tables; Slices
|Section 12: Data Analysis|
|Section 13: Charts|
Stock Charts - Part 1
Stock Charts - Part 2
|Section 14: Graphs|
Regression and Scatter Chart
|Section 15: Pivot Charts|
Creating Pivot Charts
|Section 16: Sparklines|
|Section 17: Web App|
Creating Workbooks using a Web App
Sharing your Workbook
|Section 18: Conclusion|
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 60+ courses and 3,000+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 190,000 students, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.
30 day money back guarantee
Available on desktop, iOS and Android
Certificate of completion
Hours of video content