Microsoft Excel may not be the only spreadsheet program around, but it may be the only one you'll ever need. You can use Excel on many different levels. But most users find out what the program can really do after it gets going.
Excel is a user-friendly program especially for those who are comfortable getting right in and clicking things. However, some parts of Excel can seem intimidating, especially when you just want to do something simple but don't know where to start.
Well, for some good old Excel help, you've come to the right place!
Jump in with the list and get some help!
Afterwards, you can choose to run or delete your Excel macros.
Also learn how to assign an Excel macro to a button which you can place on any of the toolbars.
You can also assign your macro to a menu or give your macro a shortcut key command to run the macros at your pleasure.
You'll see that creating a macro is not such a difficult task. Once again, if you know the right steps in creating a macro, then you're all set.
You'll see that you can create a formula using a lot of different methods. Learn to use the method that suits you because any one of them works just the same.
Also learn how to identify formula errors and how to use absolute, relative and mixed references.
With step-by-step instructions you'll know how to use a function properly.
Also learn how to enter functions manually and how to modify them to suit your needs.
You may have added a password for good reason, you can also remove a password!
Sometimes you might just want to change the password now and often to keep the others on their toes!
Spreadsheet data is often not much good unless you can analyze it.
If you're familiar with some of the actions that you can perform on a database, managing and analyzing your data in Excel is within your grasp, but even if you've never even heard of a database, you can still filter lists to your heart's content.
But you can also have some more complicated sorts to perform, and for this action you need to use the Advanced Sort feature of Excel.
Excel XP Topics
- Excel Screen Layout
- Navigational Techniques
- Working with Workbooks
- Working with Worksheets
- Moving Around
- Move Worksheets
- Copy Worksheets
- Insert & Delete Cells
- Insert & Delete Rows
- Insert & Delete Columns
- Resize Row
- Resize Column
- Editing Data
- Content Color
- Cell Color
- Number Formats
- Text Direction
- Indent Contents
- Merge Cells
- Undo & Redo
- Using Zoom
- Freeze & Unfreeze Titles
- Split Worksheet
- Spreadsheet Data
- Advanced Filter
- Charting Elements
- Gantt Chart
- PivotTable Calculations
- PivotTable Layout
- PivotTable Format
- PDF to Excel
- PDF-to-Excel Converter
- Excel to PDF Converter