I have just launched The Ultimate Excel Formula Course 2019 on Udemy and you have a chance to grab a FREE Review Coupon.
Course access includes files, quizzes & activities, articles for handy reference, LIFETIME access and a 100% money-back guarantee
Hands on, reinforced learning to ensure you Master Excel Formulas
Becoming a master of Excel means you have to master both simple and complex formula. This course is designed to ensure you achieve your true potential when using Excel.
With Over 90 functions and formulas covered, this course will take you through the basic formulas and build on this knowledge to more advanced and master level formulas.
By the end of this course you will be able to:
· Explain logical operators.
· Develop logical formula
· Create IF statements
· Carry out Simple and Dynamic Lookups
· Carry out complex Lookups
· Use Relative and Absolute Cell References
· Work with Rounding in Excel
· Extract text from text strings
· Clean text strings
· Carry out date and time math
· Set custom formatting for date, time and use in labels
· Set up data validation
· Create error resisting formulas
· Carry out financial calculations such as future value and net present value
· Calculate payments on a loan from both the borrower and lender view
· Work with tables, filters and advanced filters
· Carry out 1 and 2 variable analysis
· Use Scenario Manager and Goal Seek
· Understand and User Reference functions
· Set up and Use static named ranges
· Set up and use dynamic named ranges
· Explain a UDF
· Set up and work with pivot tables
Much Much More............
How this course differs:
This course contains video tutorials as you would tend to find on Udemy. However to re-in-force learning this course also contains many many articles. Some of these articles repeat stuff from the videos, some of them contains new stuff. Its easy to watch a video, but if you really want to learn, then re-in-force the learning with reading activity will ensure you get the most out of this course. Many of the the articles also contain gifs for ease of understanding.
In addition to the articles and video, there are also many activities for you to complete. So by watch the video, reading the articles and carrying out the activity, you should master excel formula in no time.
Interesting in a FREE review coupon to celebrate the launch? All I ask in return is that you leave an honest review and feedback on Udemy about the course
Grab your review coupon while you can - It is limited to the first 15