What you'll learn

·       Learn how to THINK like Excel, and write powerful and dynamic formulas from scratch

·       Automate, streamline, and completely revolutionize your workflow with Excel

·       Master unique tips, tools and case studies that you won't find in ANY other course in Myanmar

·       Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor, Ko Andrew

·       Get access to project files, quizzes, homework exercises

·       Build formulas to analyze dates, text fields, values and arrays

 

Requirements

·       Microsoft Excel 2007 - 2019 or Office 365 (Some features may not be available in earlier versions)

·       Experience with formulas is recommended, but not required (we'll review some of the fundamentals)

We'll dive into a broad range of Excel formulas & functions, including:

 

·       Lookup/Reference functions

 

·       Statistical functions

 

·       Formula based formatting

 

·       Date & Time functions

 

·       Logical operators

 

·       Array formulas

 

·       Text functions

 

·       Powerful analytics tools and formulas like INDIRECT, HYPERLINK, WEBSERVICE & FILTERXML