First Steps to Advanced Excel
4.2 (15 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,743 students enrolled
Wishlisted Wishlist

Please confirm that you want to add First Steps to Advanced Excel to your Wishlist.

Add to Wishlist

First Steps to Advanced Excel

Improving your Excel knowedge; functions, formulas, macro and VBA. Become an Advanced Excel user!
4.2 (15 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,743 students enrolled
Created by Emre Volkan GULEN
Last updated 3/2016
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • 29 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Be effective and fast Advanced Excel user
  • Write & combine formulas like SUMIFS, SUMPRODUCT, INDEX, MATCH, LOOKUP
  • Know how to renovate them, audit them and how to use which formula for specific cases
  • Give instructions to Excel to get things done by using MACROs
  • Get familiar with VBA & can write macros to automate tasks
  • Modify macros via Visual Basic
  • Know various features of Excel and use them productively
View Curriculum
  • You should already have Microsoft Excel (version does not matter). However, the newer the better, newer have more options. Also, 2003 has a completely different interface. I will use 2013 during the course.
  • Additionally, you should have basic skills of using Microsoft Excel

Learn and boost up your Excel skills to advanced level in functions, formulas, macros and VBA that will asist you for your all taks with numbers, with data.

Grow Your Competencies in Most Used Data Processing Software

  • Usage of Excel Toolbar Functions
  • Advanced Level Formulas
  • Building Macors
  • Creating, Modifying VBA

Expose Capabilities of Excel and Reveal Your Performance

Excel is the most used data processing software both in proffesional and academic life. Analyze the data and results lead us to make decisions more proper and beneficial. Fast and accurate analysis bring us right decisions in conditions.

Contents and Overview

This course contains 28 Lectures and 1,5 hours of content, most is secreencasting also presentations, and documents to study.

In Functions and Formulas Sections, you will learn how to use Excel skills better and other several ways to reach the result. Macro and VBA will give you totally a new ways to accomplish your tasks. More flexiable, reliable and automated.

This course is for intermediate excel users, who want to improve his knowledge to advanced level. Also, advanced users are welcome to refresh their minds. New Excelers can learn much about what Excel is possible to fulfill, and i am sure that this course will encourage them to learn and use Excel

You have some tasks which takes too much time, work load and possible errors, you will not to worry about those after this course.

Who is the target audience?
  • Users with a basic, intermediate knowledge of Excel and willing to be an advanced user
  • Also Advanced users may follow his course to refresh their minds
Compare to Other Excel Courses
Curriculum For This Course
28 Lectures
Intorduction to First Steps to Advanced Excel
1 Lecture 03:29
Functions of Excel (Useful but less known)
7 Lectures 14:39

Very beginning pop up window. Update in the Beginning

Preview 02:11

Easy way to find all special cells in all selected area. It may be one column or enire sheet.

Find the Special Cells

Make the cell entries in an order withDropdown list, Vata Validation

Cell Value Restriction

Get the part of list that matches our criteria, without any change in the main list.

Advanced Filter

Second list without any duplicate. Again without any change in main list.

Cleaning the Complete List

Highlight cells that match the criterias.

Conditional Formatting

Conclusion Section 1
1 page

Function quiz to test yourself

Quiz for Section 2
4 questions
Most commonly used formulas in excel
8 Lectures 16:52

Mentality of Excel. Combining Formulas in use


Main Search and Reference formula in Excel.


Altenative Search and Reference formula. Collaboration of two formulas.

Index Match

It is possible to work with 5 formulas in one sentence. Vlookup Day Month Year Date

More complicated: 5 Formulas in a Row

Unify Columns, making just one criteria


Sum up the matched criterias


Error Finder Formulas

Preview 01:31

Conclusion Section 2

Formula quiz to test yourself

Quiz for Section 3
4 questions
MACRO for beginners
5 Lectures 10:55

Make your excel ready for macros

Intro and What is the Logic of Macro

Excel Translator from English to Visual Basic

Preview 03:27

Easy way to run macros

Macro Buttons

First steps to VBA

Visual Basic Editor

Conclusion Section 4

MACRO quiz to test yourself

Quiz for Section 4
3 questions
VBA in Action
6 Lectures 33:02

Some definitions and necessities of VBA script

Preview 02:26

First VBA clauses, moving betwwen cells via OFFSET

Copy Paste in VBA & Offset Statement

Two essential loops: For Next - If Then Else

VBA Loops

Message Box - Userforms

Displaying vba tasks

Screen Update - Password Protection


Conclusion Section 5

VBA in Action quiz to test yourself.

Quiz for Section 5
4 questions
Conclusion of the Course
1 Lecture 00:10

End of the Course and Feedbacks

About the Instructor
Emre Volkan GULEN
4.2 Average rating
23 Reviews
1,975 Students
2 Courses
Data Analyst - Consultant

Hello, It's Emre! I'm from Istanbul, Turkey.

I am an Excel user since years at college. It made my course tasks easier and more convenient, and i worked a lot more Excel. When i worked more it makes more and more easier tasks. It contunied the same in my work life. As an auditor and data analyst taks resulted more fast and accurae way.

Additionally, macros and VBA are the most precious trasures of Excel. I would like to share this values with you. IT GROWS WHEN SHARED!

Of course, Excel is not just enough for Data Analyst, but Excel is the first step, first essential.