Get yourself trained on Tables and Formulas with this Online Training Tables and Formulas with Excel.
Online Training Tables and Formulas with Excel
**** Life time access to course materials and practice activities. 100% money back guarantee ****This course is presented by Ian Littlejohn – who with over 23000 students is one of the most popular instructors on Udemy.Ian provides world leading courses on Excel, Power Pivot, Power BI and Google Data Studio.Welcome to this course on Tables, Conditional Formatting and Excel formulas. This course is for all Excel users who want to take their Excel skills and capabilities to the next level. This course will increase your productivity as you use tables, conditional formatting and formulas with ease in your Excel spreadsheets. The course is presented in an easy to follow step by step approach. The course also includes practical activities for the student to practice the skills that have been learnt in the course. The course will provide you with a comprehensive understanding of the following:TablesHow to create and format TablesHow to easily filter data in text, numeric and date fieldsEasily Sum, Average, Count and use Max and Min in your tablesUse Slicers to easily filter Table dataConditional FormattingHow to apply conditional formatting rulesHow to easily highlight the Top 10 Learn to use Data Bars and Color ScalesLearn to apply iconsFormulasLearn SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF and COUNTIFSLearn a range of Date formula such as Year, Month, WeekDay, NetWorkDays amd WorkDayLearn Text formulas such as LEFT, MID, RIGHT and TRIMLearn to use the IF formula to create powerful ‘IF Then’ logicLearn the HLOOKUP and VLOOKUPThis course is presented in Excel 2013. A minimum of Excel 2007 is required to be able to work with the Tables, Conditional Formatting and some of the formula functions.
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.