(SSMG111/25) Surgent’s Microsoftr Excelr 2016: Getting Started
This course introduces you to the Excel 2016 software and then guides you through basic Excel features using step-by-step hands-on activities.
Credit Hours: 6
This course introduces you to the Excel 2016 software and then guides you through basic Excel features using step-by-step hands-on activities.
This course guides you through creating formulas using Financial, Date & Time, Math & Trig, Statistical, Lookup & Reference, Database, Text and Logical functions.
Excel provides a variety of tools you can use to create, format and enhance charts: contextual Ribbon tab buttons, menus and galleries, shortcut menus, keyboard shortcuts, task panes, and more. This course allows you to explore using these tools to create and format common chart types.
This course guides you through creating, copying and pasting, reviewing, and correcting basic and complex formulas in Excel 2019 using step-by-step, hands-on activities.
Microsoftr Excelr 365/Excelr 2019: Working with Data Ranges and Tables is a two-lesson, intermediate level course that guides you through organizing, entering, and validating worksheet data and then effectively sorting, filtering, subtotaling, and outlining the data. You also learn how to define well-organized data as an Excel table; then use Table features to work with...
This course is a one-lesson intermediate level course that guides you through using the Quick Analysis feature to quickly insert row and column totals and creating formulas using Financial, Date & Time, Math & Trig, Statistical, Lookup & Reference, Database, Text, and Logical functions. The functions covered in this course are the:•IRR, NPV, FV, PV,...
This course is a three-lesson basic level course that guides you through opening, creating, formatting, previewing, printing, and saving text documents.
Microsoftr Excelr 365 and Excelr 2019: Getting Started with Excel is a three-lesson basic level course that introduces you to the Excel software and then guides you through basic Excel features using step-by-step hands-on activities.Although this is a basic level course, experienced Excel users switching from earlier versions of Excel can benefit from this course's...
This course is a one-lesson intermediate level course that guides you through creating formulas using Financial, Date & Time, Math & Trig, Statistical, Lookup & Reference, Database, Text, and Logical functions.
This course is a two-lesson advanced level course that guides you through creating, formatting, and modifying PivotTables and PivotCharts in Excel using step-by-step hands-on activities.
This course is a two-lesson advanced level course that guides you through creating, formatting, and modifying PivotTables and PivotCharts in Excel using step-by-step hands-on activities.In Lesson 1, you learn how to create a blank PivotTable; then use the Fields List to manually arrange data in the PivotTable. Next, you learn how to create a PivotTable...
This course guides you through creating and opening PowerPoint presentations; inserting, reorganizing, and deleting slides; applying a design theme and switching between different PowerPoint views. You learn how to insert various types of content on slides, such as bulleted lists, tables, charts, shapes, pictures, SmartArt graphics and sound clips; how run a slide show and...