To work efficiently with formulas and functions you must start with clear understanding, good habits, and application of correct structure and syntax.This webinar effectively demonstrates and teaches examples of formulas and specific functions, providing the perspective you need to understand the depth and scope of these Excel features. Gaining this knowledge is a fundamental and highly marketable skill set in Excel and is vital in a wide range of professions and fields including accounting, financial analysis, government and business administration. Understand and work effectively with fundamental and versatile calculation and analysis techniques in Excel beyond the introductory level.Learning ObjectivesTo gain a practical “hands-on” understanding of functions, lookups and linking in MS Excel.Areas Covered Concatenation – combine text and numbers in 2 or more cells AND and OR used with the IF function VLOOKUP – lookup and match data efficientlyPMT – calculate loan repayments with easeKey text functions – cleanse data from external sources Link between worksheets and workbooksKey Date functions – use dates in calculations Formula auditing – manage, trace, and correct formulasWho Should AttendAnyone seeking to significantly boost profits, competitive advantage, productivity, job satisfaction, and effective use of their technology.Why Should You Attend Understand the latest powerful and most relevant MS Office functions availableWork smarter, faster and more effectivelyBoost profit, efficiency, and productivityImprove job satisfaction, team performance, and professionalismGain a strong competitive advantage at peer and business levelAchieve more in less time with higher quality results Strengthen your resume and justification for increased salary