Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Dive into advanced Excel techniques with this comprehensive tutorial designed for power users seeking to elevate their skills beyond typical tools and processes. Learn to intermix Excel functions for efficient problem-solving, develop a deeper understanding of data mining tools like VLOOKUP, and master advanced solutions such as INDEX, MATCH, and OFFSET functions. Explore dynamic range charts, pivot table enhancements, web data importing, and macro creation. Discover how to expedite data analysis through dynamic ranges and push Excel to its limits with new perspectives on tackling challenging problems. Gain hands-on experience in creating dynamic named ranges, using calculated fields and items, grouping pivot items, and editing VBA code. Perfect for those who have completed basic Excel training and are ready to take their skills to the next level.
