Advanced Excel Training Course: Learn Excel with Problems

Every Week 3-5 Excel Problems, Video Solutions, Learn Excel Functions, Excel Projects on Template & Dashboard Design.
3.9 (7 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,028 students enrolled
Take This Course
  • Lectures 12
  • Length 43 mins
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2015 English

Course Description

Teaching 11 Courses on Excel and Data Analysis!

OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!

Course Updated:  Nov 01. 2016

Do you want to achieve transformational knowledge in Excel? Want to recognize yourself a professional level Excel user? Then you have to solve Excel problems regularly. There is no other way, believe me. This is the course I have designed to solve your day to day problems and others will learn from your problems.

DO NOT WASTE YOUR TIME and MONEY! Enroll into this most comprehensive Microsoft Excel 2013 training course.

The satisfaction with this course is guaranteed.

  • 30 Days FULL REFUND of your money is guaranteed if you are not satisfied with this course. If you really want to be a Pro user of Excel, just take this course. Nothing to lose. If you don't like the course, you will get FULL REFUND.
  • You will get LIFETIME ACCESS to this course. So, you will be able to re-take this course for unlimited times.


In this course, we shall solve problems in almost all the problems except the VBA problems. I am mentioning some of the Excel categories here:

  • Excel environment.
  • Manage Excel workbook and worksheets
  • Enter and Edit data in a worksheet.
  • Excel cells and ranges.
  • Essential workbook and worksheet operations.
  • Excel tables and structured references.
  • Formatting worksheets.
  • Advanced features related to Excel files.
  • Excel templates.
  • Setup and print Excel worksheets.
  • Functions and formulas.
  • Mathematical functions.
  • Excel charts.
  • Conditional formatting.
  • Excel security.
  • Graphic Objects.
  • Data validation techniques in Excel.
  • Excel as a database.
  • Excel Pivot Tables
  • What if analysis
  • Goal seek and Excel Solver


By Enrolling into this course:

  • You will learn Microsoft Excel with practical examples and case studies.
  • You will master all the Excel keyboard shortcuts one by one.
  • You will master good command over the Excel functions and formulas.
  • You will solve Excel problems with great efficiency.
  • You will get your Excel problems solved by the instructor.
  • You will get support from the instructor within 24 hours!
  • You will get 220+ Excel Keyboard Shortcuts PDF, 102 Excel functions cheat sheet.

...want more? JOIN THE COURSE. Your any suggestion will be highly appreciated to make it the best Excel related course.


About the instructor of this course:

The instructor of this course has extensive experiences in Excel, Excel VBA and .NET frameworks:

  • The author of this course has a Computer Science and Engineering degree from the topmost university in his country.
  • He is a dedicated full-time Excel, Excel VBA and Business Analytic blogger.
  • He has a teaching experience of 18 years.
  • He learns new things in Excel, Excel VBA and Business Analytic regularly and shares free tutorial on his blog.
  • As a full-time Excel, Excel VBA and Business Analytic blogger, he will be here or on his blog with your every problem.
  • As a consultant in many Excel projects, he has vast knowledge on real-life Excel problems.

So, learn Excel from someone who loves Excel and Excel VBA, who lives with Excel and Excel VBA 365 days a year, who learns new things in Excel regularly, who runs a blog on Excel and who loves teaching. You need a full-time instructor, not an instructor who just creates a course and then flies away.

What are the requirements?

  • Determination and dedication for learning this course from start to end.
  • Microsoft Excel 2013 Office Suite installed in a Computer.
  • An internet connection.

What am I going to get from this course?

  • You will learn Excel from the Scratch to Advanced Level to use it in your day to day job.
  • This is not just a course. This is a long term learning process with problem solving approach.
  • You will get solved your Excel related problems with the instructors.
  • Other students will learn from your problems.

Who is the target audience?

  • This is an intermediate level course. As without a prior knowledge in Excel, you can cope with the real life Excel problems.
  • This course is not for students who think they can learn Excel without practicing.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Welcome to the Course! Be a Professional Excel User with this course!

What you will get from this Excel lecture:

  1. You will be welcomed to the course. The instructor of this course is thankful to you that you have enrolled into this course.
  2. You will know which versions of Microsoft Excel has been used to create this course. You will also get idea which versions you can use to follow this course.
  3. You will have an idea how to use this course to get the best from it.
  1. You will get a list of websites where you can solve Excel related real life problems. If you cannot solve a problem, follow how other experts in the community solve that problem.
  2. Learn from trying to solve an Excel problem or learn from others who solve problems.

This video is actually about UDEMY platform. You will lea

  1. How to enter the course.
  2. How to use the platform to best view the course.
  3. There are several options in the platform. Without knowing them in details, you cannot expect to best use of the course.

In this video, you will see how you can get the certificate of your completion of the course.

Section 2: Creating Formulas that Manipulate Text
  1. In this Excel training video, you will learn how you can search and find one or more characters within a text or string.
  2. To do that, we have used two Excel functions: SEARCH(...) and FIND(...).
  3. These two functions finds out the position of a text or character within another text.
  4. Their functionality is almost same but SEARCH(...) function is not case sensitive and FIND(...) function is case sensitive.
  1. In this Excel training video, you will learn how to count a specific character within a text or string.
  2. To do that I have used SUBSTITUTE(...) and LEN(...) functions.
  3. SUBSTITUTE(...) function substitutes a text with a new text.
  1. In this Excel training video, you will learn to count the occurrences of a sub-string within a text.
  2. Like the previous lecture, we have used both SUBSTITUTE(...) and LEN(...) functions.

In this video, you will learn how to extract the first and last words from a text string.


In this Excel training video, you will learn how to extract all but the first string from a text or a string.


This video is very important for an Excel user. In this video, you will learn how to separate the first name, the middle name and the last name from a name.

If you deal with text regularly in your Excel use, this technique might help you a lot.


When you will need to count the total number of words in an Excel cell, this video will help you a lot. In this video lecture, you will learn how to count the total number of words of a text.

In this video, I have used TRIM(...) function to remove the extra and unnecessary spaces from a text string.

3 questions

Using text manipulation using Excel formulas is not that easy. In this section, I have used several Excel functions to manipulate text. Time to time, I will add more lectures to this section. Take part in the quizzes. It will help you to apply right functions in right places. Except doing some practicing, you cannot expect to grab the concept of a topic fully.

Section 3: Learn More: A Special Offer!

Want to get in-depth knowledge in Data Analysis using Excel? Join my Data Analysis in Excel with Statistics: Get Meanings of Data course for 50% Off.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Kawser Ahmed, Founder | Data Analyst

Love to see you here!

I am Kawser Ahmed, father of two beautiful angels (Marissa and Arissa), a full-time data analysis blogger (using Excel & other tools), corporate Excel trainer, & entrepreneur.

I love to make courses in the combination of both theory and practice.

Monthly 30,000 Excel users visit my Excel blog ExcelDemy (follow the website link in the profile).

I love to learn and teach (teaching from my eighteen)!

Visit my blog!

You will find plenty of useful posts, articles, video tutorials, and important Excel resources.

What I love most is: add some value to people around me, believe me!

Here are some of my working areas:

  • 1. Corporate Budgeting, Planning & Forecasting
  • 2. Mission-critical financial processes
  • 3. Month-end close processes
  • 4. Big Data Analysis using Excel
  • 5. Company Reports (Sales, Marketing, Administrative)
  • 6. Large Projects using Excel VBA
  • 7. Dashboard Design using Excel
  • 8. And Basic Accounting

I am always around you to help and support! 

Just knock me!

Ready to start learning?
Take This Course