
Master a complete introduction to Microsoft Excel by learning all functions, including data and time, text, financial, informational, logical, and lookup, with practical examples.
Explore date and time functions in Excel, including date function to generate dates, the day function, and edate to add months, plus calculating differences in days, weeks, months, or years.
Explore date and time functions in Excel, including adding months with end-of-month results. Learn to extract week numbers, hours, minutes, and month values from dates.
Explore data and time functions in Excel, including networkdays and networkdaysint to count working days, and now, date, time, and second functions for dynamic timestamps.
Discover date and time functions in Excel, including today date, weekday, weeknum, workday, year, and yearfrac. See how to adjust for weekends and customize work weeks with practical examples.
Explore five financial functions in Excel to calculate interest and principal for securities and loans, and learn depreciation using a fixed declining balance method.
Explore how dollar function, effect function, future value function, and FV schedule function in Excel enable practical financial analysis and reporting.
Explore key financial functions in Excel, including RATE, PMT, IPMT, and IRR, with bond calculations, cash flows, settlements, maturities, and investments explained through practical examples.
Learn to use ipmt to calculate period interest with rate, nper, and pv, and mduration to compute security duration using settlement, maturity, coupon, yield, and frequency.
Explore five Excel financial functions, IRR (MIR), nominal rate, NPV, PMT, and SLN, through practical examples of initial investments and cash flows to assess feasibility and compare projects.
Show how to calculate loan payments using rate per period, periods, and present value, and apply SLN (straight-line depreciation) with cost, salvage, and life.
Explore Excel's informational functions, iserror, iseven, isformula, and isna, and learn how they test conditions and return true or false for errors, even numbers, formulas, and na errors.
Demonstrate five key logical functions in Excel, focusing on IF, AND, OR, and FALSE, and explain error handling with IFERROR and related error tests.
Explore lookups and references in Excel by mastering the areas, choose, column, and columns functions to select areas, return column numbers, and support dynamic calculations.
Explore four essential lookups and references formulas in Excel—formula text, hlookup, hyperlink, and index—through practical examples like displaying formulas, retrieving student scores, linking to web pages, and mapping runs.
Explore vlookup, match, and offset within lookups and references in Excel, using practical examples to retrieve names, ages, and incomes from tables.
Master the rows function to count selected rows in Excel, and review related lookups with match and offset as part 4 of lookups and references.
Explore mathematical Excel functions, including absolute value, Arabic numerals, base conversions, and rounding functions, with practical examples for handling negatives, Roman numerals, and numeric rounding.
Explore five Excel math functions: the selling and precise functions, the combine and combin functions for groups, the degree function for radians to degrees, and the even function for rounding.
Explore five Excel math functions, including ceiling, mode, round, mround, and pi. See practical examples that show rounding to multiples, computing remainders, and generating pi values.
Explore six essential math functions in Excel, including rand, rand between, round, round down, round up, and sqrt, with practical examples.
Apply subtotal, sum, and sumif to analyze datasets in Excel, choosing functions like average, max, and sum. See hands-on examples showing ranges, criteria, and sum ranges updating dynamically.
explains key statistical functions in Excel: average, averagea, and averageif, plus the binomial distribution, showing how booleans and text are handled and how to compute conditional averages.
Delve into essential Excel statistical functions, including countblank and countif, with dataset examples and covariance functions covar.p and covar.s to compare two data sets.
Explore the large, max, maxif, and median functions in Excel, learn their arguments—data range, max range, criteria range—and how to extract largest, highest, and median values.
Explore quartile and xy functions to find 25th, median, and 75th percentiles, use the slope function for x-y trends, and apply stdev to measure data dispersion.
Celebrate finishing the course with a comprehensive base of Excel functions across time, financial, informational, logical, lookup and references, math, and statistical categories, and practice building your own Excel apps.
If you want to improve your Excel skills, learn to use new functions or simply interested in becoming better in this amazing Microsoft APP then this course is for you. My name is Yassin Marco and I have been lucky enough to have the privilege to teach more than 250 000+ students in more than 190+ countries around the world. Since teaching is my passion, I decided to design this course to help people achieve there full potential with Microsoft Excel. This means that by the end of this course your Excel knowledge will have significantly grown. Indeed, this course teaches you how to properly work with more than 80+ Excel functions and formulas. Also all of those formulas are presented with clear Examples so you will be able to use them to create your own programs. Still not convinced, well not only you will receive a course and support for lifetime but if you are not satisfied you get your money back with no questions asked in the next 30 days.
So if you are looking for THE Excel course you will definitely not be disappointed by this one.
Finding the right Excel course can be really complicated, especially if you have almost no knowledge of this APP and want to learn all the basics. Indeed, whether you are looking to
- Understand the basics of Microsoft Excel
- Learn how to properly work with Microsoft Excel
- Get different Tips and Trick of this amazing Excel app
- Learn new functions and formulas and be able to use them every time that you work with Microsoft Excel
or any other given reason. The way this course have been designed will not only give a compete understanding of this Microsoft App but will also give a complete knowledge of more than 80+ Microsoft Excel functions and formulas. This is why this course is your best choice to learn this amazing App
The structure of the course
The way this course have been designed is here to help you learn all the basics of Microsoft Excel by practicing them. In other words, this course is divided into categories of functions and each categories will teach you different functions that can be used in a certain field. Each class of the course is strictly reserved in teaching new functions. Also, the way each function in presented will help you learn it much easily. Indeed, not only you will learn the theory around each function but you will also have the chance to practice it. In other words, in each class you will be able to use the function in different real life scenarios. Since there is a lot of practice this is the best way to learn something and be able to master it.
Also, not only you will master new skills, you will also have all the required knowledge to be able to perform different tasks and many fields such as finances, mathematics and statistics. Not only this but you will also be able to put everything you have learned together and use all the functions that you have learned to create your own advanced Excel apps.
For who is this course designed
This course can be very useful for new Excel users that are seeking ways to learn more about this app. Indeed, not only you will learn different ways to use Microsoft Excel with different formulas and functions but you will also have a complete understanding of more than 80+ Formulas. This means that it can be perfect for anyone trying to learn this app. Also, This course could be very good for people who already have experience with Microsoft Excel and who want to push there knowledge of this app a bit further. Indeed, the formulas teached in this course can be perfect for any experienced Excel user that want to learn new Excel functions/formulas and practice them.
Why should I take this course
This is definitely not the only Microsoft Excel course out there. But, this course is very unique. Indeed, there is almost no course that focus really on teaching you how to properly work with more than 80+ Formulas and functions. Not only you will have the theoretical side of each function/Formula but you will also learn how to use it with different Examples. In other words, each function is at first presented theoretically then you can practice it with different Examples that are given inside of the course ! This is exactly what makes this course so unique, no other courses will give you so much knowledge with practice in only a 5H course. Also, this course is frequently updated, this means that the information will be updated in the future months.
There is no risk involved in taking this course
This course comes with a 100% satisfaction guarantee, this means that if your are not happy with what you have learned, you have 30 days to get a complete refund with no questions asked. Also, if there is any concept that you find complicated or you are just not able to understand, you can directly contact me and it will be my pleasure to support you in your learning.
This means that you can either learn amazing skills that can be very useful in your professional or everyday life or you can simply try the course and if you don't like it for any reason ask for a refund.
You can't lose with this type of offer !!
This is why more than 15 000 students have already took the course !! Don't wait anymore
ENROL NOW and start learning today :)