Excel 2010

Easy-to-undestand video tutorials

VTC's Microsoft Excel course is intended for users of all levels. Whether you are working on a simple spreadsheet or a complex analysis, it’s all covered. Learn how to master the wide array of tools contained in Excel with efficiency, accuracy, and productivity. This course will help students master the art of spreadsheet design. You will learn formulas and functions, along with the database-oriented features such as pivot tables and filters. Learn about the new features of Excel 2010 and tips to increase the readability of your spreadsheets. Although taught using Excel 2010, this course is appropriate for all versions of Excel. Work files are included. To begin learning today, simply click on the movie links.

Durée 8
Avec : Lauri Sowa-Matson
Formation téléchargeable
FORMATION TÉLÉCHARGÉABLE
Formation téléchargeable
VISIONNAGE ILLIMITÉ
Formation téléchargeable
DISPONIBLE SUR USB

Nos clients ont également vu :

  • Customizing Your Screen

    • (05:39) Customizing the Ribbon
    • (04:16) Quick Access Bar
    • (02:42) Quick View of Shortcuts
  • Building a Framework

    • (05:03) Creating a New Spreadsheet
    • (04:23) Table Features
    • (03:33) Saving / Sending / Publishing
  • Editing Techniques

    • (05:09) Home Ribbon pt. 1
    • (04:08) Home Ribbon pt. 2
    • (04:19) Adjusting Columns and Rows
    • (04:07) AutoCorrect and Spell Check
  • Manipulating Data

    • (03:46) Finding and Replacing Data
    • (03:29) Using AutoFill
    • (03:29) Customizing AutoFill
  • Adding Special Effects

    • (04:15) SmartArt pt. 1
    • (03:54) SmartArt pt. 2
    • (04:47) Shapes and Pictures
  • Using Different View

    • (04:48) Using Excel Options
    • (03:39) Options Continued
    • (05:16) The View Menu
    • (04:48) Splitting the Screen
    • (04:07) Arranging Multiple Workbooks
  • Visualizing Worksheets

    • (03:36) Conditional Formatting
    • (02:54) Setting Rules for Conditions
    • (04:14) Rules Continued
    • (03:05) Alignment and Text Customization
    • (02:32) More Customization
  • Protecting Your Work

    • (02:40) Hiding Cells and Worksheets
    • (02:50) Selecting Visible Cells
    • (04:33) Protection
    • (03:11) Validation
    • (02:42) Validation Messages
    • (02:38) Validating Dates
    • (03:15) The Trust Center
  • Linking with Paste Special

    • (03:01) Using Paste Special
    • (03:15) Linking Data between Worksheets
    • (05:04) Linking with Multiple Workbooks
    • (03:56) Linking to Other Applications
    • (02:33) Linking with a Formula
  • Printing

    • (04:39) The Page Layout Menu
    • (04:46) Headers and Footer
    • (05:18) Print Headings on All Pages
    • (03:00) Wrapping Up the Page Layout Menu
  • Templates

    • (03:06) Using Templates
    • (04:20) Creating a Custom Template
    • (03:44) Working with Comments
    • (02:35) Creating Hyperlinks
  • Cell References

    • (04:51) Understanding Addressing
    • (03:48) Absolute vs. Relative
  • Introducing Formulas

    • (03:25) The Formula Menu
    • (03:56) The Basics: Order of Operations
    • (04:09) Calculating Totals with AutoSum
    • (03:19) Printing vs. Viewing Calculations
    • (04:06) Basic Formula Examples
    • (04:10) Insert Function
  • Advance Formulas and Functions

    • (04:18) Functions vs. Formulas
    • (03:42) Creating Formulas (Countif)
    • (04:51) Names
    • (05:24) Creating Formulas with Names (Countif)
    • (05:10) The IF Statement
    • (04:34) Conditional Statement Examples
    • (03:42) Formulas Manipulating Text
    • (02:38) Formula and Function Errors
  • Working with Tables

    • (02:35) Working with Excel Tables
    • (03:03) Understanding Limitations and Compatibility
    • (04:07) Calculating Table Data Totals
  • Sorting and Filtering

    • (03:05) Sorting Data
    • (05:19) Using the Filter Tool
    • (03:52) Applying Advanced Filters
    • (03:01) Working with Subtotals
    • (02:57) Subtotals Continued
  • Charts and Graphics

    • (02:36) Creating a Chart
    • (04:47) The Design and Format Ribbons
    • (03:14) The Layout Ribbon
    • (04:57) More Editing Techniques
    • (03:56) Moving Charts
    • (04:17) Combination Charts
  • Creating a Specialty Chart

    • (04:35) Understanding Dialog Box Terminology
    • (03:41) Single Point Chart
    • (04:21) Detailing the Chart
    • (03:35) Recapping Wizards
  • Spicing Up Your Spreadsheets

    • (04:19) The Insert Menu
    • (04:25) Working with Graphics
    • (05:17) The Need for Color
  • Adding Objects

    • (04:24) Creating and Formatting AutoShapes
    • (04:13) Adding Photos and Shapes
    • (04:54) Move / Copy / Resize Graphics
  • Excel Integration

    • (05:43) Working with Word
    • (04:39) Excel and Other Office Applications pt. 1
    • (03:10) Excel and Other Office Applications pt. 2
    • (04:00) Creating PDF Files
  • Working with Pivot Tables

    • (04:31) What is a Pivot Table?
    • (05:05) Formatting Pivots
    • (04:36) More Formatting
    • (04:18) Calculations
    • (02:32) Pivot Charts
  • Working with Databases

    • (05:24) Flat vs. Relational Database
    • (05:20) Working with External Data
    • (04:15) What is a Query?
  • Automation and Macros

    • (05:13) Automating Routines
    • (04:33) Creating a Macro
    • (05:14) More Macros
    • (03:39) Macros from Buttons
    • (04:41) More Buttons
  • New Features for Your Work

    • (04:45) Using Comments
    • (03:37) Graphs in Comments
    • (04:39) Sparklines
    • (03:05) Slicers in Pivots
  • Final Tips

    • (03:30) Using Help
    • (05:18) Help and Formulas
    • (03:42) Work Files
  • Conclusion

    • (02:58) Wrap Up
  • Credits

    • (02:05) About the Author
Formateur : Lauri Sowa-Matson
Langue : Anglais
Durée : 8
Nombre de séquences vidéo : 120
SKU : 34181
Réf :
ISBN : 1-936334-66-6
Date de publication : 2010-12-10
Compatibilité : Apple Mac OS X (PPC & Intel) | Windows XP, Vista, 7, 8
Formations compatibles iPad en VOD et via l'application TutoShop sur l'AppStore.

Descriptif :




Lauri Sowa-Matson

Lauri Matson owns and operates a successful consulting business specializing in accounting and computerization. Her company assists small and midsized companies with accounting, networking, and administrative solutions. She has over 30 years of accounting and administrative experience and has taught over 20,000 students in seminar and college settings. As an active consultant, she combines the day-to-day hands-on experience with the tips and tricks that are necessary to successfully incorporate an optimized database in today's business intelligence systems.

+ 10 000 TUTOS EN VIDÉO
FORMEZ-VOUS EN ILLIMITÉ
SUR
VOD.TUTOROM.FR

A partir de 19€/mois seulement
Abonnez-vous