MP4 | Video: h264, 1280×720 | Audio: AAC, 48 KHz, 2 ChGenre: eLearning | Language: English + .VTT | Duration: 3.5 hours | Size: 2.14 GBImproving your performance by learning some of the more popular Excel featuresWhat you’ll learnThis hands-on one-day training course has been designed to give delegates a solid understanding of more advanced tools and concepts used in Excel 2007, 2010, 2013 or 2016, in order to increase their knowledge and productivity.

RequirementsDelegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

DescriptionMODULE 1: Advanced File TasksLearning outcomes: A look at some important administrative features which are useful for managing and controlling Excel files.

Topics covered:Saving and File ManagementConverting and Encrypting FilesFile Properties and Digital SignaturesFile Accessibility and CompatibilityMODULE 2: Working with Functions and FormulasLearning outcomes: Some key formulas and functions essential to Excel users along with features to help manage formulas, functions and ranges.

Topics covered:Formulas with Absolute ReferencesAutosum Functions (SUM & AVERAGE)IF and Nested FunctionsWorking with Named RangesArray Functions (SUMIF & AVERAGEIF)Formula AuditingText FunctionsMODULE 3: Managing Tables in Microsoft ExcelLearning outcomes: Managing spreadsheet data in table format, an excellent feature to administrate large sets of data.

Topics covered:Creating Excel TablesWorking with Records and FiltersAdvanced FiltersMODULE 4: Data Tools in ExcelLearning outcomes: Features to help with managing spreadsheet data making it a less daunting and repetitive task to manage the data.

Topics covered:Text to ColumnsFlash FillRemove DuplicatesData ValidationConsolidateMODULE 5: Doing More with Charts in ExcelLearning outcomes: Developing your ability to effectively create charts and format them specific to the readerTopics covered:TrendlinesError BarsWorking with Axis OptionsAdvanced Chart FormattingMODULE 6: SparklinesLearning outcomes: Use Sparklines to help analyse data by creating small customisable charts within cells. Edit and format the Sparklines and data points to help your data stand outTopics covered:Creating SparklinesEditing SparklinesWho this course is for:Users with a basic understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to take their knowledge of the basic features further in a short space of time.