Course Introduction and Logical Functions
Text Functions
Financial Functions
Bonus Selection
Microsoft Excel organizes your data and saves you time by using its built-in functions to make calculations and create charts and graphs. This free online Excel course provides a hands-on tutorial on how to use twenty-five advanced functions in the following categories: logical, functional, text, lookup and reference. What are the ‘logical’ functions in Excel? What Excel functions are used in accounting? What is the use of the ‘lookup’ function? Our step-by-step explanation will introduce you to each function and its arguments and syntax as we explain how and where to use each formula. This course demonstrates the role of ‘logical’ functions in decision-making, whether you’re comparing marks scored by students or deciding who gets a sales bonus.
We then move on to some key financial functions that can execute a variety of calculations and are commonly used in business and even in our personal lives and these functions are taught step-by-step. The second module of the course begins with the explanation of the ‘text’ and ‘concatenation’ functions. How do you use the ‘text’ functions in Excel? Is it possible to join the text of two or more cells in Excel? Working with arrays of data can be time-consuming and make one prone to mistakes, and the content on ‘lookup’ and ‘reference’ functions will teach you how to use ‘vlookup’ and ‘hlookup’ to automatically perform tasks to save time and avoid errors. It also provides practical training on how to meaningfully compare rows and columns in a spreadsheet.
This Excel tutorial helps you to track changes in Excel while you modify templates, macros and external data sources. We take you through the general features of Excel to add advanced skills skill-set as Excel skills are highly valued in any environment where you are working with large data sets. Spreadsheets are a staple tool of many fields, from business to education and science and beyond, and improving your Excel skills by enrolling in this Top 25 Excel Formulas course can launch your career to new heights.
What Will I Learn?
AND and IF Functions
IFERROR and XOR Functions
PV and FV Functions
PMT–PPMT–PRICE–YIELD Functions
PRICE–COUPONDAYS–ACCRINTM Functions
Depreciation Lecture
SLN–SYD–DB–DDB–VDB Functions
Lesson Summary
PROPER-UPPER-LOWER-SUBSTITUTE Functions
LOOKUP Functions Lecture
Working With Advanced VLOOKUP
HLOOKUP–INDEX–MATCH Functions
Modifying Existing Templates
Copying Macros Between Workbooks
Working With External Data Sources
Exploring Tracking Changes Feature
Course Conclusion
Lesson Summary
0 Reviews
Teach Academy eLearning provides corporate, government and education sectors with proven on-demand training for employees. The company was founded in 2015 and has had more than 1.3 million students taking their courses. Teach Academy eLearning is a name you can trust for workforce training. The company specialises in video-based technology training content. The goal has always been to engage learners through an immersive, hands-on learning approach. Teach Academy prides itself on releasing titles on the cutting edge of technology. The subject matter experts are deeply involved in the subjects they teach, so the courses go into great depth and provide learners with the skills they need to implement real-world solutions with a given technology. The courses offered by Teach Academy vary from data analytics, software development and marketing to productivity in meetings and data visualisation.
Send this course as a gift to your friends
