Build Date and Text Functions in Excel Spreadsheets
Accelerate your Excel skills by mastering advanced Excel functions.
Learn to master Excel functions in this all-in-one course.
Learn how to work with logic and lookup functions with hands on projects.
Work with math and finance functions, including forecasting.
Build a holiday date calculator as you learn date and time functions.
Work with key text and information functions to build hands on projects.
And much more!
A SCHOOL YOU CAN TRUST
- Lifetime access that never expires
- Project-based curriculum to superboost your portfolio
- Graduation certificate for every course
- Absolute beginner-friendly
- New courses every month
- Efficient lectures with step by step explanations
- Relevant industry topics 8 years of award-winning course delivery
- 1.3 million students in 186 countries
- Learn with free tools and affordable courses
Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. Build your own spreadsheets from scratch, and actually understand how they work! Concise, yet comprehensive and informative.
Course Curriculum
-
Start5.1 What will we learn in this section (3:46)
-
Start5.2 Split textual data apart (4:00)
-
Start5.3 Manipulate textual data (5:46)
-
Start5.4 Replace portions of textual data (4:42)
-
Start5.5 Put textual data back together with formulae (6:18)
-
Start5.6 Work with key informational functions (12:00)
-
Start5.7 Use the Hyperlink function to build navigational menus inside an Excel Worksheet (4:35)
-
Start5.8 Section Summary (6:26)
-
Start05 Source Files
Your Instructor
Hello all! My name is Mihai Petrisor, and I am honored to have the privilege of guiding you through Excel from beginner to advanced techniques. I would like to take a minute and give you a little bit of background about me, and how I became hooked on Excel.
I attended the Economics Studies Academy and earned a Masters in Investments. Having worked in Finance since 2007, I love figures and the dynamic environment of finance. I work daily with big data files, and Excel is my best friend.
Finance is the engine of each business, and Excel is the perfect tool to leverage a company's reports. I know you will find all the content in my courses useful. I will be happy to hear that you use what you learn in your day to day tasks.
I am truly a lifelong learner of all things techy. I look forward to serving all of you, and hope you get the Excel bug just like I did!