This Advanced Microsoft Excel training course is designed for students to gain the skills necessary to be able to protect worksheet data, perform advanced data operations using summarizing, data consolidations, filters and PivotTables, macros, and much more.
By the completion of this advanced Microsoft Excel 2019 training course, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer.
With the ability to handle advanced tasks in Excel, you’ll be able to get more power out of your worksheets and be able to dramatically shorten your task times and increase your efficiency in the process.
Learn how Excel 2019 table tools take the complexity out of table creation and management. As you become proficient at nesting functions within other functions, you’ll be able to accomplish just about anything Microsoft Excel has to offer!
Our Advanced Microsoft Excel training course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.
Students who have Beginners- intermediate skills with Microsoft Excel who want to learn more advanced skills or students who want to learn the topics covered in this course.
At the end of this course you should be able to:
modify Excel options
protect data in worksheets and workbooks
import data into Excel and export data from Excel
use data linking to create more efficient workbooks
group cells and use outlines to manipulate the worksheet
create summaries in your spreadsheets using subtotals
use the Data Consolidation feature to combine data from several workbooks into one
create, use and modify data tables
create and work with scenarios and the Scenario Manager
understand and create simple PivotTables
construct and operate PivotTables using some of the more advanced techniques