Get yourself trained on Advanced Excel with this Online Training Advanced Excel.
Online Training Advanced Excel
Advanced Excel 2007 is a course aimed at the excel user who is fairly competent on the software but is just looking for a few more handy tips and tricks to really get to know what this software can do. If you are handling data, or have the responsibility for analyzing data or presenting information in a useful format – reports for your team, or managers etc., then this course will be very handy.We don’t want you to spend a day of your life in the classroom… learn 4 useful, practical things which you can apply on your job or on your projects.1. Goal seek and ‘what if’ analysisWhen working with worksheet models – do you have the answer you want, but must work backward to find the input value that gives you that answer? Goal seek will help you. If you have to analyse scenarios for forecasting – what if X happens, instead of Y? The ‘what if’ section will help you.2. Data TablesData can be confusing and difficult to interpret or understand if it’s not presented in logical format. Data tables can really help.3. Using Pivot TablesA pivot table is an interactive worksheet table that quickly summarizes large amounts of data using a format and calculation methods that you may choose yourself.4. Extended graphicsAnalyse the trends that are apparent and create charts to present information clearly for work reports, essays and assignments.The target audience is those who are at an intermediate level with Excel and want to learn other handy functions and features. We use Excel 2007 only in this course. If you have Excel 2003, this course will be difficult to follow as although the functions and features exist in 2003, the layout changed very dramatically between the two versions. Excel 2007 isn’t too dissimilar from 2010.A booklet with screen shots is given in lecture one, so that you can follow step by step what we do in each lecture. We also provide a spreadsheet with each lecture – for you to practice what was done in that lecture/The course will take approx 2-3 hours to complete.Take this course if you want to take your intermediate-level understanding of Excel to an advanced level.
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.