Video Training for Excel 2013

$1.99

1.1.1for iPhone, iPad

Amazing eLearning LLC.

Developer

Mar 12, 2017

Update Date

Business

Category

App Store

Age Rating

Apps in this category do not contain restricted content.

Apps in this category may contain mild or occasional cartoon, fantasy or real-life violence, as well as occasional or mild adult, sexually suggestive or horrifying content and may not be suitable for children under 9 years of age.

12+

Apps in this category may contain occasional mild indecent language, frequent or intense cartoon or real-life violence, minor or occasional adult or sexually suggestive material, and simulated gambling, and may be for children under 12 years of age.

17+

You must be at least 17 years old to access this App.

Apps in this category may contain frequent and intense offensive language; Frequent and intense cartoon, fantasy or realistic violence: frequent and intense adult, scary and sexually suggestive subjects: as well as sexual content, nudity, tobacco, alcohol and drugs, may not be suitable for children under 17 years of age.

Video Training for Excel 2013 Capturas de tela

iPad

iPhone

About Video Training for Excel 2013

Get Trained on the newly released Excel 2013 in a few hours!

This iPAD app is an excellent training program to speed up your learning of new Excel 2013 spreadsheet program in less than a few hours and apply to your own projects.

Why learn the new features on your own if you can easily take our Microsoft Excel 2013 training app to master the new version of the most popular spreadsheet program used worldwide.

Course Outline:
Lesson 1: Getting Acquainted with Excel 2013
1.1 Introduction to Excel spreadsheet
1.2 The interface of Excel 2013
1.3 Customizing the Quick Access toolbar
1.4 Understanding the status bar
1.5 Using Zoom-in and Mini toolbar
1.6 Using simple keyboard keys to move around

Lesson 2: Basic Operation
2.1 Creating and Converting Workbooks
2.2 Understanding Type of Data You Enter
2.3 Entering data using Enter and Tab Key
2.4 Performing basic operations: edit, move, copy and delete
2.5 Using AutoFill
2.6 Using Flash Fill (new)

Lesson 3: Worksheet Format
3.1 Changing fonts and font styles
3.2 Changing number format settings
3.3 Adjusting row height and column width
3.4 Hide/unhide rows and columns
3.5 Applying Borders, Shading and Gradient Fill
3.6 Cell Formatting
3.7 Table Formatting

Lesson 4: Formula and Functions
4.1 Using Formulas
4.2 Entering Formulas
4.3 Using Sum formulas
4.4 Using Sum, Average and SumIF Function
4.5 VLookup function

Advanced Level (in-app purchase only)

Lesson 5: Editing Graphics
5.1 Inserting pictures
5.2 Editing pictures
5.3 Using SmartArt
5.4 Inserting shapes
5.5 Capturing a Screenshot
5.6 Overlapping, grouping,& hiding graphics

Lesson 6: Chart Design
6.1 Inserting Charts
6.2 Changing Chart Elements
6.3 Changing Source Data
6.4 Changing Layouts and Styles
6.5 Formatting Chart Elements
6.6 Enhancing a Chart

Lesson 7: Managing Data Lists and Pivot Table Report
7.1 Creating and Filtering a Data List
7.2 Using Sort & Filter
7.3 Using Subtotal
7.4 Creating PivotTable Report

Lesson 8: Automating Tasks with Macros
8.1 Installing Developer Tab
8.2 Recording Macro
8.3 Editing Macro
8.4 Macro Security

Lesson 9: Helpful Keyboard shortcuts and hints
9.1 Creating Excel Spreadsheet/chart in Word and PowerPoint
9.2 Using Keyboard Shortcuts
9.3 Helpful Hints