Get yourself trained on Microsoft Excel with this Online Training Microsoft Excel – Learn Advanced Excel Lookups & Functions.
Online Training Microsoft Excel – Learn Advanced Excel Lookups & Functions
Table of Contents1. Getting Started: Get familiar with Excel Learn the basic operations and formulas of excel. Introduction to Excel Why should we learn Excel? Orientation / Tour Interface & Terminology Excel worksheets Excel Ribbon Backstage View Quick Access Toolbar Keyboard shortcuts2. Excel Basics: You will learn basic concepts in this module which will give you a chance to build a solid foundation. Cell Basics Modifying cells/rows/columns Basic Cell Formatting Cell Number Formats Cut, Copy & Paste Format Painter Personalizing Worksheets Multiple worksheets Find & Replace Sheet Protection Printing & Page Layout Assignment 3. FORMULAS & FUNCTIONS: In-depth lessons on formulas, functions, lookup functions and data validation with Excel. Intro Basic Formulas Advanced Formulas Cell References Excel Functions Date/Time Functions Text Functions Financial Functions Logical Functions Lookup Functions Data Validation Troubleshooting Assignment 4. WORKING WITH DATA: You will learn all about data organization and data visualization. Basic tips for working with data Freezing panes and view options Data sorting Data filtering Tables Charts Assignment 5. ADVANCED CONCEPTS: You will learn the skills needed to automate, analyze & present Excel data in the most effective manner. Conditional Formatting What-If Analysis Pivot Tables 1 Pivot Tables 2 Pivot Tables 3 Assignment
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.