
Explore common math functions in Excel, from absolute values and rounding to logarithms and exponential values, accessed via the formulas ribbon and the more functions dropdown's engineering group.
Explore the ln and exp functions in Excel, including natural log base e, log base 10, domain limits, inverses, and examples of exponential growth and very large values.
Learn how RAND and RANDBETWEEN generate random numbers for simulations in Excel, including decimal values and integers within specified ranges, and how to freeze results by copying as values.
Learn to clean data in Excel with trim to remove leading and trailing spaces and value to convert text to numbers, saving hours on large datasets.
Explore flash fill in Excel 2013 to quickly parse names, numbers, and dates using pattern recognition, with left-to-right methods and keyboard shortcuts, while noting its limitations.
Use today and now to access current date and time, format now for time-only display, and subtract dates to compute days since birthdate.
Explore the datedif function in Excel 2013 for calculating the number of days, months, or years between two dates, despite it not being an official Excel function.
Use the Date function to create dates from year, month, and day, format serial values as dates, and use DateValue to convert legacy labels into dates.
Compute workdays and next start dates for projects using networkdays and workday, excluding weekends and holidays. Learn practical examples and note the Excel 2010 international versions that extend holiday options.
Explore how correlation and covariance reveal relationships between variables. Interpret a correlation matrix, including diagonal ones, compare sample and population covariance, and use Excel 2010 functions.
Explore how the rank, large, and small functions rank observations in ascending or descending order, and identify the five largest or smallest values, including handling ties.
Master the offset function in Excel to return a single-cell reference offset from a start cell using arguments for row and column offsets; formulas update automatically if delays change.
Master range names in Excel 2013, including absolute references and applying names to formulas for revenue based on units sold and unit price, and grasp scope with Name Manager.
This course takes up where the Excel 2013 Fundamentals course leaves off. It covers a wide variety of Excel topics, ranging from intermediate to advanced level. You will learn a wide variety of Excel functions, tips for creating readable and correct formulas, a number of useful data analysis tools, how to import external data into Excel, and tools for making your spreadsheets more professional. To learn Excel quickly and effectively, download the companion exercise files so you can follow along with the instructor by performing the same actions he is showing you on the videos.
***** THE MOST RELEVANT CONTENT TO GET YOU UP TO SPEED *****
***** CLEAR AND CRISP VIDEO RESOLUTION *****
***** COURSE UPDATED: February 2016 *****
“As an Accountant, learning the Microsoft Office Suite really helps me out. All of the accounting firms out there, whether Big 4 or mid-market, want their employees to be well-versed in Excel. By taking these courses, I become a stronger candidate for hire for these companies." - Robert, ACCOUNTANT
There are two questions you need to ask yourself before learning Excel. 1. Why should you learn Excel in the first place? 2. What is the best way to learn?
The answer for the first question is simple. Over 90% of businesses today and 100% of colleges use Excel. If you do not know Excel you will be at a distinct disadvantage. Whether you're a teacher, student, small business owner, scientist, homemaker, or big data analyst you will need to know Excel to meet the bare minimum requirements of being a knowledge worker in today's economy. But you should also learn Excel because it will simplify your work and personal life and save you tons of time which you can use towards other activities. After you learn the ropes, Excel actually is a fun application to use.
The answer to the second question is you learn by doing. Simple as that. Learn only that which you need to know to very quickly get up the learning curve and performing at work or school. Our course is designed to help you do just that. There is no fluff content and the course is packed with bite-sized videos and downloadable course files (Excel workbooks) in which you'll follow along with the instructor (learn by doing).
If you want to learn Excel quickly, land that job, do well in school, further your professional development, save tons of hours every year, and learn Excel in the quickest and simplest manner then this course is for you!
You'll have lifetime online access to watch the videos whenever you like, and there's a Q&A forum right here on Udemy where you can post questions.
We are so confident that you will get tremendous value from this course. Take it for the full 30 days and see how your work life changes for the better. If you're not 100% satisfied, we will gladly refund the full purchase amount!
Take action now to take yourself to the next level of professional development. Click on the TAKE THIS COURSE button, located on the top right corner of the page, NOW…every moment you delay you are delaying that next step up in your career…