Excel Formulas Made Easy – Learn more than 100 Formulas

Learn Excel formulas with this comprehensive course taking you from the fundamentals to writing advanced formulas

Created by: Alan Murray
Microsoft MVP, Founder of Computergaga

What Will I Learn?

• Write advanced formulas for summing and counting values in a list.
• Use lookup functions to fetch values on a spreadsheet.
• Perform calculations with dates and times
• Use formulas to clean and prepare data for analysis.
• Identify and solve formula errors

Requirements

• Only a basic use of Excel is required as this course starts from scratch in understanding and creating formulas in Excel.
• Excel 2013 is used on the course, but the lessons apply to any version of Excel. When a formula is new to a specific version of Excel this will be stated.

Target audience

• Newbies to formulas in Excel who need to learn the formulas on their spreadsheets.
• Excel users who can write formulas but want to take their skills further and learn some advanced Excel formula techniques.