Microsoft Excel has advanced tools to help you create spreadsheets to meet the needs of industry. With the skills gained in this course you will be able to customize and use advanced features such as PivotTables and PivotCharts in Microsoft Excel.
Upon successful completion of this course you will be able to use Microsoft Excel’s advanced functions such as VBAs (Visual Basic for Applications) and macros. You will be able to seamlessly write, combine, and audit advanced formulas and integrate advanced filtering to enhance the value and presentation of your worksheets. You will also be able to use What-If Analysis Tools, share workbooks, and customize the ribbon.
It is recommended that you complete CCTO240, Microsoft Excel Level ll, or have equivalent skills before enrolling in this course.