Fully Customizable Courseware For Trainers
Microsoft Excel 2013: Expert
Deliver high-impact training with professionally designed, fully editable courseware you can brand, customize, and deliver in-person or online
$795.00
Teach your students Advanced Excel 2013 skills with this fully customizable Microsoft Excel 2013 Expert training course from Velsoft.
The 12 modules included in this course cover:
- Conditional formatting
- Slicers
- Power View
- Inquire Add-In
- Tables
- Records and Fields
- Excel as a database
- Custom AutoFill lists
- Comments
- Tracking Changes
- Linking, consolidating, and combining data
Each Velsoft training package includes an instructor guide, quick reference guide, exercise workbook, PowerPoint slides and more.
Download a free sample todayand see how we can help you deliver high-quality training.
Module 1: Using Conditional Formatting
Applying Conditional Formatting
Applying Multiple Rule Sets
Creating Custom Rule Sets
Viewing and Managing Rules
Clearing Custom Rules
Review Questions
Module 2: Working with Slicers
Inserting and Using a Slicer
Renaming the Slicer
Changing Slicer Settings
Formatting a Slicer
Clearing the Slicer
Review Questions
Module 3: Using Power View, Part One
Enabling Power View
Creating a Power View
Adding and Removing Fields
Arranging Fields
Filtering Data
Sorting Data
Review Questions
Module 4: Using Power View, Part Two
Refreshing Data
Choosing a Visualization
Changing Tile Display
Setting Display Options
Review Questions
Module 5: Using the Inquire Add-In
Installing Inquire
Generating a Workbook Analysis Report
Viewing Workbook and Worksheet Relationships
Viewing Cell Relationships
Comparing Two Workbooks
Review Questions
Module 6: Working with Tables
What is a Table?
Creating Tables
Resizing the Table
Choosing a Table Style
Clearing the Table
Review Questions
Module 7: Working with Records and Fields
What are Records and Fields?
Adding Fields by Inserting Columns
Adding Records by Inserting Rows
Deleting Records or Fields
Review Questions
Module 8: Using Excel as a Database
Filtering with Wildcard Characters
Validating Your Data
Data Validation Using Lists
Data Validation Using Formulas
Using Database Functions
Review Questions
Module 9: Using Custom AutoFill Lists
Creating a Custom AutoFill List
Using a Custom AutoFill List
Modifying a Custom AutoFill List
Deleting a Custom AutoFill List
Review Questions
Module 10: Using Comments
Inserting Comments
Editing Comments
Navigating Through Comments
Deleting Comments
Review Questions
Module 11: Tracking Changes
Tracking Changes
Reviewing Changes
Setting Options for Tracking Changes
Stopping Tracking Changes
Review Questions
Module 12: Linking, Consolidating, and Combining Data
Linking Workbooks
Consolidating Workbooks
Consolidating Worksheets
Pivoting Consolidated Data
Review Questions
 Select the format that works best for your organization or learners
Instructor-Led Training Kits
Complete training kit with everything you need to facilitate.
- Instructor Guide
- Participant Manual
- PowerPoint Slides
- Print-Ready Files
- Editable in Word/PowerPoint
- More
SCORM eLearning Courses
Ready-to-deploy eLearning for any SCORM-compliant LMS.
- SCORM 1.2 Package
- LMS Compatible
- Completion Certificates
- Progress Tracking
- Mobile Responsive
Storyline Source Files
Editable .story files for full customization in Articulate 360.
- Editable Source Files
- Articulate 360 Format
- Brand Customization
- Content Editing
- Interactive Elements
c1931c
What You Get
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.