Advanced Microsoft Excel 2013 in pdf

Microsoft Excel is program designed to efficiently manage spreadsheets and analyze data. It contains both basic and advanced features that anyone can learn. Once some basic features are known, learning the advanced tools becomes easy. This lesson is composed of some advanced Excel features. It assumes basic prior knowledge of Excel, and it is expected that the objectives from AT Step’s Excel Essentials are known. This lesson will talk about the advanced customization and formatting features that allow for easier data manipulation and organization.

Objectives

• 1)  Learn how to Customize the Interface
• 2)  Advanced Formatting: Custom Lists, Cell Groups, and Transposing Tables
• 3)  Learn how to Reference Across Sheets
• 4)  Advanced Formulas and Using Data Ranges
• 5)  Using Data Validation