Courses
This series is for anyone who wants to know Excel in a non-intimidating, soup-to-nuts manner. If you've never used Excel, this is your starting point. No prior experience is necessary. If you've used Excel but never had formal training, this course will fill in the gaps so it all makes sense and so you are efficient and accurate. If you've used previous versions of Excel (prior to Office 2007) then there are a lot of features and changes you need to be aware of to fully utilize this software. In this course we take you from start to finish including entering data, configuring workbooks, working with calculations, applying regular and conditional formatting, creating custom formats, using names, leveraging the power of tables and charts and outputting your work. These are the skills every Excel user needs to know no matter how new or how experienced you may be!
In this course, author Curt Frye shows how to perform a wide range of financial calculations quickly and easily using the many financial functions found in Excel 2010. The course details dozens of functions for evaluating cash flows; calculating depreciation; determining rates of return, bond coupon dates, and security durations; and more.
In Excel 2010: Macros in Depth, author Dennis Taylor explains how macros can be used to automate tasks in Excel and walks through the process of creating and running simple macros. This course also covers advanced topics such as making macros widely available through the Personal Macro Workbook, recording a macro in stages, absolute and relative recording, and using Visual Basic for Applications (VBA) for actions that can't be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario. Exercise files are included with the course.
In Excel 2010: Managing Multiple Worksheets and Workbooks, author Dennis Taylor shows how to share data between multiple worksheets and workbooks and gives tips for adding, moving, and navigating worksheets and workbooks efficiently. This course covers how to make global changes, create simple formulas that connect worksheets, make super-efficient 3D formulas to calculate summary totals from multiple worksheets, and use pivot tables to summarize data from multiple workbooks. Exercise files accompany the course.
In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. The course shows how to connect and consolidate data sources to power PivotTables, sort and filter records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot. Exercise files are included with the course.
In Excel 2010: Real-World Projects, author Curt Frye demonstrates five important new features in Excel 2010. Using real-world examples, Curt shows how Excel 2010 will be a beneficial upgrade for all users. He highlights the improvements in PivotTables and the visual presentation of data. The release of this important business application will give users a number of new ways to review and present information. Exercise files accompany this course.
In Excel 2010: Working with Dates and Times, Dennis Taylor shares his solutions for optimizing the use of dates and times in Excel 2010. This course explains what's going on behind the scenes when Excel stores dates and times, gives tips for entering dates and times, and shows options for date and time formatting. It also demonstrates the various date and time functions and shows how to calculate with dates and times in a range of scenarios. Exercise files are included with the course.
Whether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.
Discover over 65 tips, tricks, and shortcuts in Microsoft Excel. In this course, Curt Frye reveals how to invoke commands, manage and organize data, and build formulas in Excel. Curt shares his power shortcuts for saving time on basic tasks, from entering data and selecting cell ranges to summarizing data with charts and tables and quickly finding information.
Join Curt Frye as he explains how to leverage PivotTables to summarize, sort, count, and chart your data in Microsoft Excel. Curt shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to enhance PivotTable with macros, DAX expressions, and the PowerPivot add-in for analyzing millions of rows of data.