Tables and Formulas with Excel

Partner: Udemy
Affiliate Name:
Area:
Description: Are you wanting to learn all there is to know about 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.  Do you want to know how to increase your productivity as you use tables, conditional formatting and formulas with ease in your Excel spreadsheets?  This course is easy to follow, with a step-by-step approach and also includes practical activities for you to practice the skills that you have been learnt along the way.COURSE CONTENT AND OUTCOMETablesHow 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 VLOOKUPA minimum of Excel 2007 is required to be able to work with the Tables, Conditional Formatting and some of the formula functions.ABOUT THE TRAINERI am a Udemy Instructor Partner with more than 20 years' experience in training & management consulting. I specialise in training business users to learn powerful methods and techniques to transform data into useful information and intelligence as well as learning strong dat
Category: Office Productivity > Microsoft > Excel Formulas and Functions
Partner ID:
Price: 29.99
Commission:
Source: Impact
Go to Course