Fully Customizable Courseware For Trainers
Office Excel 2013: Core Essentials
DOWNLOAD A FREE SAMPLE
If your students are looking for information on using Excel 2013, look no further! We’ve designed a comprehensive one-level Office Excel 2013 Core Essentials courseware program that covers all the essentials of working with Excel.
Topics covered in this course include using basic formulas and functions; time-saving tools (like AutoFill, AutoComplete, AutoSum, and the new Flash Fill); PivotTables and PivotCharts; workbook formatting techniques; inserting objects (like SmartArt, charts, and text boxes); exporting a workbook as PDF or XPS; and customizing the interface.
As if that’s not enough, this Microsoft Excel 2013 training materials package includes an instructor’s guide, exercise workbook and files, lesson plan, and PowerPoint slides. They’re even customizable so that you can design a unique learning experience for each course that you teach.
Module 1: The Basics
Getting Started
Signing In
Creating a New Workbook
Parts of a Workbook
Saving a Workbook
Opening a Workbook
Review Questions
Module 2: Your First Workbook
Selecting Data
Entering and Deleting Data
Using Undo and Redo
Using Cut, Copy, and Paste
Review Questions
Module 3: Working with Data
Inserting Rows and Columns
Merging and Splitting Cells
Moving Cells
Using Paste Special
Using Find and Replace
Hiding and Unhiding Cells
Review Questions
Module 4: Using Basic Excel Tools
Understanding Cell References and Formulas
Using Basic Formulas
Using Basic Functions
Using Advanced Functions
Using Spell Check
Using Sort and Filter
Review Questions
Module 5: Using Timesaving Tools
Using AutoFill
Using Flash Fill
Using AutoSum
Using AutoComplete
Using AutoCalculate
Review Questions
Module 6: Formatting Text
Changing the Font Face, Size, and Color
Applying Text Effects
Applying Borders and Fill
Using the Font Tab of the Format Cells Dialog
Clearing Formatting
Review Questions
Module 7: Formatting Data
Wrapping Text
Changing the Size of Rows and Columns
Adjusting Cell Alignment
Changing Text Direction
Changing Number Format
Review Questions
Module 8: Formatting the Workbook
Using Cell Styles
Formatting Data as a Table
Changing the Theme
Inserting Page Breaks
Adding a Background
Review Questions
Module 9: Inserting Art and Objects
Inserting SmartArt
Inserting Text Boxes
Inserting Pictures
Inserting Equations
Drawing Shapes
Review Questions
Module 10: Charting Data
Creating Sparklines
Inserting Charts
Inserting PivotTables
Inserting PivotCharts
Using Slicers
Creating Timelines
Review Questions
Module 11: Viewing, Printing, and Sharing Your Workbook
Using Views
Saving a Workbook as PDF or XPS
Printing a Workbook
E-Mailing a Workbook
Sharing Your Workbook on SkyDrive
Review Questions
Module 12: Customizing the Interface
Changing Ribbon Display Options
Customizing the Quick Access Toolbar
Hiding and Showing Ribbon Tabs
Creating Custom Ribbon Tabs
Resetting Interface Changes
Review Questions
If your students are looking for information on using Excel 2013, look no further! We’ve designed a comprehensive one-level Office Excel 2013 Core Essentials courseware program that covers all the essentials of working with Excel.
Topics covered in this course include using basic formulas and functions; time-saving tools (like AutoFill, AutoComplete, AutoSum, and the new Flash Fill); PivotTables and PivotCharts; workbook formatting techniques; inserting objects (like SmartArt, charts, and text boxes); exporting a workbook as PDF or XPS; and customizing the interface.
As if that’s not enough, this Microsoft Excel 2013 training materials package includes an instructor’s guide, exercise workbook and files, lesson plan, and PowerPoint slides. They’re even customizable so that you can design a unique learning experience for each course that you teach.
Module 1: The Basics
Getting Started
Signing In
Creating a New Workbook
Parts of a Workbook
Saving a Workbook
Opening a Workbook
Review Questions
Module 2: Your First Workbook
Selecting Data
Entering and Deleting Data
Using Undo and Redo
Using Cut, Copy, and Paste
Review Questions
Module 3: Working with Data
Inserting Rows and Columns
Merging and Splitting Cells
Moving Cells
Using Paste Special
Using Find and Replace
Hiding and Unhiding Cells
Review Questions
Module 4: Using Basic Excel Tools
Understanding Cell References and Formulas
Using Basic Formulas
Using Basic Functions
Using Advanced Functions
Using Spell Check
Using Sort and Filter
Review Questions
Module 5: Using Timesaving Tools
Using AutoFill
Using Flash Fill
Using AutoSum
Using AutoComplete
Using AutoCalculate
Review Questions
Module 6: Formatting Text
Changing the Font Face, Size, and Color
Applying Text Effects
Applying Borders and Fill
Using the Font Tab of the Format Cells Dialog
Clearing Formatting
Review Questions
Module 7: Formatting Data
Wrapping Text
Changing the Size of Rows and Columns
Adjusting Cell Alignment
Changing Text Direction
Changing Number Format
Review Questions
Module 8: Formatting the Workbook
Using Cell Styles
Formatting Data as a Table
Changing the Theme
Inserting Page Breaks
Adding a Background
Review Questions
Module 9: Inserting Art and Objects
Inserting SmartArt
Inserting Text Boxes
Inserting Pictures
Inserting Equations
Drawing Shapes
Review Questions
Module 10: Charting Data
Creating Sparklines
Inserting Charts
Inserting PivotTables
Inserting PivotCharts
Using Slicers
Creating Timelines
Review Questions
Module 11: Viewing, Printing, and Sharing Your Workbook
Using Views
Saving a Workbook as PDF or XPS
Printing a Workbook
E-Mailing a Workbook
Sharing Your Workbook on SkyDrive
Review Questions
Module 12: Customizing the Interface
Changing Ribbon Display Options
Customizing the Quick Access Toolbar
Hiding and Showing Ribbon Tabs
Creating Custom Ribbon Tabs
Resetting Interface Changes
Review Questions
Everything you need to deliver amazing training
Each courseware title is a trainers' kit that comes with the following course components:
Instructor Guide
Velsoft Instructor Guides are the core of each training course. Our Instructor Guides lay out the training in simple, easy-to-follow instructions. You can also customize the Instructor Guides in order to personalize your training.
Student Manual
Each Instructor Guide - for each course - is paired with a Student Manual that you can present to your participants. This customizable manual gives each participant the student version of the course you will be teaching.
PowerPoint Deck
Courseware from Velsoft is designed to give you everything you need for use in the classroom or for your workshop. This includes the PowerPoint versions of all the courses, prepared for you in advance.
Quick Reference Guide
Quick Reference Guides are a favorite tool for trainers to provide to their learners. Each Quick Reference Guide summarizes the most important elements in each courseware title down to two pages.
Fully Customizable
Make any changes you like including easily taking our branding off and replacing it with yours.
Unlimited Users
Train as many participants at your location as you like - forever!
Unlimited Printing Rights
Print-on-demand only what you need for as many participants with no limits.
No Annual Renewal Fees
One-off pricing. Never pay again to use the materials.
Fully Customizable
Make any changes you like including easily taking our branding off and replacing it with yours.
Unlimited Users
Train as many participants at your location as you like - forever!
Unlimited Printing Rights
Print-on-demand only what you need for as many participants with no limits.
No Annual Renewal Fees
One-off pricing. Never pay again to use the materials.
