Get yourself trained on Excel 2007 Simplified with this Online Training Excel 2007 Simplified.
Online Training Excel 2007 Simplified
This course is aimed at the excel user who already knows the basics of Excel 2007. This course will help you to go beyond the basics – to reach a higher-intermediate level. With shortcuts, tricks and tips – you will be able to work smarter and faster. If you want to be fairly competent on the software, then this course will be very handy. Its a lot quicker to be shown things, then to try and muddle through and work things out by yourself. Guaranteed, there'll be some items which we cover, that you have no idea that Excel was capable of doing!We don't want you to spend a day of your life in the classroom… learn 99 quick and very useful, practical things which you can apply on your job or on your projects.We'll cover:Working with Data – using series, symbols and special characters, hide rows and freeze panelsFormulas and Functions – Calculate the duration between two dates/times, best loan terms, create conditional formula and conditional sumsCopying Data – transposing rows into columns and paste specialsUsing Excel lists – sort and filter a list, remove duplicate records, count filtered records, look up information in a listData Patterns – Pivot tables, pivot charts, what-if analysisCreating charts – histogram, trendlines, piecharts, error barsPresenting data – formatting columns and numbersSaving and printing worksheets – printing multiple worksheets, area, cell ranges, repeat headings of a row or columnExtending excel – hyperlinks, embed a chart, importing a worksheetCustomizing Excel – custom workspace, custom view, macrosThe target audience is those who have a basic 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.Where necessary, we provide a spreadsheet – but as long as you have Excel 2007, you'll be able to copy and do exactly what you see on the screen by pausing the video and following along. The course will take approx 7.5 hours to complete.Take this course if you want to take your basic understanding of Excel to a higher intermediate-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.