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
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.
Easy way to find all special cells in all selected area. It may be one column or enire sheet.
Make the cell entries in an order withDropdown list, Vata Validation
Get the part of list that matches our criteria, without any change in the main list.
Second list without any duplicate. Again without any change in main list.
Highlight cells that match the criterias.
Function quiz to test yourself
Mentality of Excel. Combining Formulas in use
Main Search and Reference formula in Excel.
Altenative Search and Reference formula. Collaboration of two formulas.
It is possible to work with 5 formulas in one sentence. Vlookup Day Month Year Date
Unify Columns, making just one criteria
Sum up the matched criterias
Formula quiz to test yourself
Make your excel ready for macros
Easy way to run macros
First steps to VBA
MACRO quiz to test yourself
First VBA clauses, moving betwwen cells via OFFSET
Two essential loops: For Next - If Then Else
Message Box - Userforms
Screen Update - Password Protection
VBA in Action quiz to test yourself.
End of the Course and Feedbacks
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.