Advanced Excel Training Course: Learn Excel with Problems
3.4 (5 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,032 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Advanced Excel Training Course: Learn Excel with Problems to your Wishlist.

Add to Wishlist

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.4 (5 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,032 students enrolled
Created by Kawser Ahmed
Last updated 5/2016
English
Current price: $10 Original price: $40 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 42 mins on-demand video
  • 2 Articles
  • 7 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
Requirements
  • Determination and dedication for learning this course from start to end.
  • Microsoft Excel 2013 Office Suite installed in a Computer.
  • An internet connection.
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.

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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Welcome to the Course! Be a Professional Excel User with this course!
4 Lectures 12:47

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.
Preview 02:24

  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.
List of sites where you can practice Excel problems
00:45

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.
Preview 06:58

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

How to Review this Course and Obtain Your Certificate of Completion
02:40
+
Creating Formulas that Manipulate Text
7 Lectures 29:43
  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.
Finding and Searching within a Text
06:02

  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.
Preview 02:57

  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.
Counting the Occurrences of a Substring in a Cell
02:26

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

Extracting the First and Last Words of a String
06:13

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

Extracting All but the First Word from a Text or String
02:41

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.

Separating the First Names, Middle Names, and Last names from the Full Names
04:44

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.

Preview 04:40

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.

Creating Formulas that Manipulate Text
3 questions
+
Learn More: A Special Offer!
1 Lecture 00:55

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.

Bonus Lecture: A Special Offer for You!
00:55
About the Instructor
Kawser Ahmed
4.4 Average rating
1,299 Reviews
36,675 Students
11 Courses
Founder ExcelDemy.com | 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!