Excel Crashcourse Intermediate & Advanced
What you'll learn
- solve nearly all problems
Requirements
- Excel 2007 / 2010 / 2013
Description
MS Excel is a "must have" skill in most of computer related working environments today. Even if you don't think it is relevant for you, I promise after finishing the course you will realize the opportunities MS Excel has to offer to you. If you aspire a job in the finance industry, as an accountant, or you would like to become an entrepreneur, the course will be helpful to achieve your goals. Consider the course as an important tool to support you in your career. The course is for people who already have at least basic understanding of MS Excel. We will learn how to work with different functions to alleviate all kinds of daily tasks. You will be able to download the spreadsheet. After finishing this course, you will have mastered the advanced features and functions of Excel.
Here I use Microsoft Excel 2010 but you can also use 2007 or 2013. There are not too many differences between the versions!
Who this course is for:
- everyone who has a least worked with basic excel before
Course content
- Preview03:30
- Preview01:14
- Preview04:31
- 01:29sumif function
- 02:45sumifs function
- 02:05countif function
- 02:07countifs function
- Preview02:26
- Preview01:09
- 02:09vlookup approximative match
- 01:31match function
- 01:09choose function
- 05:13vlookup with more tables
- 01:36hlookup function
- 03:02index and match function
- 03:55days and time functions
- 04:59sumproduct function
- 02:40array functions
- 04:49Pivottables and Slicer
- 03:56conditional formating
- 02:26Alternatives to dropdown lists - buttons
Instructor
![Dan We](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 10,144 Reviews
- 42,883 Students
- 51 Courses
Dan is a 31 year old entrepreneur ,data scientist and data analytics / visual analytics consultant. He holds a master degree and is certified in Power BI as well as a Qualified Associate in Tableau software. He is currently working in Business Intelligence field and helps major companies to get key insights from their data to deliver long term growth and outpace their competitors.
He is committed to support other people by offering them educational services to help them accomplishing their goals and becoming the best in their profession or explore a new career path.
"Helping others is the greatest joy"
"In order to do the impossible you need to see the invisible"
"If you don't like where you are then change. Life is too short!"
You can do it!