Online Training Microsoft Excel Professional by Udemy

Get yourself trained on Microsoft Excel Professional with this Online Training Microsoft Excel Professional.

Online Training Microsoft Excel Professional

MODULE 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.