The Microsoft Excel 2013 Intermediate Level course will build on the skills learned in the Introduction course. In this course, you will: work with multiple worksheets to consolidate data and add 3-D references to formulas, use logical functions with comparison operators, create custom formats, view data based on autofilters, create multi-level sorts, remove duplicates and find unique values, and ...more
The Microsoft Excel 2013 Advanced Level course builds upon the data organization and spreadsheet skills learned in the Introduction and Intermediate Excel 2013 courses. 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, ...more
In this course, add video to a News template and as an element on a webpage, edit the left navigation bar, create a form with fields for visitor input, customize Twitter and Facebook elements, update staff/faculty profile and view alternate ways .pdf files can be viewed.