Get Trained on the newly released Excel 2013 in a few hours!
This app is an excellent self 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.
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
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
Features:
- 36+ Lessons/Topics to choose from
- In-depth explanation of each Excel topic
- Downloadable to your device
- Learn at anytime, anywhere without the need of Internet Access
- Learn 20x faster than reading book or eBook