Build a bridge to better Excel skills. Learn advanced date, text and logical functions, with pivot tables and charts
Master key concepts and practical skills through structured learning modules. By completing this curriculum, you'll gain valuable expertise applicable to real-world scenarios.
Clean / Scrub large data sets with many different types of Excel functions
Import text files into Excel, both delimited and fixed width files.
Work with text strings, to parse data, format text strings, clean/trim text data, join/concatenate text strings, and split text into columns.
Make Excel dates from text strings and values; calculate duration (like net work days), parse dates, and work with international dates
Build complex logical expressions with IF, AND, OR
This comprehensive Excel: Learn 47 Functions via a Business Services Case Study curriculum is designed to take you from foundational concepts to advanced implementation. Each module builds upon the previous, ensuring a structured learning path that maximizes knowledge retention and practical application.
Understand what you need to succeed in this course and determine if it's the right fit for your learning goals
What you need before starting this Excel: Learn 47 Functions via a Business Services Case Study course:
This course is perfect for:
Everything you need to know about this online course, from duration to certification
Course Instructor
Jeff Knowlton
Expert instructor with industry experience
Course Language
English
All materials in English
This online course offers comprehensive training with expert instruction, practical exercises, and a certificate of completion. Join thousands of students advancing their careers through quality online education.
View Current Pricing
Check provider for latest offers
Pricing may vary. Check the course provider for current promotions and exact pricing.
Excel: Learn 47 Functions via a Business Services Case Study isn't for you? Don't worry, explore these courses and advance your skills or learn something totally new.
