Practical Excel 2016 for the Workplace - Fundamentals (ILT)
Instructors
Practical Excel 2016 for the Workplace – Fundamentals (ILT)
COURSE DESCRIPTION
This introductory course covers the fundamentals of Microsoft Excel 2016. It assumes you have used Excel, at least at an elementary level, such as opening and saving an Excel file. This course will drastically increase your productivity and broaden your Excel skills.
The course begins with the Excel user interface: the tabs and ribbons, the backstage view, and the Quick Access Toolbar. It then teaches you methods for performing common Excel tasks, such as moving around large worksheets, selecting ranges, copying and pasting, working with formulas, creating and modifying charts, and printing. It also teaches you best spreadsheet practices for making your spreadsheets attractive and understandable by others. Throughout, the focus is not just on performing common tasks in Excel, but performing them efficiently.
Category: Office Productivity/Microsoft
Duration: 1-2 Days
What are the requirements?
- Microsoft Office 2016
What am I going to get from this course?
- An understanding of the Excel user interface, including changes to Excel since 2007
- Efficiency tips on moving around worksheets and selecting large ranges
- Efficiency tips on copying, cutting, and selecting formulas and ranges
- How to manipulate rows, columns, and worksheets
- How to take control of printing worksheets
- How to format efficiently and effectively
- How to work effectively with formulas, including auditing for correctness
- How to create and modify charts effectively
- How to use common but powerful Excel functions, including IF and VLOOKUP
- Best practices for creating attractive and understandable spreadsheets
What is the target audience?
- Any beginning Excel users who want to become more efficient and take their Excel skills to the next level
Lesson Plan
| Introduction to Course | |
| Welcome to Fundamentals Course | |
| Intro to Optima Train Tutorial | |
| Evolution of Excel | |
| Changes in Excel | |
| Excel User Interface | |
| Intro to Excel User Interface | |
| Tabs and Ribbons | |
| Customizing Ribbons | |
| File Menu | |
| Quick Access Toolbar | |
| Opening Recent Files | |
| Excel Options | |
| File Extensions | |
| Single Document Interface | |
| Excel Basics | |
| Intro to Excel Basics | |
| Intro to Moving and Selecting | |
| Going Home to Cell A1 | |
| Splitting the Screen | |
| Selecting a Range with Keys | |
| Selecting a Range by Pointing | |
| Selecting Multiple Ranges | |
| Go To Options | |
| Copying, Cutting, & Pasting | |
| Intro to Copying, Cutting, Pasting | |
| Copying and Pasting | |
| Cutting and Pasting | |
| Paste Special Options | |
| Transposing a Range | |
| Office Clipboard | |
| Other Basic Tools | |
| Intro to Other Basic Tools | |
| Undoing Actions | |
| Right-Clicking | |
| Shortcut Keys | |
| Number Formats | |
| Manipulating Rows, Columns | |
| Manipulating Worksheets | |
| Printing | |
| Cell Borders | |
| Shapes and Pictures | |
| Filling a Series | |
| Sorting and Custom Lists | |
| Adding Hyperlinks | |
| Templates | |
| Formulas | |
| Working with Formulas | |
| Relative, Absolute Addresses | |
| Calculation Options | |
| AutoSum Button | |
| Error Codes | |
| Range Names 1 | |
| Charts | |
| Intro to Charts | |
| Creating a Chart | |
| Modifying a Chart | |
| Locating a Chart | |
| Sparklines | |
| Functions | |
| Intro to Functions | |
| Function Help | |
| Intro to Basic Summarizing Functions | |
| SUM, AVERAGE, PRODUCT | |
| COUNT, COUNTA, COUNTBLANK | |
| SUMPRODUCT | |
| Intro to Two Essential Functions | |
| IF | |
| VLOOKUP | |
| Spreadsheet Best Practices | |
| Intro to Spreadsheet Best Practices | |
| Documenting Your Work | |
| Themes | |
| Styles | |
| Conditional Formatting | |
| Conclusion to Course | |
| Conclusion to Fundamentals Course |
Course Reviews
No Reviews found for this course.
