| Training > Microsoft Office Excel®, Spreadsheet Save time and money with the help of an experienced online trainer and learn how to make better use of Excel® to get your life sorted by creating orderly lists and accurate accounts! Online lessons from PCduetto.com help you to improve your knowledge of Excel® 2000, XP, 2002, 2003 and (shortly), 2007. Whatever your level of proficiency, whether you are a complete beginner, or at intermediate or advanced levels, profit from the convenience of “a la carte” tuition at a time to suit you.  |
|
Working with Excel® documents  Creating, saving and closing documents
Opening existing documents Navigating into Excel® workbook Sizing rows and columns Copying, deleting and moving cells Creating, renaming, colouring or hiding tabs Customizing views |
Editing and formatting spreadsheets Entering text, numbers and dates Entering data quicker without errors Amending and clearing a cell Formatting cells Copying formatting Finding and replacing text Using spelling corrector |
Calculating with Excel® Using simple arithmetic formulas Using a cell field in formulas Using arithmetic, financial, date & time, and logical functions |
Printing spreadsheets Controlling data on the printed page Adding page titles and footnotes etc. Using print preview Printing and changing print options |
|
Creating charts and diagrams Inserting WordArt, Clip Art or a picture Creating dynamic charts (histograms, line charts, pie charts etc…) Sizing and positioning added elements |
Collaborating and sharing documents Adding comments and reviewing documents Protecting documents with a password Managing and viewing cells |
Excel®’s specific functions Freezing title rows and/or columns Auditing formulae to localize error Filtering data Sorting arrays on one or more columns Outlining and structuring spreadsheets Creating and merging Excel® scenarios Using pivot tables |
Go further… Creating internal and external hyperlink texts Using data validation to control user-input data Importing and exporting data from/to other programmes Customize Excel®’s menus and toolbars Programming repetitive tasks with macros |
|
|
