Excel Training - Video Series

See How Easy it is to Learn Excel!!! * Are you struggling to Learn Excel? * Are you busy enough to not spend your time reading Excel books? * Do you want to learn Excel to better contribute your existing job/work? * Do you want to s...

Description of Excel Training - Video Series:

Video Contents Index

Part 1. Basic Introduction

1. What's new in 2007 2. The Ribbon Menu 3. The Office Button 5. Keyboard Shortcuts

Part 2: First Excel File

1. Creating Excel Files 2. Cells, Rows and Columns 3. Entering Data 4. Saving Files

Part 3: Working with Worksheets

1. Add, Delete and Rename 2. Tab Colors 3. Split Windows/Freeze Panes 4. Hide and Unhide 5. Protect and Un-Protect 6. Working with Shapes

Part 4: Cell Formats and Options

1. Height and Width of Rows & Columns 2. Types of data 3. Align and Indent 4. Font Options 5. Hyperlinks 6. Context Menu 7. Insert, Delete and move columns, rows & Cells 8. Cut, Copy and Paste 9. Paste Special 10. Clipboard 11. Cell Borders 12. Merge Cells 13. Wrap Text

Part 5: More on Formatting

1. Conditional Formatting 2. Data Validation 3. Naming Ranges 4. Special Characters 5. Format Painter

Part 6: Formulas and Functions

1. Relative and Absolute Cell References 2. Other Sheets references 3. Functions 4. Function Examples

Part 7: Dealing with Data

1. Importing Data2. Text to Columns3. Duplicate Data4. Sort & Filter Data

Part 8: Finalizing the Workbook

1. Check Spellings 2. Cell Comments 3. Hide Works67.00

See Also: All products from an01digitalservices

1. DownloaderXL Package 5.8.6
   Free download real and historical stock quotes from USA, Europe, and Canada into Excel spreadsheets. Mutual funds, corporate bonds, Major USA Market Indices, Major World Indices are downloadable into Microsoft Excel spreadsheets.
2. GeneralCost Estimator for Excel 3.0
   General construction cost estimating system for Excel with localized cost data
3. PDAGraphiX2 (Spanish Version)
   PDAGraphiX2 es un graficador poderoso, flexible y dinmico, el cual permite realizar fcilmente grficos increbles con tan solo un click.
4. iDecide: Personal Edition
   Analyse risks and make better decisions using Monte Carlo simulation. Stand-alone app that includes drag-n-drop interface, tons of examples and 'What-If' analysis. Produces lots of graphs and charts to help understand the results.
5. To Do List Assistant for Microsoft Excel
   Manage your to do lists within Microsoft Excel!
6. FES Browser for Excel
   Excel workbook allowing fast internet serfing with autosaving pages and...
7. Basic Income Statement Template
   The basic income statement template is an Excel spreadsheet for those who prefer to do their own valuation and/or analysis and would rather not spend the significant time needed to create the financial statements.
8. Alyuda Forecaster XL
   Alyuda Forecaster XL is a forecasting tool for MS Excel based on neural networks. It is targeted for Excel users who need a quick-to-learn and reliable forecasting tool embedded into familiar Excel interface.
9. Let Excel Calendar
   Assign up to 25 different groups of people (for example RNs, LPNs and CNAs) to 3 daily shifts and 75 locations each day on a simple Excel calendar scheduler.
10. Spreadsheet Assistant for Microsoft Excel
    Save time in Microsoft Excel with the Spreadsheet Assistant.
11. Home Defend
    You are Alexander Johnson, Lieutenant of the United Earth Defence Regiment. You are on a small colony, in the edge of United Earth, when an unknown race attack the planet.
12. WinMend Disk Cleaner
    WinMend Disk Cleaner is a quick and safe junk file cleaner. With a powerful scan engine, it safely and quickly locates junk files in your system. By deleting junk files, it increases available disk space and improves system performance.
13. TOP DVD To iPhone Suite for Mac
    Prepared for iPod fans, TOP iPod Mate for Mac is released! It can relieve you of heavy and tiring Specially packed for iPhone users, includes two products: TOP DVD To iPhone Converter for mac and TOP iPhone Video Converter for mac.
14. VBASafe
    VBASafe is an advanced product specifically designed to protect your VBA code and intellectual property. Numerous third party tools are available on the internet which can be easily used to break the password security of VBA code.
15. Owl Commander 3.0
    Owl Commander is a complete solution for managing files for Windows Computer.
16. 007 Anti-Spyware
    007 Anti-Spyware is a feature packed antispyware program, winner of multiple awards from security experts throughout the world, designed to safely scan, identify, and clean up all malicious spyware programs that can continue generate unwanted pop-ups...
17. VCD and MPEG Tools
    VCD and MPEG Tools is an easy to use, task oriented, audio/video conversion and CD duplication tool.
18. Mathwizard
    Mathematical software with so many options regarding matrices,algebra,plot graphs,calculus,and evaluation of mathematical expressions.
19. Darts CLUB
    Serious about darts? Organizing or judging darts competitions? Invite an incorruptible authority to the game! Darts CLUB calculates scores automatically, taking away the arguments.
20. PortalGroove SpeechPlayer
    Use SpeechPlayer text-to-speech application to listen to your emails, web pages, reports or any text on your PC. Great for relaxing your eyes, proofreading, etc.! Get TV-like closed captioning on your screen to complement your listening experience.