![]() Monitor cells and formulas by using the Watch Window Perform what-if analysis by using Goal Seek and Scenario Managerįorecast data by using the AND(), IF(), and NPER() functionsĬalculate financial data by using the PMT() function Summarize data from multiple ranges by using the Consolidate feature ![]() Reference date and time by using the NOW() and TODAY() functionsĬalculate dates by using the WEEKDAY() and WORKDAY() functions Look up data by using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions Perform logical operations by using nested functions including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR(), and NOT() functions Table of content Manage workbook options and settingsįill cells by using advanced Fill Series optionsĬalculate data by inserting subtotals and totalsĪpply advanced conditional formatting and filteringĬreate custom conditional formatting rulesĬreate conditional formatting rules that use formulas Candidates are expected to demonstrate the correct application of the principal features of Excel at an expert-level and complete tasks independently. The Expert workbook examples include custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules. The course covers the ability to customize Excel environments to meet project needs and to enhance productivity. MS Excel Expert® 2019 (Certified by Microsoft)Įarn official Microsoft Office Specialist (MOS) certification in Excel Expert to differentiate yourself in today's competitive job market.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |