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.
Want to create jaw-dropping spreadsheets that get your boss’s attention?
Colorful charts, sleek graphs, and cutting-edge databases that offer insight into financial information are a breeze when you learn the secrets of creating sophisticated spreadsheets in our Learn Excel 2013 – Advanced course. That’s because you’ll get the tools you need to master Excel’s powerful data functions in this information-packed 9-hour video training class.
Your expert instructor will kick the course off by leading you through graph and chart basics. Then, you’ll explore Excel’s array of detailed formatting tools and discover how to make these work for you when graphing and charting financial information. Next, you’ll explore the roles played by trends, relationships, and differences in charts, and how to work with sparklines for data visualization and data bars. The course will also take you through detailed discussions of pivot tables, bubble charts, radar charts, and more.
Plus, when you sign up for our class, you’ll also get these 6 BONUSES for a limited time in addition to the 40+ online course videos:
Where else can you find so many extra tools to help you gain advanced skills in Excel 2013?!?!
So start learning today.
What people are saying:
"Simon Sez IT is one of the best resources if you are looking for Microsoft Office tutorials."
Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.
|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|
|Section 19: Downloadable course MP3 audio files|
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 185,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