Microsoft Excel 2010 Training Video

Courses For Success
Online

AU$189 - (R$484)

Informação importante

  • Curso
  • Online
  • Quando:
    à escolha
Descrição

Microsoft Excel 2010 Training Video A Practical Excel Training Course That Teaches Real World Skills In this project-based Microsoft Excel 2010 video tutorial series, you'll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this training course to get: Concise, informative and broadcast-quality Microsoft Excel 2010  training videos delivered to your desktop The ability to learn at your own pace with our intuitive, easy-to-use interface A quick grasp of even the most complex Microsoft Excel 2010  subjects because they're broken into simple, easy to follow tutorial videos Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Microsoft Excel 2010  tutorial, online or offline... so you'll know the exact steps for your own projects. Course Fast Facts: Only 9.5 hours to complete this course 126 tutorial videos Expert instructors lead each course Download to any Windows PC or Mac and save for viewing off line Course is accessible 24/7 from any computer once downloaded You can study from home or at work at your own pace in your own time Course Description In this Microsoft Excel 2010 tutorial video, veteran Infinite Skills trainer Guy Vaccaro introduces you to the latest version of Microsoft's standard spreadsheet application. 
In this Excel Training Video, you will learn by watching the author actually perform the operations he is instructing on, as he explains step by step to how to perform these functions.  Guy explains Microsoft Excel 2010 starting with the absolute basics of creating your very first worksheet.  He slowly works you up through learning the various capabilities of this very powerful program, and even covers topics such as basic to advanced formula and functions.  He has even included a chapter on connecting to the new...

Informação importante

Requisitos: System Requirements - Digital Download Digital Download: Microsoft Windows XP or higher, Mac OS X 10.4 or higher. Minimum screen resolution of 1024x768 Digital Download specific requirements: Between 1GB and 6GB of available hard drive space (depending on the training course) An Internet connection with sufficient bandwidth. You must have at least a 56K modem connection (Broadband recommended). Most modern ADSL and Cable internet solutions will be sufficient. Do I need...

Instalações

Instalações e datas

Início Localização
à escolha
Online

O que se aprende nesse curso?

Excel
Basic
Basic IT training
Microsoft Excel
Database
Database training
Basic IT
Graphics
Printing
Microsoft excel training
MS Excel
Skills and Training

Programa

