Intermediate/Advanced Microsoft Excel 2013

Description

Level 2 Primary focus is on using the analysis components within the application to budget and manage financial expenses. Attention is also devoted to summarizing large amounts of data rapidly, performing what-if analyses, and working problems back to find variables when a desired outcome or scenario is known. You will learn more advanced concepts such as working with data ranges, linking multiple workbooks and saving spreadsheets as Web pages. You will also learn to manage workbook data, use tables, analyze table data, automate worksheet tasks, enhance charts, share Excel files and incorporate Web information. Learn to analyze data with Pivot Tables, exchange data with other programs, customize Excel and advanced worksheet management, and program with Excel.