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: MS Excel, Microsoft excel training, Microsoft Excel...

...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 2007, MS Excel, Excel 2013...

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

...and Functions Create a Mixed Reference Formatting a Worksheet Convert Text to Columns Modify Fonts Add Borders and Color to Cells Change Column Width...

...• 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 training, Microsoft Excel...

...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: Excel 2016, MS Excel, Exel 2007...

...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 Sheet, MS Excel, Microsoft Office...

...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: Microsoft excel training, Ms Office, Microsoft Office...

...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: Microsoft Office, Excel 2010, Office IT...

...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: Ms Office, Office IT, Microsoft excel training...

...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 2010, Excel 2016, MS Excel...

...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 Office, MS Excel, Microsoft Excel...

...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...