Office Productivity, Online Courses, Practical Knowledge for the Workplace
Practical Excel 2016 for the Workplace – Fundamentals
4.8( 4 REVIEWS )
70 STUDENTS
Instructors
Course Curriculum
| Files to Use | |||
| Exercise Files | 00:00:00 | ||
| Introduction to Course | |||
| Welcome to Excel 2016 Fundamentals Course | FREE | 00:00:00 | |
| Intro to Optima Train Tutorial | FREE | 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 | ||
| Single Document Interface | 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 | |||
| Intro to 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 | ||
| Chart Types | 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 Excel 2016 Fundamentals Course | 00:00:00 | ||