Video Training for Excel - with Templates
Detailed App Info:
Application Description
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.
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.
Requirements
Your mobile device must have at least 708.71 MB of space to download and install Video Training for Excel - with Templates app. Video Training for Excel - with Templates is available on iTunes for $19.99
If you have any problems with installation or in-app purchase, found bugs, questions, comments about this application, you can visit the official website of Bluewater Publishing LLC at http://bluewaterpublishing.net.
Copyright © 2013 Bluewater Publishing LLC