Business

Though Microsoft Excel has been around for many years, Excel 2007 has an entirely new look and feel. Many new features have been added to improve productivity and workflow. In this in-depth VTC course, VTC Author Cheryl Brumbaugh-Duncan explores using Excel to create, manage, and analyze spreadsheet data. Users will learn to develop all the necessary worksheets and workbooks for financial and informational data, for a company that distributes healthy snacks to companies throughout a city. The course steps the participant through the various topics and skills needed to master Excel 2007 and provides a fun project for applying the new knowledge. Work Files are included.
course level image
vendor image
subscription image
VTC's Microsoft Excel course is intended for users of all levels. Whether you are working on a simple spreadsheet or a complex analysis, it's all covered. Learn how to master the wide array of tools contained in Excel with efficiency, accuracy, and productivity. This course will help students master the art of spreadsheet design. You will learn formulas and functions, along with the database-oriented features such as pivot tables and filters. Learn about the new features of Excel 2010 and tips to increase the readability of your spreadsheets. Although taught using Excel 2010, this course is appropriate for all versions of Excel. Work files are included.
course level image
vendor image
subscription image

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.

course level image
vendor image
cost range image
This VTC course will give you the knowledge and skills you need to get the most out of Microsoft Excel 2013. You will learn about the Excel interface by working in it. You will create and format worksheets, make calculations, create charts, and use tools to analyze data in meaningful ways. Author Helen Bradley teaches Excel from a business perspective, focusing on tools that maximize productivity and accuracy. She demonstrates how to design worksheets intelligently and then shows you how to check for accuracy to ensure that worksheets return correct results. She also covers automating data entry, testing formulas, and using PivotTables for data analysis. She concludes with a discussion of SkyDrive and the Excel WebApp.
course level image
vendor image
subscription image

In this training course for Microsoft Excel 2013, 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 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.

course level image
vendor image
cost range image
VTC's Microsoft Excel Automation course is intended for intermediate and advanced users who wish to increase their efficiency, accuracy, and productivity. Students should have already completed Excel introduction courses or have equivalent knowledge. Created for all versions of Excel, this course will help students master the art of spreadsheet design and will provide comprehensive instruction in the automation and simplification of even the most complex data. Expanding upon our basic Excel courses, Lauri Matson explores the more advanced features of Excel such as VLookup functions, validation, pivot tables, analysis tools, charting, and more.
course level image
vendor image
subscription image
Office 2008 is an update to Microsoft's suite of business applications for the OS X platform. Tutorial author Brian Culp will guide users through a tour of the Office's four core applications: Word, PowerPoint, Excel, and Entourage - the Macintosh version of Outlook, complete with Exchange support. Users will quickly step through the basics of using each of these four applications, spending the bulk of the tutorial working through more advanced tips and techniques. Brian's approach is to give users a look at features that will unlock maximum creativity with a minimum of time investment for the user.
course level image
vendor image
subscription image
Office for Mac 2011 is a powerful update of the widely used productivity suite. Mac users now have access to a slew of updated features which are designed to simplify workflow while still maintaining the incredible strength of inter-application collaboration. This VTC course explores the 2011 update through a detail driven approach and with the help of practical examples. All of the major applications in Office are covered, along with several of the lesser profile utilities. Office may be constantly changing, but that doesn't mean you need to be left behind! Jump on board with Sam McGuire and get the very most out of the tools you use on a daily basis.
course level image
vendor image
subscription image
Microsoft Outlook 2007 provides an integrated solution for managing and organizing e-mail messages, schedules, tasks, notes, contacts, and more. With its new design and advanced customization features, Microsoft Outlook 2007 is much more than just an e-mail/calendar application. Author Brian Culp guides users through using this exciting new program, from installation to utilizing it as a complete task and communication management program. As a part of Microsoft Office, or as a stand alone program, Brian Culp will show users how to get the most out of Microsoft Outlook 2007, and he even includes 10 of his favorite tips / tricks.
course level image
vendor image
subscription image
Microsoft Outlook 2010 is one of the most popular applications for managing email, scheduling, tasks, and contacts. It consists of five (5) main sections - Mail, Calendar, Tasks, Contacts, Notes, and Journal - all of which are covered in this course, enabling users to get started with and efficiently use the entire application. Students learn to send, receive, and manage their email, as well as how to attach files to, format, and customize their email, and how to connect their messages to calendar items and contacts. They also learn how to manage their schedules and to-do lists, and to store and make effective use of their business and personal contacts. By the conclusion of the course, students understand how to use and customize the five main components of Outlook and will have the confidence and capacity to fully master the application through daily use.
course level image
vendor image
subscription image

Pages