Excel Courses Cambridgeshire

...Worksheets Use Specialized Functions Analyze Data with Logical and Lookup Functions Organizing Worksheet and Table Data Create and Modify Tables Format...

...Presenting Data Using Charts 3A: Create a Chart 3B: Modify Charts 3C: Format Charts Lesson 4: Analyzing Data Using PivotTables, Slicers and PivotCharts... Learn about: Microsoft Excel, MS Excel, Microsoft excel training...

...links Multiple sheet formulae Ranges Creating and naming ranges Clearing and formatting ranges Copying and moving ranges List Data Sorting a list Filters... Learn about: Excel 2013, Excel 2016, Create spreadsheets...

...More advanced formulas and functions. How to use 'IF' functions. Linking worksheets within a workbook. Conditional formatting. Creating templates...

...the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter Cell Data Use Excel Help Performing Calculations Create Worksheet Formulas... Learn about: Excel 365, MS Excel, Microsoft excel training...

...• Create Relative Formulas • AutoCalculate • Insert Functions • Use AutoSum • Copy Formulas • Create Absolute Formulas Module 4: Formatting an Excel Worksheet... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...

...Running and editing a macro Step through a macro Assigning a macro to the Quick Access Toolbar Using Workgroup Functions Comments Sharing lists Tracking... Learn about: Summarise Filter Sort Import and Export data, Excel 2013, Excel 2010...

...Edit Worksheet Data Topic 3B: Find and Replace Data Topic 3C: Manipulate Worksheet Elements Lesson 4: Modifying the Appearance of a Worksheet Topic... Learn about: Office IT, Microsoft Excel, Microsoft excel training...

...What is a Spreadsheet? The Excel Screen The Ribbon Moving around the screen Selecting cells and ranges Creating a Spreadsheet Opening workbooks Entering... Learn about: Excel 2010, Excel Sheet, MS Excel...

...and share Excel data with other applications. Target Student Your training in and use of Microsoft Office Excel 2010 has provided you with a solid foundation... Learn about: Office IT, XML training, Microsoft Office...

...Nesting If’s CountIfs SumIfs Handling errors HLookups VLookups Date Functions Subtotals Auditing a Worksheet Check and review data Finding cells that refer... Learn about: Excel 2013, Excel 2007, Create multi function calculations...

...Update a Workbook's Properties Modify Excel's Default Settings Collaborating with Others Protect Files Share a Workbook Set Revision Tracking Review Tracked...

...OR Dealing with Errors Statistical functions: AVERAGE/IF, COUNT/IF, MEDIAN, TREND, FORECAST Look up functions: VLOOKUP, INDEX, MATCH, OFFSET Date functions... Learn about: Microsoft Excel, MS Excel, Microsoft Office...

...from a Template Create a Custom Template Organizing Data Using Tables Create Tables Modify Tables Format Tables Presenting Data Using Charts Create a Chart...

...and sharing Excel data with other applications. Microsoft Excel 2007 Training Course (Advanced) Outline Streamlining Workflow Create a Macro Edit a Macro...

...Formats Change Column Width and Row Height Align Cell Contents Merge and Center Cells Apply an AutoFormat Working with Multiple Worksheets Format Worksheet...

...Microsoft Excel 2003 Training Course (Beginners) Outline Getting Started with Excel An Overview of Excel Navigate in Excel Select Data Enter Data...

...Chart Non-adjacent Data Modify Chart Items Create a Trendline Using Graphic Objects to Enhance your Worksheets Create Graphic Objects Resize...

...Toolbars Creating and Using Styles Using Templates Advanced Formula Construction Using Names Using the IF Function Using the VLOOKUP Function Using...

...Research Tools Creating and Modifying Charts Create a Chart Format Chart Items Change the Chart Type Create a Diagram Working with Graphic Objects Insert...