The Microsoft Press(R) Step by Step video series teaches Microsoft software and technologies visually, in an easy-to-follow visual format. Each video in the series is based on a specific book in the highly successful Step by Step print book series, and adds best practices, tips, tricks, and enhanced explanations and commentary. You'll learn just what you need, just when you need it.
In this Microsoft Excel – Shortcut Guide training course, expert author Guy Vaccaro takes you beyond the basics of Excel, showing you numerous useful shortcuts within this spreadsheet program.
In this course students will work with advanced formulas and functions, as well as lookup functions. In addition, students will apply conditional formats and learn to manage them. They will learn how to import and export data, and how to query external databases. Finally, students will learn about the analytical features of Excel (such as Goal Seek and Solver).
In this course you will learn how to use multiple worksheets and workbooks efficiently. You will also learn how to create outlines and subtotals, how to create and apply cell names, and how to create and format charts. You will work with templates, collaborate in workbooks and use the drawing tools to enhance and annotate spreadsheets.
This class teaches the basic functions and features of Excel 2010. After an introduction to spreadsheet terminology and Excel's window components, you will learn how to use the Help system and navigate worksheets and workbooks. Next, you will enter and edit text, values, formulas, and pictures, and you will save workbooks in various formats. Additionally, you will move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, managing large worksheets and printing