Get yourself trained on The Ultimate Complete with this Online Training The Ultimate Complete Excel Training Package.
Online Training The Ultimate Complete Excel Training Package
EXCEL INTRODUCTIONMODULE 1: Getting Started with Microsoft ExcelLearning outcomes: Starting Excel and some of its basic navigation and help controls.Topics covered:Starting OutAbout WorkbooksExploring your WorkbookGetting Help with ExcelMODULE 2: The Excel InterfaceLearning outcomes: A look at the Ribbon interface and the different tabs and options the Ribbon offers.Topics covered:The Quick Access Toolbar and File MenuThe Home TabThe Insert TabThe Page Layout TabThe Formulas TabThe Data TabThe Review TabMODULE 3: Microsoft Excel BasicsLearning outcomes: Identify and Use Cells, Columns, Rows, Workbooks to enter and manage data.Topics covered:Working with ExcelMoving your DataBasic Excel FeaturesSmart Tags and Options ButtonsEditing ToolsMODULE 4: Editing your WorkbookLearning outcomes: Understanding formatting features and enhancing a workbook’s overall appearance and using Conditional Formatting.Topics covered:Cell FormattingConditional FormattingEnhancing a Worksheet’s AppearanceMODULE 5: Printing and Viewing your WorkbookLearning outcomes: Exploring Excel’s printing and viewing options enhancing your ability to print and work with your data effectively.Topics covered:Using the View TabManaging a Single WindowManaging Multiple WindowsPrinting your WorkbookPrint Page Layout optionsMODULE 6: Working with Charts in ExcelLearning outcomes: Introducing charts within Excel and explain how to create basic charts to help convey your data with.Topics covered:Using Recommended and Standard ChartsChart ElementsChart Tools – Design & FormatEXCEL INTERMEDIATEMODULE 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 SparklinesEXCEL ADVANCEDMODULE 1: Grouping & Outlining and SubtotalsLearning outcomes: Useful Excel functions to summarise a spreadsheet making the data easier to identify and explain.Topics covered:Outlining and Grouping DataUsing the Subtotals ToolMODULE 2: What-If AnalysisLearning outcomes: Tools designed to help with forecasting and finding solutions to complicated problems involving your spreadsheet’s data and formulas.Topics covered:Exploring ScenariosGoal Seek and Data TablesUsing SolverMODULE 3: PivotTablesLearning outcomes: Creating Pivot Tables in order to display and summarise large quantities of data effectively.Topics covered:Getting Started with PivotTablesDisplaying Data in a PivotTableFormatting a PivotTableUsing the Classic PivotTable LayoutSlicersMODULE 4: Charting Pivoted DataLearning outcomes: Introducing Pivot Charts, adding specialist pivot charts to the already excellent Pivot Table feature.Topics covered:Getting Started with PivotChartsUsing the PivotChart Tools TabsFormatting a PivotChartMODULE 5: Advanced Excel TasksLearning outcomes: Here we will look at sharing Excel files along with adding hyperlinks and Custom AutoFill Lists.Topics covered:Excel and HyperlinksUsing Custom AutoFill ListsSharing WorkbooksMODULE 6: Creating HLOOKUP and VLOOKUP FunctionsLearning outcomes: Exploring the different Lookup functions, ideal add further functionality to a spreadsheet to reference particular data quickly and effectively.Topics covered:Using the VLOOKUP FunctionUsing the LOOKUP FunctionMODULE 7: Introduction to Macros in ExcelLearning outcomes: Explore how to create your own Macros and introducing Visual Basic for Applications, the application Macros are created in.Topics covered:Recording and Playing MacrosCopying and Deleting MacrosVisual Basic and MacrosEXCEL PROFESSIONALMODULE 1: Advanced Conditional FormattingLearning outcomes: Looking at the more advanced Conditional Formatting features and how to manage them effectively.Topics covered:Editing Standard Formatting RulesUsing Formulas in Conditional FormattingMODULE 2: Using Form Controls and TemplatesLearning outcomes: Introducing Form controls and using them to manage user interaction to help ensure they enter/search for information both accurately and effectively.Topics covered:Using Form ControlsCreating TemplatesMODULE 3: Advanced Lookup FunctionsLearning outcomes: An in-depth look into Excel’s specialist lookup functions and the concept of arrays.Topics covered:Using the Index FunctionUsing the Match FunctionUsing Index and Match TogetherUsing Index and Match with Array FormulaUsing the Indirect FunctionMODULE 4: Advanced Functions in ExcelLearning outcomes: Effectively using Error, Logical and Rounding functions along with array formulas.Topics covered:Using Error FunctionsUsing Logical FunctionsUsing Array FormulasUsing Rounding FunctionsMODULE 5: Advanced Pivot Table ToolsLearning outcomes: How to import Pivot Table data from external source along with adding custom fields and formulas.Topics covered:Importing Pivot Table DataCalculated Fields in Pivot TablesShowing Pivot Data as a PercentageCreating Custom Pivot Tables StylesMODULE 6: Introduction to User Defined Functions Using VBALearning outcomes: Using VBA to create specialist procedure and to define your own Excel functions.Topics covered:Creating a User Defined FunctionCreating an Interactive ProcedureCreate and Share a Function Add-in
Udemy helps organizations of all kinds prepare for the ever-evolving future of work. Our curated collection of top-rated business and technical courses gives companies, governments, and nonprofits the power to develop in-house expertise and satisfy employees’ hunger for learning and development.
Learn on your schedule with Udemy
Investing in yourself through Learning
As a society, we spend hundreds of billions of dollars measuring the return on our financial assets. Yet, at the same time, we still haven’t found convincing ways of measuring the return on our investments in developing people.
And I get it: If my bank account pays me 1% a year, I can measure it to the penny. We’ve been collectively trained to expect neat and precise ROI calculations on everything, so when it’s applied to something as seemingly squishy as how effectively people are learning in the workplace, the natural inclination is to throw up our hands and say it can’t be done. But we need to figure this out. In a world where skills beat capital, the winners and losers of the next 30 years will be determined by their ability to attract and develop great talent.
Fortunately, corporate learning & development (L&D), like most business functions, is evolving quickly. We can embrace some level of ambiguity and have rigor when measuring the ROI of learning. It just might look a little different than an M.B.A. would expect to see in an Excel model.