First Steps to Advanced Excel
3.4 (17 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,749 students enrolled

First Steps to Advanced Excel

Improving your Excel knowedge; functions, formulas, macro and VBA. Become an Advanced Excel user! (with Caption)
3.4 (17 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,749 students enrolled
Created by Emre Volkan GULEN
Last updated 3/2016
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 29 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
  • 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 this course is for:
  • 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
Course content
Expand all 28 lectures 01:20:03
+ 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