Excel 2016 – Formulas & Functions

Overview What does the course cover? Excel 2016 Formulas and Functions provide a powerful way to carry out calculations on vast amounts of Data. You’ll learn in detail how basic operators and functions work, the different types of functions available and their uses. This course is vital to gaining the most from this powerful feature of Excel. Aims Why take this course? This course covers the use of the most frequently used Functions available in Excel, from the basic operators’ right through to advanced Lookups, Text and Date Functions and useful hints and tips. If you need to work with data in Excel and report on that data, chances are that you will need to carry out many formulae on the data to analyse it and report on it successfully. Audience Who would benefit? Anyone using Excel 2016, whether you are already using Formulae or not, this course will bring your right through from basic to advanced. Formulas and Functions provides a one stop shop for all frequently used Formulae in Excel and answers the questions that you will have on how they are created, how you can edit them and how they should be used. Course Preview Each course contains high quality, professional video lessons, downloadable exercise files and real-world templates for you to use. Simple interface Video lessons Downloadable content Course Details  Section 1: Basic Formula Lesson 1: Operators Lesson 2: Sum Lesson 3: Average Lesson 4: Max Lesson 5: Min Lesson 6: Count Functions Lesson 7: Round Lesson 8: Use of AutoSum Section 2: Defining and Auditing Formula Lesson 1: Absolute and Relative Referencing Lesson 2: Name Manager Lesson 3: Formula auditing Lesson 4: Watch Window Lesson 5: Calculation Options Section 3: If Statements Lesson 1: Simple IF Statement Lesson 2: Nested IF Statement Lesson 3: IF AND Statement Section 4: Lookup Functions Lesson 1: VLookup Same Sheet Lesson 2: VLookup involving 2 Sheets Lesson 3: VLookup involving 2 Workbooks Lesson 4: VLookup with closest match option Lesson 5: HLookup Lesson 6: Comparing 2 Columns Section 5: More Functions Lesson 1: Quick Analysis Tool Lesson 2: Countif & Sumif Lesson 3: Sumifs & Countifs Lesson 4: Date Functions Lesson 5: Database Functions Lesson 6: Text Functions Lesson 7: Indirect Function Lesson 8: 3D References Skills You’ll Learn What you’ll be able to do after the course Work with large data volume Understand IF Statements Define and audit formula Build and use advanced formulas Work with Lookup functions throughout workbooks Use advanced statistical functions Complete complex calculations How You Can Apply These Skills What you’ll be able to use these skills for Build powerful and reliable spreadsheets Write financial formulas such as loan formula Carry out data analysis and forecast trends Develop complex models or algorythm Save time by automatising calculations Create employee timesheets Set up and follow budgets Certification When you pass you will receive an internationally recognized accreditation certificate like this: What’s next? If you would like to learn more about Excel 2016, Pivot Tables, Macros and Charts courses might also be of interest. Careers that require these skills at this level? Excel is used in practically every business and in nearly all departments in those businesses – ranging from sales to accounting and administration. Any finance role will require you to be proficient to this level. Want to start learning today? Joining is simple, easy and risk free with our 7 day money back guarantee. Start Trial