In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on. The training explains Microsoft Excel 2010 starting with the absolute basics of creating your very first worksheet. He slowly works you up through learning the various capabilities of this very powerful program, and covers topics such basic to advanced formula and functions.
By the conclusion of this computer software tutorial for Microsoft Excel 2010, you will have mastered the advanced features and functions of this software. Working files are included to allow you to follow along with the same files the author trains you with.
This Excel 2010 advanced training course, follows up from the Beginners Excel 2010 course by delving even deeper into the features and functions of this powerful spreadsheet software.
Microsoft Excel 2010 is much more than a quick way to add up numbers. In this online course, you will learn advanced features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and more. You will learn about performing lookups with HLOOKUP and VLOOKUP. This tutorial also covers Sparklines, and goes in-depth with Pivot Tables and Charts. Finally, you will learn how to create and record your own Macros.
This advanced video course is not for beginners. You should have a firm grasp of the basics before taking this Advanced Excel training course. By the conclusion of this advanced computer software tutorial for Microsoft Excel 2010, you will have mastered the advanced features and functions of this software. Working files are included to allow you to follow along with the same files the author trains you with.
In this Microsoft Excel 2010 video course, InfiniteSkills introduces you to the latest version of Microsoft's standard spreadsheet application.
In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The training explains Microsoft Excel 2010 starting with the absolute basics of creating your very first worksheet. He slowly works you up through learning the various capabilities of this very powerful program, and covers topics such basic to advanced formula and functions. A chapter on how to connect to Microsoft Web Apps is also covered. The course also shows how to use your own SkyDrive to store and share your Microsoft Excel Projects. As part of this course, you can also download the working files that allow you to work alongside the author as he teaches you how to use Microsoft Excel 2010.
By the completion of this online training course, you will be fully versed, and capable of working with Microsoft Excel 2010 in a commercial Environment.
In this Microsoft Excel 2013 training course, expert training provider InfiniteSkills takes you through the basics of the worlds most popular spreadsheet software. Excel can be a complex and confusing program to use, but this course breaks it down into bite-sized pieces and teaches it in plain English. No prior experience in Excel 2013 or spreadsheets is required to get the most out of this Excel beginners video training.
You will start with the absolute basics, creating and saving a new workbook. The course proceeds step by step through the process of entering data in cells, doing basic math, formatting your worksheets, setting up pages for printing and applying basic mathematical formulas. Once you are comfortable with the basics, you will move on to more advance formatting with themes, using Excel provided templates, adding graphics and charts, and using Excel as a database. You finish off with advanced formulas, and applying conditional formatting to your worksheet.
By the time you have completed this video training course for Microsoft Excel 2013, you will be comfortable with day to day operations that you would perform in this software program. You will be able to perform calculations, and create professional graphs and charts from your data. Working files are included to allow you to follow along using the same source material that the author uses throughout the lessons in this computer based training video.
In this Excel 2013 tutorial course for Microsoft Excel 2013, an expert author takes you beyond the basics of Excel, and teaches you how to use the advanced features and functions in this spreadsheet program from Microsoft.
You will start with basic operations such as SUM, MIN, and MAX, as well as conditional mathematical functions. The author proceeds to instruct you on using IF statements to control conditions. You will learn how to perform data lookups using VLOOKUP and HLOOKUP, and how to create Sparklines. Other features that are covered in this advanced Excel tutorial are; working with time, outlining, custom views, text manipulation, error checking, pivot tables and pivot charts. The course also covers some basic Macro operations within Excel for optimizing your workflow.
By the completion of this computer based advanced Excel training video for Microsoft Excel 2013, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer. Working files are included, allowing you to follow along with the author throughout the lessons.
This hands-on Microsoft Excel 2011 For Mac course shows you how to effectively use the many features and functions of MS Excel. You will learn to leverage the power of the most important features Excel 2011 has to offer the Apple user, whether you're working in an all-Mac office or needing to coordinate with PC counterparts. Beginning your training with the creation of a sheet to record and monitor sales data, you'll learn the basics of what you can do with spreadsheets. The course then moves on to creating a Profit and Loss report, building a solid understanding of formulas along the way. Moving to score sheets for a sports day, you will discover conditional formatting, lookups, and more. You then create a functional expense claim form and a sales contact management sheet, exploring how you can easily manipulate text, and even create mail merges from within Excel. Whether wanting to beef up your existing Excel skills or learn the program from the ground up this InfiniteSkills Excel course is a tremendous resource with over 50 lessons.
What You Will Learn
- How to create professional quality spreadsheets, workbooks and presentation-ready charts with one of the world's leading office productivity tools.
- How to manipulate and implement data across a wide range of projects.
- How to create fully compatible documents and projects that can be accessed by users working with Office for Mac products as well as Windows counterparts.
Who Should Take This Course
- Anyone who has used Microsoft Excel in the past but wanted a better understanding of its full range of features.
- Anyone who needs an understanding of Microsoft Office software as it applies to a professional work or academic environment.
- Anyone Mac user new to MS Excel wanting a user-friendly guide that introduces the program from the ground up.
What People Are Saying
"I swear I thought excel was the most confusing program ever created...until I started following the simple examples in YOUR course. THANKS."
"Exactly what I needed. Very direct training on each major part of the program. Guy's presentation style is straightforward and effective."