Office Systems training courses in Sunderland

1 Excel Basics • Spreadsheet Concepts • Entering Text & Numbers • Summing Rows and Columns 2 Excel Workbooks • What is a spreadsheet? • Opening and Saving Workbooks • Switching between Workbooks • Entering Text and Numbers • Entering Pre Defined Lists • Defining a Custom List • Summing Rows and Columns • Saving and Closing a Workbook 3 Calculations & Corrections • Entering Formulae • Correcting Mistakes 4 Moving, Copying and Inserting • Moving/Copying...office systems trainingin sunderland

1 More about Calculations • Absolute References • Using Functions • Examples of Functions 2 More Features • Using Comments • Splitting and Freezing • Using Zoom • The Paste Special Command 3 More about Printing • Adding Headers & Footers • Setting the Print Area • Using Print Titles • Controlling Page Breaks 4 More about Charts • The Chart Menu • Revising a Chart • Further Formatting • Drag and Plot 5 Working with Multiple Worksheets • Selecting Multiple Worksheets • Navigating...office systems trainingin sunderland

1 Data Functions • Text Functions • Logical Functions • HLOOKUP/VLOOKUP • Error Functions 2 Handling Worksheets • Working with multiple sheets • Inserting / Deleting / Renaming • Moving / Copying 3 Formatting and Validation • Custom Number Formats • Conditional Formatting • Data Validation & Cell Protection • Hiding Cell Entries 4 Using Lists • Advanced Sorting & Data Filtering • Pivot Tables • Database Functions 5 More about Worksheets • Worksheet Auditing • Using Views • Scenarios & Report Manager • Designing...office systems trainingin sunderland