Questions?

1.800.258.7246


home  |  about us  |  view cart  |  search

Follow us on: FacebookTwitterGoogle+LinkedIn
National Seminars Training - Your Complete Learning Center SEMINAR FINDER
State:
ZIP:
Sign Up for Emails or Special Offers
Email:
ZIP:
  Excel 2007
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
 
Your Price: $225.00  (USD)
Online Training, 5 Sessions, 15 Hours
Item No. 201241
 

Office applications evolve to fit new challenges and add innovative features for ease of use and convenience. Whether you are a small- to medium-sized business or a corporation, you will use spreadsheets to analyze data and do projections. If you’re a spreadsheet novice or an experienced professional, the Excel 2007 course from LearnKey can help you master spreadsheets. LearnKey expert Michael Meskers uses practical examples to show you Excel fundamentals before moving step by step into more advanced topics like graphs, charts, formulas, and macros.

Benefits:

• Learn skills in one of the most powerful spreadsheet programs.
• Produce impressive business documents easily and quickly.
• Enhance your personal productivity and promotional value.
 

Section A: Introduction
· What You Will Learn
· Excel 2007 Interface
· Ribbon and Tabs
· Document Windows
· Navigation Tips


Section B: Creating and Manipulating Data
· Entering Data
· AutoFill a Series
· Fill Nonadjacent Cells
· AutoFill on Multiple Sheets
· Creating Custom Lists
· Series Formatting


Section C: Managing Worksheets
· Copying Worksheets
· Inserting and Deleting Worksheets
· Hiding Worksheets


Section D: Data Integrity
· Validation Criteria
· Character Validation
· Drop-Down Lists


Section E: Modifying Cell Content
· Cut, Copy, Paste
· Transposing Data
· Copy Cell Format Only
· Removing Duplicates
· Data Validation


Section F: Changing Views
· Zoom Features
· Workbook Views
· Page Layout View
· Repeating Cell Content
· Freeze Panes
· Split Windows
· Viewing Multiple Windows
· Saving Hot Links
· Hiding the Ribbon


Session 2
Section A: Formatting Data
· Formatting Worksheets
· Worksheet Backgrounds
· Watermarks


Section B: Modifying Rows and Columns
· Inserting Rows
· Inserting Columns
· Cutting and Inserting Columns
· Modifying Cell Width/Height
· Inserting Multiple Rows and Columns
· Inserting and Deleting Cells
· Formatting Rows and Columns
· Hiding/Unhiding Rows and Columns


Section C: Formatting Numbers
· Currency Format
· Format Painter
· Formatting Dates
· Special Formats
· Cell Styles


Section D: Formatting Text and Tables
· Fonts, Fills, and Alignment
· Comments
· Merging and Splitting Cells
· Inserting Hyperlinks
· Formatting as a Table
· Summary Function


Section E: Understanding Formulas
· Using Operations
· Creating Formulas
· AutoSum
· Common Functions
· Searching for Functions
· Copying Formulas
· Absolute Cell References


Session 3
Section A: Referencing Formulas
· Dependent References
· Multiple Sheet References
· Consolidating Data
· Consolidating With Links


Section B: Ranges and Dates
· AutoSum
· Cell Names
· Formulas With Cell Names
· COUNT
· COUNTA
· Date Formulas


Section C: Subtotals
· Overview
· Subtotal Options
· Selecting Visible Data


Section D: Lookups
· Lookups Purpose
· VLOOKUP
· VLOOKUP Exact Match
· HLOOKUP
· HLOOKUP Exact Match


Section E: Conditional Logic
· IF Syntax
· IF Statement
· Nested IF
· Nested IF Syntax


Section F: More Conditional Logic
· AND
· OR
· NOT
· IFERROR
· SUMIF
· AVERAGEIF
· COUNTIF
· SUMIFS
· AVERAGEIFS
· COUNTIFS


Session 4
Section A: Financial Formulas
· Future Value
· Payment
· Goal Seek
· Changing Rate
· Scenario Manager


Section B: Text Formulas
· Case Formulas
· Paste Column Widths
· Operations in Paste Special
· Skip Blanks
· AutoCalculate
· Fix Number Fields
· Trim Spaces
· Substitute Text


Section C: Introduction to Charts
· Chart Types
· Instant Chart
· Update Chart
· Column Chart
· Picture Fill
· Adjust Chart Size
· Line Chart
· Scatter Chart


Section D: Formatting Charts
· Chart Styles
· Chart Layouts
· Add Labels
· Axis Options
· Chart Title
· Legends
· Data Labels


Section E: Conditional Formatting
· Highlight Cells Rules
· Top/Bottom Rules
· Data Bars
· Color Scales
· Custom Formatting Rule
· Text Formatting


Section F: Adding Graphics to Spreadsheets
· Insert Pictures
· Modifying Pictures
· Insert Shapes
· Insert SmartArt
· Apply Themes


Session 5
Section A: Outlining, Sorting, and Filtering
· Group and Ungroup
· Sort Data
· Sort Multiple Levels
· Filter Data
· Advanced Filter
· Conditional Sorting and Filtering
· Sorting and Filtering Data Attributes


Section B: PivotTables
· Overview
· Creating PivotTables
· Choosing Fields
· Sub Fields
· PivotTable Layout
· Filtering PivotTables
· Totals
· Modifying PivotTable Data
· PivotCharts


Section C: Protecting Data
· Workbook Passwords
· Protecting Workbooks
· Hiding Worksheets
· Unlocking Cells


Section D: Collaboration
· Document Properties
· Formatting Comments
· Document Inspector
· Sharing a Workbook
· Track Changes
· Accept/Reject Changes
· Information Rights Management
· Using IRM
· Signature Line
· Mark as Final


Section E: Saving a Workbook
· Save As Previous Version
· Templates
· Save As PDF
· Save As Web Page
· Macro-Enabled Workbook


Section F: Printing
· Page Orientation
· Page Breaks
· Print Area
· Margins
· Headers and Footers
· Scaling

  Order online here on our secure Web site, call us toll
free at 1-800-258-7246 or fax us at 1-913-432-0824.



100% Guarantee!
Customer satisfaction is our #1 priority. If you are not satisfied with your purchase for any reason, return it to us within 60 days, and we will refund your money in full! No questions asked.





All transactions are processed through an encrypted secure socket layer (SSL).
See our privacy policy
 
National Seminars Training
1.800.258.7246