OptimaTrain

Course Curriculum

Files to Use
Exercise Files 00:00:00
Introduction to Course
Welcome to Fundamentals Course FREE 00:00:00
Intro to Optima Train Tutorial 00:00:00
Excel User Interface
Intro to Excel User Interface 00:00:00
Tabs and Ribbons FREE 00:00:00
Customizing Ribbons 00:00:00
File Menu 00:00:00
Quick Access Toolbar 00:00:00
Opening Recent Files 00:00:00
Excel Options 00:00:00
File Extensions 00:00:00
Evolution of Excel
Changes in Excel 00:00:00
Excel Basics
Intro to Excel Basics 00:00:00
Intro to Moving and Selecting 00:00:00
Going Home to Cell A1 00:00:00
Splitting the Screen 00:00:00
Selecting a Range with Keys 00:00:00
Selecting a Range by Pointing 00:00:00
Selecting Multiple Ranges 00:00:00
Go To Options 00:00:00
Copying, Cutting, & Pasting
Intro to Copying, Cutting, Pasting 00:00:00
Copying and Pasting 00:00:00
Cutting and Pasting 00:00:00
Paste Special Options 00:00:00
Transposing a Range 00:00:00
Office Clipboard 00:00:00
Other Basic Tools
Intro to Other Basic Tools 00:00:00
Undoing Actions 00:00:00
Right-Clicking 00:00:00
Shortcut Keys 00:00:00
Number Formats 00:00:00
Manipulating Rows, Columns 00:00:00
Manipulating Worksheets 00:00:00
Printing 00:00:00
Cell Borders 00:00:00
Shapes and Pictures 00:00:00
Filling a Series 00:00:00
Sorting and Custom Lists 00:00:00
Adding Hyperlinks 00:00:00
Templates 00:00:00
Formulas
Working with Formulas 00:00:00
Relative, Absolute Addresses 00:00:00
Calculation Options 00:00:00
AutoSum Button 00:00:00
Error Codes 00:00:00
Range Names 1 00:00:00
Charts
Intro to Charts 00:00:00
Creating a Chart 00:00:00
Modifying a Chart 00:00:00
Locating a Chart 00:00:00
Sparklines 00:00:00
Functions
Intro to Functions 00:00:00
Function Help 00:00:00
Intro to Basic Summarizing Functions 00:00:00
SUM, AVERAGE, PRODUCT 00:00:00
COUNT, COUNTA, COUNTBLANK 00:00:00
SUMPRODUCT 00:00:00
Intro to Two Essential Functions 00:00:00
IF 00:00:00
VLOOKUP 00:00:00
Spreadsheet Best Practices
Intro to Spreadsheet Best Practices 00:00:00
Documenting Your Work 00:00:00
Themes 00:00:00
Styles 00:00:00
Conditional Formatting 00:00:00
Conclusion to Course
Conclusion to Fundamentals Course 00:00:00