Get yourself trained on Microsoft Excel Intermediate with this Online Training Microsoft Excel Intermediate.
Online Training Microsoft Excel Intermediate
MODULE 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 Sparklines
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.