Microsoft Excel 2013 Training

Training Courses

Microsoft Excel 2013 VBA Training

In this Microsoft Excel 2013 VBA Training course, students will learn to use VBA in the Excel 2013 environment to create interactive worksheets and automate common worksheet tasks. More Details

Microsoft Excel 2013 Introduction Training

In this Microsoft Excel 2013 Introduction training course,students will learn the basics of entering and editing text, values, and formulas, and how to save workbooks in the native Excel format, as well as in other formats. They will learn how to move and copy data and formulas, how to determine absolute and relative references, and how to work with ranges, rows, and columns. Students will also learn how to use simple functions, and how to easily apply formatting techniques to worksheet data.More Details

Microsoft Excel 2013 Intermediate Training

In this Microsoft Excel 2013 Intermediate Training course, students will work with consolidating data, using advanced chart formatting options, sorting and filtering data, using special formatting options, using templates, using error tracing features, protecting worksheets and linking worksheets and workbooks.More Details

Microsoft Excel 2013 Advanced Training

In this Microsoft Excel 2013 Advanced training course, students will work with advanced functions and formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation, and will use advanced data filtering. They will apply advanced chart formatting options, and create more complex charts. They will work with PivotTables, PivotCharts PowerPivot, export and import data, and query external databases.More Details

Microsoft Excel 2013 PowerPivot Training

In this Microsoft Excel 2013 PowerPivot Training course, students will learn how to use PowerPivot to import and manipulate data, create PowerPivot reports, use DAX functions, create key performance indicators (KPI) and use slicers to enhance the visualization of data.More Details

Microsoft Excel 2013 Pivot Table Training

In this Microsoft Excel 2013 Pivot Table Training course, students will learn how to prepare data for use in a Pivot Table, create a Pivot Table from one or more data sources, summarize Pivot Table data, filter Pivot Tables and create and format Pivot Charts.More Details