Using Microsoft Excel, students will learn to how to create advanced worksheets using Excel’s advanced features for filtering and sorting data. Students will also learn the power of Pivot Tables and how to use Slicers to filter data with the click of a mouse button. Students will also use advanced formulas, tables, graphics and PivotCharts to enhance their workbooks.
Course prerequisites include taking Excel 2013 Level 1 or an equivalent in working knowledge of the software. Course Details Advanced Formulas for Data Analysis with Logical and Lookup FunctionsCreate Range Names ManuallyCreate Range Names by SelectionManage Range NamesSpecialized Functions PMT, DSUM and moreLogical and Lookup Functions, VLOOKUP, IF Using Tables Create Tables Using the Table Tools Contextual tabUsing Table OptionsModify Tables and Convert to RangeSummarize a Table with a PivotTableUsing PivotTable Summary FunctionsSorting and Filtering Data in TablesExcel ChartsCreate & Format ChartsModify Chart Layouts and StructuresChange Chart Types, Options, LocationChange Source DataSave a Chart as a TemplateAdvanced ChartsAdding Trendlines Excel Reports with PivotTables, PivotCharts and SlicersCreating a PivotTable from a Data RangeUsing the PivotTable Contextual TabsRefreshing Data from a Range vs TableUsing SlicersUsing the Slicer Contextual TabCreating a Switchboard Using SlicersUsing PivotChartsFiltering Data using PivotChartsUsing the PivotCharts Contextual Tabs Annotating Using Graphical ElementUsing TextboxesModifying Textboxes using the Drawing Contextual TabInserting ClipArt Modifying ClipArt Adding Shapes and Laying ShapesUsing SmartArt Modifying SmartArt using the Contextual TabsPersonalizing your Workbooks Using Excel Options to Customize WorkbooksUsing, Creating and Managing Excel ThemesCreating and Using Personal TemplateProtecting Your Workbook formulasEncrypting Your Excel Files