Apr
21st
Author: admin |
Files under MS OFFICE
Microsoft Excel 2007 Tutorials – CBT Training Video
Working with Worksheets and Workbooks
- Launching Excel
- Planning a Project
- Creating a New Workbook
- Adding and Deleting Data
- Importing Data into Excel
- Naming and Saving a Workbook
- Managing Multiple Worksheets
- Printing a Worksheet – Lesson 1
- Printing a Worksheet – Lesson 2
- Opening and Closing a Workbook
- Renaming and Deleting a Workbook
Editing Techniques
- Selecting Cells / Rows / Columns
- Cut / Copy / Paste
- Copy and Paste Special
- Editing or Replacing Content in a Cell
- Undo / Redo / Repeat Edits
- Adjusting Row Height
- Adjusting Column Width
- Inserting and Deleting Rows / Columns / Cells
- Merging and Splitting Cells
- Clearing a Cell
- Finding and Replacing Data
- Using AutoFill
Customizing Excel 2007
- Customizing the Excel Workspace
- Splitting the Screen
- Freezing and Locking Cells
- Hiding and Showing Rows / Columns / Sheets
- Using Different Views
- Arranging Multiple Workbooks
- Displaying Gridlines and Headings
- Setting a Trusted Location
- Using Excel Options
Changing the Appearance of a Worksheet
- Formatting Options in the Ribbon
- Formatting Text
- Formatting Numbers
- Adding Borders
- Adding Fill Colors and Patterns
- Using the Format Painter
- Using Cell Styles
- Using Document Themes
- Using Wrap Text
- AutoCorrect
- Setting Page Layout Options
- Adding Headers and Footers
- Setting Page Breaks
- Using Templates
- Using Conditional Formatting
Working with Formulas
- Using Formulas
- Formula Writing Made Easy
- Creating Simple Formulas
- Order of Operations
- Creating Formulas with Operators and Cell References
- Understanding Cell References
- Calculating Totals with AutoSum
- Common Functions
- Creating Formulas with Functions
- Creating Formulas with Nested Functions
- Creating and Managing Names
- Creating Formulas with Names
- Displaying and Printing Formulas
- Error Checking
- Common Errors When Creating Formulas
Managing Data
- Overview of Excel Data Handling Tools
- Creating an Excel Table
- Sorting an Excel Table
- Filtering an Excel Table
- Formatting Excel Table Data
- Working with Excel Table Rows and Columns
- Displaying and Calculating Table Data Totals
- Using Structured References
- Validating Data
- Linking Data Between Worksheets
- Linking Data Between Multiple Workbooks
- Exporting Data
Charts and Graphics
- Overview of Charts and Excel
- Understanding Chart Types
- Creating a Chart
- Changing the Chart Type of an Existing Chart
- Moving and Deleting a Chart
- Changing the Charted Data
- Editing Charts
- Formatting a Chart – Design Tab
- Formatting a Chart – Layout Tab
- Formatting a Chart – Format Tab
- Creating a Chart Template
- Applying a Chart Template
- Importing Graphics into Excel
- Modifying Imported Images
Excel 2007 Plays Well with Others
- Overview of Sharing and Collaborating
- Excel and Other Office Applications
- Using the Office Clipboard
- Creating PDF Files
- Opening and Saving Files in Other Formats
- Excel and Databases
- Using Queries
- Using with a Document Management Server
- Publishing an Excel Worksheet
- Excel XML Files
- Wrap Up
http://rapidshare.com/files/144551793/VTC.Microsoft.Excel.2007-CFE.part1.rar
http://rapidshare.com/files/144554667/VTC.Microsoft.Excel.2007-CFE.part2.rar
http://rapidshare.com/files/144557273/VTC.Microsoft.Excel.2007-CFE.part3.rar
http://rapidshare.com/files/144560212/VTC.Microsoft.Excel.2007-CFE.part4.rar
http://rapidshare.com/files/144562086/VTC.Microsoft.Excel.2007-CFE.part5.rar
Related Websites - how to make money without a job and why you should "It is better to have a permanent income than to be fascinating." - Oscar Wilde The following post originally appeared, in slightly modified form, on Lazy Man and Money. He's all about alternative income, of course, which is the subject of this post, so his blog is a great......
- How To Solve A Consolidation Of Your Business Phone System Needs With An Asterisk VoIP Solution Here's the scenario.......You're planning planning ahead for a consolidation of your business phone systems including a potential move of your headquarters to a new building.Currently your company has 300 employees and operates in 15 locations:- 6 warehouse locations with business offices (~30 - 50 employees each)- 1 small warehouse......
- Disposable Lab Coats Disposable lab coats are what you need if you do not work in a laboratory frequently. Just like your ordinary clothes that you wear to keep yourself from dirt and keep you comfy, lab coats are designed to keep your clothes from getting dirty and thus save yourself from......
- Congress Proposes Shamnesty for Illegal Aliens WASHINGTON: If you are not already overwhelmed and perhaps apathetic due to the onslaught of legislation working its way through the halls of Congress this year, then toss this latest straw upon the camel's back. Members of the House have unveiled a bill authored by Illinois congressman Luis Gutierrez, which......
- How Much is Customer Service Costing You? (Part 2) (If you haven't already, reading part one first will be helpful. A quick summary is that I've run into a couple of customer support problems this week.) The other problem that I've had is with my cell phone, the Palm Treo 700P. I've had Palm Treo's from when the Sprint......
