Tables are one of the main components of MS Excel. Microsoft Excel Advanced Training Chapter #10: Tables Connecting Micrsoft Excel to Access Databasesīesides, you will learn Get and Transform feature of MS Excel.You can fetch data from other resources to Microsoft Excel and use these data in calculations and functions. Microsoft Excel Advanced Course Chapter #9: Connecting to External Data You will learn how to use statistical functions in MS Excel. Functions are more efficient than formulas when you are applying a mathematical process to a group of cells. ![]() For example, the SUM function is used to add the values contained in a range of cells. Statistical functions apply a mathematical process to a group of cells in a worksheet. ![]() Microsoft Excel Advanced Course Chapter #8: Statistical Functions Besides, you will see Personal Financial Functions and Professional Financial Functionsfinancial functions in Microsoft Excel. You will learn the financial functions and terminology. The excel financial functions have been made available to execute a variety of financial calculations, including calculations of yield, investment valuations, interest rates, internal rate of return, asset depreciation, and payments. Microsoft Excel Advanced Course Chapter #7: Financial Functions You will learn HLOOKUP and VLOOKUP functions. LOOKUP's default behavior makes it useful for solving certain problems in Excel. Lookup function performs an approximate match lookup in a one-column or one-row range, and returns the corresponding value from another one-column or one-row range. Microsoft Excel Advanced Course Chapter #6: Lookup Functions You will learn how to use logical functions. ![]() Microsoft Excel Advanced Course Chapter #5: Logical Functions You will learn how to use text functions in MS Excel. Microsoft Excel Advanced Course Chapter #4: Text Functions There will be a further lecture describing complex date and time functions as well. You will be learning basic date and time functions. You will see how date and time works in Microsoft Excel. Microsoft Excel Advanced Course Chapter #3: Date and Time Functions
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |