Video Training for Excel - with Templates 1.0
License: |
Category: Reference
|
Publisher: Bluewater Publishing LLC
|
Size: 743 MB
|
Last Updated: 2013-07-13 |
Operating System: OS X 10.6 or later |
Price: $19.99
|
Download
|
Publisher's description - Video Training for Excel - with Templates 1.0
INCLUDES 20 READY TO USE EXCEL TEMPLATES!
Learn Excel Plus will help you master creating and using Spreadsheets using Excel included with Microsoft Office for Mac. Includes 25 tutorial videos, booklets, and ability to save notes. Plus export up to 20 templates (use of templates requires Microsoft Excel or Microsoft Office installed).
Video topics included: - Creating your first spreadsheet using Excel - Visualizing data with Pie Charts - Using Formulas - Basic Spreadsheets and totals - Importing text files and comma delimited files - Pivot Tables - Doing statistics like standard deviation - IF and IF ELSE statements - Adding line/bar charts to your spreadsheet - VLookup function - Creating popup lists - Creating Tables - Making headers look nice with color and formatting - Using Formulas - Copying rows and columns - Sorting horizontally - HLookUp - The Count Function - Date/Time data - Locking cells - Conditional formatting - Named formulas - Math formulas - Cell Ranges
Templates include:
- Billing Statement - Budget - Calendars (general, weekly, monthly, and annual) - Class schedule, gradebook and school calendar - Expense Tracker - Household budget - Invoice and inventory tracker - Packing slip - Payroll Register - Time Sheet - To Do list - Work Order
Are you a beginner who needs help learning how to use Excel, or trying to get back up to speed? If so this app is for you. Save time and be more productive by learning the basics of setting up and using spreadsheets in Microsoft Excel for the Mac.
NOTE: Template use requires purchase of Microsoft Office, which must be purchased separately.
|
Screenshots Video Training for Excel - with Templates
|