Upon successful completion of this course, students will be able to:
Streamline the WorkFlow: create and edit macros; apply conditional formatting, add data validation criteria, update a workbook’s properties, modify Excel’s default settings;
Collaborate with others using workbooks: protect files, share workbooks, merge workbooks, adjust macro settings, administer digital signatures;
Audit worksheets: locate errors in formulas, locate invalid data and formulas, trace cell precedents and cell dependents, group and outline data;
Analyze data: create a trendline, perform What-if analysis, develop a PivotTable Report, develop a PivotChart Report;
Work with multiple workbooks: create a workspace, consolidate data, link cells in different workbooks, edit links;
Import and export data: export to MS Word, import a Word table, import text files.