 Learn to Use Excel 2007 Everything you need to know about spreadsheets! This comprehensive training program, couldn't be easier to use. On-screen video demonstrations take you step-by-step through over 100 different topics, each with clear and concise instructions. Simply pick the topic you want to study and sit back and watch as an expert shows you exactly how it's done. Practise what you've learnt in an interactive tutorial where you try out the task in a simulated environment and then move on to actually 'do it' in your own copy of Excel 2007. Whether you're a complete beginner, or need to refresh your computer skills, this program will have you up and running with Excel 2007 in no time at all. FEATURES: · Interactive demonstrations and video clips · Easy-to-work-through chapters · The basics through to advanced features · Comprehensive training lets you learn at your own pace Look at what you’ll be able to learn in just a few minutes!... STEP 1 – Choose your topic The program is divided into chapters, which are then broken down into easy-to-master sections which you can study in any order. Simply choose the topic you want to learn more about.
STEP 2 – Study the basics Read through a short description of the key points to help you follow the on-screen demonstration.
STEP 3 – Watch how the experts do it! Sit back and watch as the program shows you what to do. The tutor's voice talks you through each step as the screen video plays. You can watch it as many times as you want to make sure you've remembered everything.
STEP 4 – Practise it Try out what you've learnt in an interactive tutorial that simulates the Excel 2007 environment.
STEP 5 – Do it! Now it's time to actually do it in your own copy of Excel 2007. Follow the instructions in the pop-up window while you work through the task yourself. TOPICS INCLUDE: Getting started · Starting with Microsoft Excel 2007 · Keyboard shortcuts · Pop-up menus File management · Creating, opening, saving & printing · Adding/Deleting sheets Selections & Movements · Select, cut, copy & paste functions · Setting a data entry range/Transposing data Working with worksheets · Entering data/Custom lists · Formulae · Numeral data series and dates · Naming a range of cells · Auto calculation · Comparing workbooks · Sorting/Filtering data · Automating work with a macro Formatting worksheets
· Inserting/deleting rows, columns & cells · Setting height/width of rows, columns & cells · Formatting numbers and changing margins, headers and footers · Using tables/Formatting with themes Display and page setup · Protecting a file or worksheet · Adding comments/Freezing panes · Page setup for printing · Changing margins · Headers and footers Illustrating & graph processing · Inserting a picture · Automatic shapes · Creating a chart plus much more... |