IT, ICT and Computing training courses in Belfast City Centre

Introduction To Office 2010 • What Is Office 2010? • Explore the new Fluent user interface and learn how to use it • Modifying and customising application settings (eg Saving in Previous Office formats, Setting default file locations, etc) • The Status Bar • Enhanced Screen...it, ict and computing trainingin belfast city centre

Course Content Screen Tour • Toolbars & Menu Bar • Sheets Set/ Clear Print Area Formulae & Functions • Operators & Precedence • Standard Functions (Sum, Average, Max, Min, Etc) • Replicate Command (Use With Formula/ Functions, Fill • Formats/ Series/ Trends, Days, Etc) Cell References • Absolute • Relative Range Names • Create New, Modify Existing • Use...it, ict and computing trainingin belfast city centre

Course Content Advanced Functions • IF Function & Nested IF Statements • And & Or Functions • Lookup Functions (Horizontal And Vertical Lookup • Subtotals • Conditional Formatting 3D Ranges • Create & Maintain (Within Worksheets In a Single File & Between External Files) • Consolidate Data (via 3D Ranges...it, ict and computing trainingin belfast city centre

Introduction • What is a Macro • Recording a Macro • Relative References • Running A Macro • Running A Macro From The Macros Dialog Box • Editing A Macro With Visual Basic Assigning Macros to Buttons and Objects • Assigning a Macro to a Button on a Sheet...it, ict and computing trainingin belfast city centre