Buying for a Team? Gift This Course
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.3 (13 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,737 students enrolled
Last updated 3/2016
English
$10 $20 50% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 29 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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.



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
Students Who Viewed This Course Also Viewed
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
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
Curriculum For This Course
Expand All 28 Lectures Collapse All 28 Lectures 01:20:07
+
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
03:00

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

Cell Value Restriction
02:59

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

Advanced Filter
02:05

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

Cleaning the Complete List
01:35

Highlight cells that match the criterias.

Conditional Formatting
02:49

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

If(and
01:43

Main Search and Reference formula in Excel.

Vlookup
02:35

Altenative Search and Reference formula. Collaboration of two formulas.

Index Match
03:01

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

More complicated: 5 Formulas in a Row
02:32

Unify Columns, making just one criteria

Concatenate
02:12

Sum up the matched criterias

Sumproduct
03:13

Error Finder Formulas

Preview 01:31

Conclusion Section 2
00:05

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
03:48

Excel Translator from English to Visual Basic

Preview 03:27

Easy way to run macros

Macro Buttons
01:18

First steps to VBA

Visual Basic Editor
02:17

Conclusion Section 4
00:05

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
07:24

Two essential loops: For Next - If Then Else

VBA Loops
08:29

Message Box - Userforms

Displaying vba tasks
07:53

Screen Update - Password Protection

Security
06:40

Conclusion Section 5
00:10

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

Conclusion
00:10
About the Instructor
4.2 Average rating
18 Reviews
1,846 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.


Report Abuse