Hack Productivity with List Excel Functions and Useful Tips
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
-
Start6.1 What will we learn in this section (4:08)
-
Start6.2 How to filter items in a list (8:24)
-
Start6.3 Sorting List without messing up the data (10:09)
-
Start6.4 How to freeze rows or columns (9:53)
-
Start6.5 Remove duplicates from a list (6:51)
-
Start6.6 Section Summary (6:32)
-
Start06 Source Files
-
Start7.1 What will we learn in this section (2:09)
-
Start7.2 COUNT, COUNTA and COUNTIF Functions (11:57)
-
Start7.3 Create a drop down list (11:38)
-
Start7.4 Work with ISNUMBER and SEARCH functions within text functions (11:18)
-
Start7.5 Format row based on a cell value (10:54)
-
Start7.6 Create an invoice template in Excel (24:17)
-
Start7.7 Section Summary (4:46)
-
Start07 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!