In this course, you will: apply conditional formatting to emphasize specific data elements, work with comments, use Paste Special options, create dynamic named ranges, set up a basic pivot table, show data trends with sparklines, evaluate data with subtotals, work with macros and Visual Basic programming and correct worksheet errors.
Take your basic PowerPoint presentations to the next level. Build upon the presentation skills learned in the introductory course. Learn how to link to a file from a slide, embed document content on a slide, add narration to a presentation, create a new Slide Master, enhance slide layouts, and add movies to slides.
The Introduction to Microsoft Excel 2010 course will demonstrate to users the functionality of a spreadsheet and the ease of use in storing, manipulating, analyzing, and visualizing data. You will learn the basic benefits of working with Excel and how to create and format an Excel worksheet. You will also learn how to navigate the Microsoft Excel 2010 environment, customize the Quick Access ...more