Description In Excel 2003 we had greatly expanded a lot of the detail included
in the course. In Excel 2007, it was a major overhaul in terms of the
interface. So, we had to focus a lot on that, we added a few more formulas
that we hadn't had before, and we also greatly expanded the conditional
formatting section. In Excel 2010, the interface has been made just a
little simpler and yet overall the capabilities have been enhanced- enabling
us to put in more formulas and put a VBA section back in.” In this
course we will be covering all of the newest features of Excel 2010. Michael
Meskers has loaded Excel 2010 with 100s of little tips and techniques
that he teaches in “Plain English” that will allow you to increase
efficiency and productivity in your day-to-day Excel use.
Benefits 100s of tips and tricks
to help you increase speed and efficiency In-depth explanation
of all topics taught Learn all of the
new and greatest features of Excel 2010
Section B: Navigating
Excel
• Ribbon Organization
• Function Grouping
• Multiple Function Access
• The Document Window
• Basic Navigation
• Workbook Options
Section C: Excel
2010 Shortcuts
• Best Practice Guidelines
• Common Hot Keys
• Speed Keys
• Function Keys
• CTRL Keys
• ALT Keys
• Visible Speed Keys
Section D: Creating
and Manipulating Data
• Entering Data
• Auto Fill a Series
• Creating Custom Lists
• Fill Adjacent Cells
• Fill Non-Adjacent Cells
• Auto Fill on Multiple Sheets
Section B: Ranges
and Dates
• Naming Ranges
• Adding Named Ranges
• Dates
• Date Speed Keys
• Formula Calculations
• Formula Auditing
• The Watch Window
• Formula Evaluation
• Section C: Subtotals
• Using Subtotals
• Subtotal Options
• Using Data Hierarchy
• Selecting Visible Data
Section D: Using
VLOOKUP
• VLOOKUP
• VLOOKUP Type I
• VLOOKUP's Three Arguments
• VLOOKUP Type I Methodology
• VLOOKUP Type II
Section F: Conditional
Logic
• The IF Formula
• The IF Statement
• Nested IF
• Nested IF Syntax
• Section G: More Conditional Logic
• Insert Wizard
• AND
• OR
• NOT
• IFERROR
• SUMIF / AVERAGEIF / COUNTIF
• SUMIFS
• AVERAGEIFS
• COUNTIFS
Module 4
Section A: Financial
Formulas
• Working with Financial Formulas
• Future Value Function
• Function Categories
• Calculating Interest Rate
• Calculating Total Payment
• Calculating Monthly Payment
• Using Goal Seek
Section B: What-If
Functions
• Solver Add-in
• Using Solver
• Constraints
• Reports
• Comparing Options
• Scenario Manager
• Scenario Report
• Data Tables
• Applying Data Tables
• Comparing Data Tables
Section C: Working
with Text Formulas
• Concatenate
• Text to Columns
• Extraction Formulas
• Combining with Previous Formulas
• UPPER/LOWER/PROPER
• Converting Formulas with Function Keys
Section D: Paste
Special
• Pasting Values
• Pasting Formats
• Quick Multiplication
• Addition
• TRIM
• Substitute
Section E: Introduction
to Charts
• Charts
• Chart Types
• Instant Chart
• Updating Charts
• Add Secondary Y/Value Axis
• Adding Data Labels
• Fill
• Picture Fill
• Line/Scatter Charts
Section D: Introduction
to Backstage
• Document Properties
• Titles/Tags/Categories
• Related Dates / People
• Formatting Comments
• Document Inspector
• Sparklines/Slicer
• Compatibility Checker
•Document Inspection
Section E: Collaboration
• Sharing Documents
• Sharing Workbooks
• Protecting Shared Workbooks
• Tracking Changes
• Accept/Reject Changes
• Information Rights Management
• Document Signature
• Mark as Final
Section F: Saving
Workbooks
• Save as Previous Version
• File Sharing with Previous Excel Version
• Customization/Compatibility
• Excel Options
• Templates
• Opening/Deleting Templates
• Save as a Web Page
• Single File Web Page
100s of tips and tricks
to help you increase speed and efficiency