Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive – and better information leads to better decision making! Completing this course will confer 2 CPD Credits towards internationally recognised Continuous Professional Development Requirements within organisations operating this kind of staff development methodology. Course Outline Module One: Getting Started Workshop Objectives Module Two: Opening Excel Opening Excel Using the Recent List Opening Files Creating a Blank Workbook Creating a Workbook from a Template Module Two: Review Questions Module Three: Working with the Interface Understanding the Ribbon and the Status Bar About Your Account Using Backstage View Understanding Worksheets vs. Workbooks Closing Files Closing Excel Module Three: Review Questions Module Four: Your First Worksheet Entering Data Using Flash Fill Using Auto Fill Editing Data Adding Rows and Columns Checking Your Spelling Module Four: Review Questions Module Five: Viewing Excel Data An Overview of Excel’s Views Switching Views Creating Custom Views Using Zoom Switching Between Open Files Module Five: Review Questions Module Six: Building Formulas The Math Basics of Excel Building a Formula Editing a Formula Copying a Formula Relative vs. Absolute References Using the Status Bar to Perform Calculations Module Six: Review Questions Module Seven: Using Excel Functions Formulas vs. Functions Using AutoComplete Using the SUM Function Using Other Basic Excel Functions Understanding the Formulas Tab Understanding the Function Names Module Seven: Review Questions Module Eight: Using Quick Analysis Formatting Tables Creating Quick Analysis Charts Calculating Totals Creating Quick Analysis Tables Using Sparklines Module Eight: Review Questions Module Nine: Formatting Your Data Changing the Appearance of Text Changing the Appearance of Numbers Working with Alignment Options /Using the Wrap Command/Using Merge Removing Formatting Module Nine: Review Questions Module Ten: Using Styles, Themes, and Effects Using Conditional Formatting Using Table Styles Using Cell Styles Formatting Cells An Overview of the Page Layout Tab Changing the Theme Module Ten: Review Questions Module Eleven: Printing and Sharing Your Workbook Setting up Your Page Previewing and Printing Your Workbook Inviting People E-Mailing Your Workbook Module Eleven: Review Questions