01. Getting Started
  • Overview Of Excel 2010
  • The New File Menu In Excel 2010
  • Exploring The Excel Workbook
  • What Will I Be Able To Do At The End Of This Course
  • Customizing The Quick Access Toolbar
  • Working With The Ribbons
  • Using The Files Included With This Course
  • 02. Working With An Excel Worksheet
    • Creating A New Workbook
    • Saving A Workbook
    • Saving In Other Formats
    • Open A Existing Workbook
    • Navigating An Excel Workbook
  • 03. Selecting And Entering Data
    • Entering Text And Numbers
    • Entering Numbers As Text
    • Inputting Dates And Times
    • Editing The Contents Of A Cell
    • Using Copy And Paste
    • The FILL Handle
    • Using Undo And Redo
    • Shortcuts For Selecting Cells
    • Inserting Cells, Columns And Rows
    • Deleting Cells, Columns And Rows
    • Changing Column Widths And Row Heights
    • Hiding And Unhiding A Column Or Row
    • Searching For Values In A Worksheet
  • 04. Developing A Workbook
    • 0401 Formatting And Naming Of Worksheet Tabs
    • 0402 Moving Worksheets Within And Between Workbooks
    • 0403 Copying Worksheets Within Workbooks
    • 0404 Inserting And Deleting Worksheets
    • 0405 Viewing More Than One Workbook
    • 0406 Hiding And Unhiding Worksheets
  • 05. Printing And Page Setup
    • 0501 Using The Print Area Command To Control What Excel Prints
    • 0502 Setting Page Margins And Page Orientation
    • 0503 Creating A Header And Footer
    • 0504 Using Page Break View
    • 0505 Setting Print Titles For Large Worksheets
    • 0506 Printing Gridlines Column Row Headings And Other Related Options
    • 0507 Enabling The New Page Layout View
    • 0508 Running The Spell Checker
    • 0509 Print Preview And Printing The Whole Or Part Of The Worksheet
  • 06. Workbook Formatting
    • 0601 Modifying Typeface, Font Size And Colors
    • 0602 Merging Cells
    • 0603 Applying Number Formats
    • 0604 Aligning Cell Contents
    • 0605 Changing The Text Direction In A Cell
    • 0606 Adding Borders To Cells And Ranges
    • 0607 Applying A Date Format To A Cell Or Range
    • 0608 Use Of The Format Painter
    • 0609 Clearing Cell Contents And/Or Formatting
  • 07. Carrying Out Calculations
    • 0701 Getting Started With Basic Math Formula Addition
    • 0702 Getting Started With Basic Math Formula Subtraction
    • 0703 Getting Started With Basic Math Formula Multiplication
    • 0704 Getting Started With Basic Math Formula Division
    • 0705 Getting Started With Basic Math Formula Operand
    • 0706 Order Of Operations with BODMAS
    • 0707 Introduction To Excel Formulas: SUM
    • 0708 Copying Formulas And Functions
    • 0709 Displaying Formulae On A Worksheet
    • 0710 Some Useful Functions For Counting
    • 0711 Some Useful Functions For Averages
    • 0712 Some Useful Functions For Highest And Lowest
    • 0713 Absolute Referencing Requirements
    • 0714 Formulas Across Worksheets
    • 0715 Functions Across Worksheets
    • 0716 3D Referencing
    • 0717 Making Use Of Named Cells And Ranges
  • 08. Advanced Formatting
    • 0801 Enhancing Worksheets Using Themes
    • 0802 Working With Comments
    • 0803 Creating Your Own AutoFill List
    • 0804 Turning Your Data Into A Table For Formatting
  • 09. Security
    • 0901 Using Protection On A Worksheet
    • 0902 Protecting Part Of A Worksheet To Facilitate Data Entry
    • 0903 Controlling Access To Cell Ranges By Password And Or User Accounts
    • 0904 Saving A Workbook With Password Protection
  • 10. Using Templates
    • 1001 Creating A Workbook From A Template
    • 1002 Creating Your Own Custom Template
  • 11. Graphics Objects
    • 1101 Inserting And Modifying Clipart
    • 1102 Using SmartArt Graphics
    • 1103 Adding Drawn Shapes To A Worksheet
    • 1104 Inserting An External Picture
    • 1105 Adding A Background Image To A Worksheet
    • 1106 Formatting Graphic Objects
    • 1107 Controlling Stacking Order And Alignment Of Multiple Graphics Objects
    • 1108 Grouping Graphic Objects
    • 1109 Accessing Formula Results In A Callout Bubble
  • 12. Using Excel As A Database
    • 1201 Fixing Rows And Columns On Screen
    • 1202 Fixing Rows And Columns For Print
    • 1203 Sorting Data In A Worksheet
    • 1204 Filtering Data In A Worksheet
    • 1205 Removing Duplicates In An Excel Database
    • 1206 Adding And Using Subtotals In An Excel Database
    • 1207 Splitting One Column Of Data Into More Columns
    • 1208 Splitting The Screen To View Different Parts Of The Same Worksheet
    • 1209 Linking To Data On A Webpage
  • 13. Using Charts In Excel
    • 1301 Creating A Chart The Long Way
    • 1302 Creating A Chart The Quick Way
    • 1303 Changing A Chart From A Sheet Object To A Sheet
    • 1304 Modifying Your Chart Type
    • 1305 Controlling Chart Style And Layout
    • 1306 Adding A Trend line To A Chart
    • 1307 Pie Charts In More Detail
  • 14. More Advanced Formula
    • 1401 Adding An IF Function For Cell Comparisons
    • 1402 Using the IF Function To Suppress Excel Error Messages
    • 1403 Text Manipulation With Formulae - Part 1
    • 1404 Text Manipulation With Formulae - Part 2
    • 1405 Date Formula In Excel
    • 1406 DATEDIF - A Hidden But Useful Formula
    • 1407 SUMIF COUNTIF And AVERAGEIF
    • 1408 Use Of A Formula To Rank Scores
  • 15. Conditional Formatting
    • 1501 Changing Cell Appearance Based On Its Value
    • 1502 Editing Conditional Formatting Rules On A Worksheet
    • 1503 Removing Conditional Formatting Rules
    • 1504 Highlighting Duplicate Values Using Conditional Formatting
    • 1505 Identifying The Top Or Bottom Percentage Of A Range
    • 1506 Use Of Data Bars Within Conditional Formatting
    • 1507 Use Of Colour Scales Within Conditional Formatting
    • 1508 Applying An Icon Set To Conditional Formatting Rules
  • 16. Office Web Apps And Excel
    • 1601 What Is Office Web Apps?
    • 1602 Sign In To Or Sign Up For Your Own SkyDrive
    • 1603 Saving An Excel Workbook Into SkyDrive
    • 1604 Accessing And Editing An Excel Workbook Through SkyDrive
    • 1605 Telling Others Where Your Public Documents Are
    • 1606 Direct Linking Or Embedding Of SkyDrive Documents
    • 1607 Creating A Folder Structure Within SkyDrive
    • 1608 Deleting Files From SkyDrive
  • 17. Credits And Beyond
    • 1701 About The Author

Informação adicional

Digital Download FAQs

Q: What is a digital download?

A digital download is training that you download from the internet using your web browser instead of us shipping you a physical CD.

Q: How instant is the "Instant Purchase"?

If you complete your purchase, you are emailed your access key within minutes of the transaction completing.

Q: How do I access my digital download...