First Steps to Advanced Excel

Improving your Excel knowedge; functions, formulas, macro and VBA. Become an Advanced Excel user!
4.4 (19 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,729 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 28
  • Length 1.5 hours
  • Skill Level All Levels
  • 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

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

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

About This Course

Published 3/2016 English

Course Description

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.



What are the requirements?

  • 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

What am I going to get from this course?

  • 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

What 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

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.

Curriculum

Section 1: Intorduction to First Steps to Advanced Excel
Introduction
Preview
03:29
Section 2: Functions of Excel (Useful but less known)
02:11

Very beginning pop up window. Update in the Beginning

03:00

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

02:59

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

02:05

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

01:35

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

02:49

Highlight cells that match the criterias.

Conclusion Section 1
1 page
4 questions

Function quiz to test yourself

Section 3: Most commonly used formulas in excel
01:43

Mentality of Excel. Combining Formulas in use

02:35

Main Search and Reference formula in Excel.

03:01

Altenative Search and Reference formula. Collaboration of two formulas.

02:32

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

02:12

Unify Columns, making just one criteria

03:13

Sum up the matched criterias

01:31

Error Finder Formulas

Conclusion Section 2
00:05
4 questions

Formula quiz to test yourself

Section 4: MACRO for beginners
03:48

Make your excel ready for macros

03:27

Excel Translator from English to Visual Basic

01:18

Easy way to run macros

02:17

First steps to VBA

Conclusion Section 4
00:05
3 questions

MACRO quiz to test yourself

Section 5: VBA in Action
02:26

Some definitions and necessities of VBA script

07:24

First VBA clauses, moving betwwen cells via OFFSET

08:29

Two essential loops: For Next - If Then Else

07:53

Message Box - Userforms

06:40

Screen Update - Password Protection

Conclusion Section 5
00:10
4 questions

VBA in Action quiz to test yourself.

Section 6: Conclusion of the Course
00:10

End of the Course and Feedbacks

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Emre Volkan Gülen, 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.


Ready to start learning?
Take This Course