COURSE DESCRIPTION
The old 80/20 rule for software—that 80% of a program’s users
use only 20% of a program’s features—doesn’t apply to Microsoft Excel.
Instead, this program probably operates under what could be called the
95/5 rule: Ninety-five percent of Excel users use a mere 5% of the program’s power!
On the other hand, most people know that they could be getting
more out of Excel if they could only get a leg up on building formulas
and using functions. Unfortunately, this side of Excel appears complex
and intimidating to the uninitiated, shrouded as it is in the mysteries
of mathematics, finance, and impenetrable spreadsheet jargon.
Here's the good news!
I have designed this practical course to give you the ability to master the Top
25 Microsoft Excel formulas with real world examples, by demystifying
the building of worksheet formulas, and presenting the most useful Excel
functions in an accessible and jargon-free manner. In this tutorial, you will be able to learn important functions such as:
- Financial
- Logical
- Text
- Lookup & Reference, and many more
I have included few bonus tutorials at the end of the course as well:
- Modifying templates and styles
- Copying macros between workbooks
- Working with external data
- Tracking changes in Excel 2013
The entire objective of this course is to dive deep into the
Excel 2013 environment with regards to formulas in in order to make you more productive, efficient, and achieve a greater skillset!
To
top it off: If you would like me to explain a particular formula of
your choice, I would be delighted to create a hands-on tutorial - just
for you!
With that said, this course will enhance your comfort level working with advanced formulas in Excel 2013. The concepts learned in this course apply to Excel 2007 and 2010 versions of Microsoft Excel as well. So, enroll now and take your skills to the next level.
CURRICULUM
AND and IF Functions
Bonus Section
Copying Macros Between Workbooks
Course Conclusion
Course Conclusion
Course Introduction
Depreciation Lecture
Exploring Tracking Changes Feature
Financial Functions
HLOOKUP-INDEX-MATCH Functions
IFERROR and XOR Functions
Introduction and About the Instructor
Logical Functions
Lookup & Reference Function
LOOKUP Function Lecture
Modifying Existing Templates
PMT-PMT-PRICE-YIELD Functions
PRICE-COUPONDAYS-ACCRINT-ACCRINTM
PROPER-UPPER-LOWER-SUBSTITUTE Functions
PV and FV Functions
SLN-SYD-DB-DDB-VDB Functions
TEXT and CONCATENATE Functions
Text Functions
What will I Learn?
Working with Advanced VLOOKUP
Working with External Data Sources
LINK FOR THE FREE COURSE
100% Off, Udemy 100% Off, Udemy Coupon, Udemy Coupon Code, Udemy course, Udemy course download, Udemy course reviews, Udemy courses, Udemy courses for free, Udemy courses free, Udemy courses free download, Udemy discount, Udemy download, Udemy education, Udemy free, Udemy free course, Udemy free courses, Udemy free online courses, Udemy online, Udemy online course, Udemy online courses, Udemy online courses review, Udemy reviews, Udemy tutorial, Udemy tutorials, Udemy.com free courses,
