__________Course Overview:Are you looking to build your skills in using Microsoft Excel?This course gives you a deep understanding of how to use some of the most popular features and functions in Excel. We will build you from a base skill level and assume you have no prior knowledge in using Microsoft Excel or its functions. In this course we will cover Excel Introduction, Intermediate, Advanced and Formulas and Functions. Most lectures are 7 - 14 minutes long, with no lecture being over 20 minutes in length. Your trainer for this course, Richard Walters, is a Microsoft Certified Trainer who has been training Microsoft Excel for the past 10 years throughout the UK.__________Excel Introduction Outline:The Excel EnvironmentSelect and Highlighting CellsEntering InformationFormatting InformationModifying Information - Wrap Text and Merging CellsInserting/Deleting Columns and RowsSave, Save As and OpenFind Opening and Closing ExcelCreating and Copying FormulasUsing BODMAS in FormulasAbsolute Cell ReferencingUsing Functions - SUM, IF, COUNT, AVERAGEAutoSum FeaturesDifference between Excel manual and automated calculationsCreating and Formatting ChartsInserting, Moving and Deleting WorksheetsGrouping WorksheetsAutoFill FeatureLinking formulas between WorksheetsFreeze PanesPrint Area and Print Preview__________Excel Intermediate OutlinePaste special featuresCharts and Formatting ChartsConditional Formatting and Conditional FormulasSecurity (adding protection)Sub totalling informationFiltering and advanced filteringNamed cells, ranges and using names in formulasDatabase functionsLinking formulas & functionsMixed reference formulasAuditing FormulasFreeze PanesPrinting using freeze panes and Print Area__________Excel Advanced OutlineAdvanced Charts and Linking Charts to Other ApplicationsScenariosData TablesGoal SeekData ValidationPivot TablesFormulas & FunctionsConsolidated FormulasDate Formulas and FunctionsReferencing FormulasError FunctionsLogical Functions (IF, AND, OR)Nested Functions (IF, AND, OR)Lookup Functions (VLookup, HLookup)Mathematical Functions (Sumif, Sumifs)Statistical Functions (Countif, Countifs, Averageif, Averageifs,Countblank)Text Functions (Trim, Left, Right, Mid, Concatenate)__________Excel Formulas and Functions OutlineCreating Date FormulasNowDayMonthYearVlookupHlookupMatch and IndexIFErrorIFAndOrNotIF, AND, ORIF & VlookupIF & SumifSumifSumifsCountifCountifsAverageifAverageifsCountblankDSumDAdverageDMaxDMinTrimLeftRightMidConcatenate__________Excel Advanced Filtering and Pivot TablesMulti FiltersFiltering by ColourCustom FiltersCriteria Filtering (i.e. Greater Than, Less Than, Between, Not Equal To)Multi Criteria Filtering (Advanced Filter)Multi Criteria Filtering In Place and Copy of another LocationDesigning and Creating a Pivot TableModifying a Pivot Table LayoutUpdating a Pivot Table and using Pivot Table optionsManaging Pivot Table Totals and Sub TotalsGrouping Pivot Table DataCreating a Pivot Table using External DataFiltering Pivot Tables using Slicers and TimelinesPivot Table Dashboards using SlicersCreating Multiple Pivot Tables on the same sheetConsolidating Pivot Table DataPivot Table calculationsPivot Table Report pagesLinking using the GETPIVOTDATA functionCreating Pivot Charts and Modifying Pivot ChartsFiltering Pivot Charts__________Excel Data Visualised and Data Formatting Highlight Cell Values i.e. Find DuplicatesTop and Bottom RulesData BarsColour ScalesIcon SetsSum FunctionAverage FunctionAnd / OR FunctionsFormulas and Cell ReferencingConditional Formatting Date FormulasNow FunctionManaging and Deleting Conditional Formatting RulesConditional Formatting and Data ValidationConditional Formatting and Paste SpecialAdding Conditional Formatting settings to empty cellsConditional Formatting and Linked DataAdding SparklinesFormatting and Modifying SparklinesWhether you\'re looking for a quick overview on some of Excel\'s most popular features trying to diversify your Excel skill set, or hoping to step up your spreadsheet game in a major way, you\'ve come to the right place. In today\'s increasingly data-driven world, Excel makes it easy and intuitive to keep track of data sets. Enrol today and start your journey to becoming a Excel master!See you there!-Richard Walters (Microsoft Excel Trainer)