Excel Power User (Live Online)

This two-day class offers the "best of" topics from our series of Excel classes:- Excel Introduction (just tips and short-cuts from this class)- Excel Charts Formatting and Reporting- Excel Database Features and Pivot Tables- Excel Workbooks, Formulas and Functions- Excel Macros (Supplemental Hand-out)This jam-packed, fast-paced class provides an overview of the most powerful and time-saving Excel techniques. In addition, you will receive a complete 5-volume set of Excel course materials from the above courses (with related data files).With this complete reference library you will be able follow along in class as well as review additional topics that were not covered in the two-day event. Individuals preparing for their MOS Certification who need a quick Excel refresher class might also find this course of interest.Version NoteWhile this class is being taught using the 2019 version of the Excel software, almost all topics (except for a few new 2016-only chart types) will be applicable to users of Excel 365/2019/2016/2013.Target StudentYou already know Excel and have been working with it for years. In the past, other Excel users might have even turned to you for assistance. But with all of the new features in Excel, your skills have not kept pace. To regain your edge, you don’t need an introduction class or a class on a single topic. You need a fast-paced overview. A class that will bring you up to speed on the latest features of Excel across all topics such as charting, database features, pivot tables, multiple worksheets, advanced functions and even an introduction to Macros. If you have a good foundation in Excel and want to be a Power User, this class is for you!Who Should NOT Take This ClassIf you are a novice Excel user, this class is not for you. Because this class is fast-paced, the instructor will not be able to stop and help individuals who do not meet the prerequisites and who do not know the basics of Excel. If you are new to the product, you will need to first take the Introduction to Excel class and then gain several months of experience creating worksheets before registering for the Power User class. For details on the entry-level course, go to Excel 2016 Introduction PrerequisitesThis class is not for beginning Excel users. The typical candidate for this class will be either self-taught or will have had some formal training in Excel and will have used Excel for 2 or more years.Course OutlineSelected Topics from “Introduction to Excel”Getting StartedWorking with the RibbonExploring the File TabWorking with the Quick Access ToolbarUsing Excel Help – Tell MeEntering DataSelecting a Range of CellsUsing Auto Fill to Enter DataUsing FormulasEntering FormulasUsing Auto Fill with FormulasUsing AutoSumPrinting WorksheetsUsing Page Setup ToolsWorking in Page Layout ViewUsing Page Break PreviewSelect Topics from “Excel Charts, Formatting & Reporting”Creating ChartsCreating a ChartChanging the Chart Location and SizeChanging the Chart TypeModifying Chart ElementsFormatting Chart ElementsAdding and Removing a Data SeriesApplying a Chart FilterWorking with ChartsCreating a Hierarchy ChartCreating a HistogramCreating a Pareto ChartCreating a Box and Whisker ChartCreating a Waterfall ChartCreating a Combo ChartCreating a SparklineCreating and Using a Chart TemplateCreating a DashboardUsing Styles, Themes, and TemplatesWorking with Cell StylesMerging StylesUsing ThemesUsing TemplatesCreating a TemplateWorking with FormattingCreating and Using Custom FormatsApplying Conditional FormattingCreating a New Conditional Formatting RuleUsing the Quick Analysis ToolUsing Excel Data in Other Office ApplicationsUnderstanding Pasting, Linking and EmbeddingPasting an Excel Range into a Word DocumentPasting an Excel Chart into a Word DocumentPasting an Excel Range into PowerPointPasting an Excel Chart into PowerPointCreating a Chart in Word or PowerPointSelect Topics from “Excel Workbooks, Formulas & Functions”Working with WorkbooksEditing a GroupWorking with Multiple Worksheets and WorkbooksCreating Linked FormulasViewing Multiple WorksheetsUsing Absolute Cell ReferencesCreating Linked Formulas between WorkbooksWorking with Financial and Date FunctionsUsing Financial FunctionsUsing Date FunctionsWorking with Logical FunctionsUsing the IF FunctionNesting FunctionsUsing Multiple Conditions with the IF FunctionNesting IF FunctionsWorking with Lookup and Reference FunctionsUsing HLOOKUP and VLOOKUP FunctionsUsing the MATCH FunctionUsing the INDEX FunctionNesting the INDEX and MATCH FunctionsUsing INDEX MATCH MATCHUsing INDEX MATCH & MATCHSelect Topics from “Excel Database Features and Pivot Tables”Using ListsCreating and Using Absolute Named RangesFreezing and Unfreezing PanesUsing Functions with ListsUsing Table FeaturesCreating a TableFiltering a TableCreating a SlicerWorking with the Total RowCreating a Calculated ColumnWorking with DataImporting Data from a Text FileUsing Flash FillConnecting to Data in an Access DatabaseCreating and Working with PivotTablesCreating a PivotTable using Worksheet DataCreating a PivotTable using an External Data ConnectionUsing a Report FilterUsing VLOOKUP to Add a Column to a ListEnhancing PivotTablesWorking with Summary FunctionsCreating a SlicerGrouping DataCreating a Calculated FieldCreating a PivotChartAnalyzing DataUsing Automatic OutliningInserting SubtotalsCreating an Advanced FilterUsing the Quick Analysis ToolSelect Topics from "Excel Macros"Working with MacroRecording a MacroCreating a Macro Button