What you’ll learn
-
Learn how to THINK like Excel, and write powerful and dynamic Excel 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, guaranteed
-
Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor
-
Get LIFETIME access to project files, quizzes, homework exercises, and 1-on-1 expert support
-
Build Excel formulas to analyze dates, text fields, values and arrays
By the end of the course you’ll be writing robust, elegant formulas and functions from scratch, allowing you to:
- Easily build dynamic tools & Excel dashboards to filter, display and analyze your data
- Go rogue and design your own formula-based Excel formatting rules
- Join datasets from multiple sources with Excel’s LOOKUP, INDEX & MATCH functions
- Pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.)
- Manipulate dates, times, text, and arrays
- Automate tedious and time-consuming tasks using cell formulas and functions in Excel (no VBA required!)
- Lookup/Reference functions
- Statistical functions
- Formula-based formatting
- Date & Time functions
- Logical operators
- Array formulas &Text functions
Who this course is for:
- Excel users who have basic skills but want to get really, REALLY good
- Anyone hoping to expand their analytics skill set, work more efficiently with data, and take their career to a new level
- Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training
- Excel users looking to build strong analytical thinking and business intelligence skills
- Anyone looking to pursue a career in data analysis or business intelligence
Similar Course Coupons
- Microsoft Excel: Business Intelligence w/ Power Query & DAX
- Microsoft Excel – Data Visualization, Excel Charts & Graphs
- Microsoft Excel – Data Analysis with Excel Pivot Tables
Deal Score-1
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.