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 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.
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 how to preview and print audience handouts; how to add animation and transition effects to slides; how to create a custom design theme and a custom template, which you use to create a new presentation; how to integrate Excel workbook data and charts in a presentation using copy and paste; how to add footer text, a date and slide numbers to slides; how to run a full-screen slide show using slide show controls; and how to run a slide show in Presenter view. Note that this course emphasizes using traditional keyboard and mouse actions to perform tasks in PowerPoint and Excel 2016. Some relevant tips for working with PowerPoint 2016 with a Windows 10 touch-screen device are also provided.
This course guides you through creating, copying and pasting, reviewing, and correcting basic and complex formulas in Excel 2016 using step-by-step hands-on activities.