In this course you will learn how to use a number of formulas that will help you get your work done with less effort, as well as how to leverage the benefits of Excel tables. You will also learn about using conditional formatting. ABOUTTHETRAINERThis course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5.WHATSTUDENTSARESAYING:“This training was very helpful in upgrading knowledge in Excel with the help of practical exercises. I would definitely recommend this course.“Excellent, efficient and informative course. The exercises after each set of videos was particularly useful.“I found the course very informative. I am pretty good with excel but I learned quite a few tips and tricks that I can implement.” Life time access to course materials and practice activities. ABOUTTHECOURSEWelcome 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 you to practice the skills that you have been learnt on 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.
