- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
Microsoft Excel 2013 Course
In this Excel 2013 course, you will learn Excel is an unrivaled instrument for managing and interpreting large datasets. Moreover, it can be used to run simple calculations and organize almost any kind of information. Specifically, Excel enables you to track data, devise models for analyzing the same data, compose formulas that perform computations with such info, pivot the aforementioned data in many different ways and create a variety of elegant-looking charts.
$9.00
Buy This Course
$9.00
You can get access to this training and over 2,500 hours of on-demand content with our All Access Monthly Subscription. Start today for 7 free days with no obligation. You can cancel anytime.
7 Free Days / $0.00 due today / $39.00 monthlyÂ
6 Training Hours
39 Videos
3 Topics
58 Practice Questions
Course Description
Note: Even though this course is based on an older version, it is still a worthwhile resource for online learning and training.
In this Excel 2013 course, you will learn Excel is an unrivaled instrument for managing and interpreting large datasets. Moreover, it can be used to run simple calculations and organize almost any kind of information. Specifically, Excel enables you to track data, devise models for analyzing the same data, compose formulas that perform computations with such info, pivot the aforementioned data in many different ways and create a variety of elegant-looking charts.
With our Microsoft Excel 2013 Course, you will quickly and effectively master the fundamentals of creating dynamic spreadsheets. Our experienced instructor will introduce to you all the amazing features offered by Excel 2013, guiding your journey through this powerful program. Not only that but they'll teach how to skillfully enter and format data in a snap! Subsequently, you will learn the force of Excel's formulas and functions to help in computing data as well as extracting invaluable knowledge. To make your results more aesthetically appealing, your teacher will then show you how to generate sophisticated charts and graphs which can be shared online. In conclusion, you'll find out how to evaluate and audit worksheets for inconsistencies so that any hindrances can be addressed before arising.
Transform your mundane numerical lists into captivating visuals that give data a brand new level of life. Our thorough Excel 2013 Tutorial will provide you with the expertise needed to excel in work-related tasks such as budgeting, financial projections, invoices, calendars, schedules and other listed items.
Advanced users
Our Learn Excel 2013 – Advanced course provides the keys to unlocking an array of vibrant charts, chic graphs, and advanced databases that offer a deeper understanding of financial information. In this video training class you'll obtain the necessary tools to dominate Excel's data functions with ease. Make strides in your professional life by mastering sophisticated spreadsheets today!
Your experienced instructor will start off the course by guiding you through fundamental graph and chart practices. After that, you'll examine Excel's comprehensive formatting options to comprehend how they can be used for graphing financial details. You'll then review the functions of trends, correlations, and distinctions in charts as well as how sparklines are utilized for data visualization and data bars. The course also covers in-depth conversations about pivot tables, bubble graphs, radar diagrams – plus much more!
This course is training for basic, intermediate, and advanced features of Microsoft Office Excel 2013 software. Excel 2013 is a spreadsheet program in the Microsoft Office system. Users can use Excel to create and format workbooks (a collection of spreadsheets) in order to analyze data and make more informed business decisions.
About Microsoft Excel
Excel 2013 is an incredibly powerful tool for getting meaning out of vast amounts of data, as well as being utilized for simple calculations and tracking almost any kind of information. Specifically, Excel is used to track data, build models for analyzing data, write formulas to perform calculations on that data, pivot the data in numerous ways, and present data in a variety of professional-looking charts.
Your Training Instructor
Josh has 15 plus years in account management and client support with over 5 years specifically in the healthcare industry. Josh provides hands-on leadership to the healthcare team at NetDirector by focusing on client success and innovative solutions. As the Healthcare Operations Manager, Josh ensures that each client implementation is completed as efficiently as possible with the greatest impact to the client. He holds a Bachelor of Arts degree from the University of South Florida.
Course Outline
Microsoft Excel 2013 Course Outline
Excel 2013 Basic
- Intro To Excel Overview Of Screen
- Ribbon Elements
- Entering Data And Editing Font Attributes
- Number Formats
- Formatting Cells
- Printing
- Formulas - Part 1
- Formulas - Part 2
- Rearranging Data
- More Formulas - Part 1
- More Formulas - Part 2 Review And Sort
- More Formulas - Part 3 Concatenate
- Chart - Part 1
- Chart - Part 2
- Chart - Part 3
- Summary
Excel 2013 Intermediate
- Introduction
- Review
- Formulas Across Worksheets - Part 1
- Formulas Across Worksheets - Part 2
- Conditional Formatting
- Data Validation
- Names Ranges
- CSV Files
- Text To Column
- Grouping Data
- More Charts Beyond Building Blocks
- Working With Windows - Part 1
- Working With Windows - Part 2
- Headers Footers And Protecting Data
Excel 2013 Advanced
- Pivot Tables - Part 1
- Pivot Tables - Part 2
- Sparklines
- Trancing Formulas
- What If Scenario
- External Data Sources
- Customizing Menus And Options - Part 1
- Customizing Menus And Options - Part 2
- Macros
Microsoft Excel 2013 Course
$9.00
In this Excel 2013 course, you will learn Excel is an unrivaled instrument for managing and interpreting large datasets. Moreover, it can be used to run simple calculations and organize almost any kind of information. Specifically, Excel enables you to track data, devise models for analyzing the same data, compose formulas that perform computations with such info, pivot the aforementioned data in many different ways and create a variety of elegant-looking charts.
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.
Monthly All-Access Subscription 7 Days Free - $39.00 / month
A great option at an affordable monthly price.
Annual All-Access Subscription $229 / year
A discounted price when paying for your All Access library on an annual basis.
Lifetime All-Access Library $379 One time payment
Exceptional Value. Pay once, never have to buy IT training again.
Related Courses
$79.00
Get certified in Microsoft Office with ITU’s comprehensive training series. From Excel to Word, learn the skills you need to succeed. Start now.
ITU’s Microsoft office training series contains certification courses in Excel, Access, Word, PowerPoint & Outlook and allows you to prepare for your Microsoft Office Specialist(MOS) certification.
$9.00
Master Microsoft Excel with our comprehensive online course. Learn formulas, functions, and more in this hands-on training series. Enroll now!
Microsoft Excel is the go-to spreadsheet application, no matter if you’re using it personally or professionally. Whether your knowledge of Microsoft Excel is beginner’s level or advanced, this Microsoft Excel 2019 Training online course will help take your abilities to a new height – covering topics from basic to intermediate and even advanced.
$9.00
Learn Microsoft Access with our comprehensive online course. Master the skills to create, design and manage a database. Enroll now!
This Microsoft Access 2010 Training course covers basic, intermediate, and advanced features in Microsoft Office Access 2010. You will learn how to utilize this database application as a design and deployment tool to keep track of important information.
$9.00
Master Microsoft Word with our online training course. Learn valuable skills and boost your resume. Enroll now and get certified!
Whether you are a beginner or expert user of Microsoft Office Word 2013, this Word 2013 Training course will equip you with the essential knowledge needed to effectively use its features. Not only can Microsoft Word 2013 help organize your work, but it also allows for efficient document writing and editing. Start on the path to mastering this word-processing program today!