TeachUcomp. Advanced Excel

TeachUcomp, Inc., 2012. — 193 p.
(Автор не указан).Welcome to Teachucomp, Inc.’s Advanced Excel course. This class caps the student’s knowledge of Microsoft Excel, one of the most popular spreadsheet programs available today. This class is designed to give the student a firm grasp of the advanced concepts in Excel.
Excel is an excellent program to learn, as the skills that we learn in Excel apply to many other programs as well, especially Access. It is the recommended starting point for learning database programs as it contains some basic database functionality and features.
Excel is a multi-featured spreadsheet program in which you can create powerful spreadsheets that can manipulate numbers and store data for you. It is a very powerful program, and has many advanced features that can automate and simplify your work. Whether you want it to create charts, spreadsheets, or data sources, Excel can assist you in accomplishing your tasks quickly and easily.
This class will focus on the advanced concepts of the Excel program. You will learn how to create and manage data models, use PivotTables and PivotCharts, create Power View visualizations and use the PowerPivot Add-in in Excel Professional Plus 2013, use slicers, apply security, and set up macros.