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 the Ins and Outs of Microsoft Excel 2013 and Automate Repetitive Tasks
Contents and Overview
The course is designed for individuals and office professionals who need to master the capabilities of Microsoft Excel 2013. The course also includes advanced level training for individuals and professionals who are new to VBA (Visual Basic for Applications) and who are seeking practical ways to automate tasks in Microsoft Excel that are performed frequently.
Through 23 hours of video lectures and 3 quizzes, you'll learn the essentials with these 3 popular courses:
When you complete this course, you'll be well on your way to becoming a master with Microsoft Excel 2013.
This bundle includes:
Courses included with this Bundle:
Microsoft Excel 2013 Beginners/Intermediate Training
During this 10-hour Online Excel 2013 Training, you'll learn to create Excel spreadsheets with ease. Our expert instructor will show you Excel 2013 features to navigate you through the program. Starting with the basics, you'll discover how to enter and format data in the quickest manner possible. Next you'll be introduced to the power of Excel's functions and formulas to help you calculate data and derive useful information. To help you present it all in a visually appealing format, your instructor will then walk you through how to create sophisticated charts and graphs, and publish them online. Finally, you'll learn to analyze and review worksheets for data discrepancies so you can prevent problems before they arise.
Turn your long lists of numbers into slick, engaging visuals that bring data to life. Whether you need to create budgets, financial projections, invoices, calendars, schedules, or lists, our elaborate Excel 2013 Tutorial will give you the skills you need to stand out at work.
Learn Microsoft Excel 2013 – Advanced
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.Essential VBA Training for Excel - Automate Repetitive Tasks
Great for automating repetitive tasks and operations that you perform frequently, VBA is a powerful tool to increase your productivity.
The course is designed for individuals and professionals who are new to VBA and who are seeking practical ways to automate tasks in Microsoft Excel that are performed frequently.
Through 4 hours of video lectures, exercise files, and an optional quiz, you'll learn the essentials you need to know to create powerful macros using VBA for Excel.
Find out how to use the VBA editor, VBA syntax, keywords, and comments.
Discover how to define and manage variables, set up subroutines, and create functions.
Also, find out how to use input boxes and message boxes to interact with end users.
Learn practical methods for using macro errors to improve your VBA code.
When you complete this course, you'll be well on your way to using VBA macros in Excel to help you and others automate tasks and operations performed frequently.
What people are saying:
"I am now a business analyst and I attribute my promotion directly to your courses. I'm much more savvy and confident with Excel. Thanks Simon."- Daniel Venti
"Simon Sez IT is one of the best resources if you are looking for Microsoft Office tutorials."- Top Ten Reviews
"Generally I wouldn't find this type of course all that interesting. However, I have found in my current job search that it is a necessary part of my tech skill set in which to become proficient. So, I'm very appreciative that courses like this are offered, and taught by an extremely knowledgeable instructor, who explains lessons clearly and offers opportunities to practice the theme which he has just gone over. He was thorough, and not in the least bit condescending, which I can't say for instructors I have had in the past. So, thank you."- Mary Price
"This is a fantastic intro to the advanced operations in Excel 2013."- Terril Wright
"This is the one....Simon Sez IT has always been my favorite. Excellent contribution by the author. The lectures are informative and engaging. Style of teaching is enterprising."- Jay Dhruv
"The best beginners course out there. Very easy to follow, throughout and detailed explanation to each function and step shown in the process. Ideal learning curve for the total Excel newbie like me."- Daniel Salwerowicz
"Excellent course. I have some experience with Excel but this course really helped me know the functions available in it and how to use them. The instructor explains the subject very patiently and clearly so the student can follow along and master the details. Production quality was good."- Vikram Hegde
"Excellent course (VBA course). Absolutely helpful course designed to guide you step by step through basic and advanced VBA code. Very well structured. Instructor sounds calm and competent. Easy to follow the course if you take your time. Exercises are challenging and helpful. Can highly recommend taking this course."- OliverOur videos are high definition; therefore, they are best viewed with the HD setting on and the videos enlarged.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
Introduction to Excel 2013Preview
IMPORTANT - Read this to ensure the best video quality!
Course exercise files
|Section 2: Using Touch|
Overview of Principles
|Section 3: Getting Started|
Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
Templates; Creating, Opening, and Saving a Workbook
|Section 4: Help|
Online, Offline, and Contextual Help
|Section 5: Settings and Preferences|
|Section 6: The Ribbon and Toolbars|
Quick Access Toolbar
|Section 7: Backup and Recovery|
Create Backup Option; Auto-Recover and Autosave
|Section 8: Entering and Deleting Data|
Entering Text and Numbers
Formatting Cells; Editing and Deleting Data
|Section 9: Formatting a Worksheet|
Themes and Cell StylesPreview
Inserting, Deleting, Hiding and Adjusting Rows and Columns
Wrap Text and Alignment
Merging Cells; Applying Themes and Styles
|Section 10: Copy, Paste and Paste Special|
Copy, Cut and Paste
|Section 11: Proofing|
|Section 12: Managing Worksheets|
Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets
|Section 13: Comments|
|Section 14: Viewing and Printing|
Workbook Views, Zoom and Freeze
Printing; Headers, Footers and Margins
|Section 15: Formulas and Functions|
Overview of Formulas and FunctionsPreview
Finding Errors; New Excel Functions
|Section 16: Working with Workbooks|
Multiple Workbooks and Windows; Comparing Workbooks
|Section 17: Find and Replace|
Go to; Find and Replace Options
|Section 18: Conditional Formatting|
Applying, Clearing and Managing Rules
|Section 19: Graphing and Charting|
Chart Types; Chart Recommendation
Selecting Data, Positioning and Printing Charts
|Section 20: File Types|
Saving Workbooks; PDF and CSV Formats
|Section 21: Managing Data|
|Section 22: Functions Case Study|
Date and Time Functions
|Section 23: Analyzing Data|
Financial Analysis Case Study - Part 1Preview
Financial Analysis Case Study - Part 2
Quick Analysis Tool
|Section 24: Shapes and Pictures|
Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt
|Section 25: Sharing and Protecting|
Sharing and SkyDrive
|Section 26: More Backstage View Options|
Trust Center; Export; Inspect Workbook
|Section 27: Closing|
Summary; More Help
Microsoft Excel 2013 Quiz
|Section 28: Excel Advanced: Introduction to Excel 2013 Advanced|
Pre-requisites of Excel 2013 Advanced Course
Course exercise files
|Section 29: Excel Advanced: Functions|
List of Functions; Common Types of Arguments; Basic Use of Functions
Advanced Aspects of Functions; Searching for a Function
|Section 30: Excel Advanced: Personal and Professional Financial Functions|
|Section 31: Excel Advanced: Date and Time Functions|
How Dates and Times are Stored
Dates and Times Calculation
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 80+ courses and 4,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 250,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.