MS Excel courses Nottingham

...Functions Lesson 5: Manipulating Data Using Text and Information Functions Topic 5A: Manipulate Data Using Text Functions Topic 5B: Validate Data Using... Learn about: MS Excel, Excel 2013, Excel 2003...

...comfortable using a keyboard and mouse and wish to learn the basics of Excel 2010. Enter data, numbers and symbols Understand the different mouse shapes... Learn about: Skills and Training, MS Excel...

...Lookup Functions. Introducing Text Functions. Taking Formatting Further Conditional Formatting. Extended Formats and Formulas. Data Validation... Learn about: Data Collection, Microsoft Excel, Excel Formula...

...effective charts in Microsoft Excel Obtain help for Excel whenever you need it Understand points to consider to avoid problems in your worksheets... Learn about: How to use Excel, Microsoft excel training, Microsoft Excel...

...You will use Microsoft Office Excel to create spreadsheets and workbooks that you can use to store, manipulate, and share your data. This course is suitable... Learn about: Excel 2010, Edit workbook and worksheet, Microsoft Excel...

...Making changes and additions to code. Adding comments. Using the Basic Help system. Extending Control Introducing some commonly used commands to give... Learn about: Microsoft Excel, Excel VBA training, Excel Formula...

...and differences between the versions. Upon successful completion of this course, students will be able to: Automate worksheet functions. Audit worksheets... Learn about: Microsoft Excel, Excel 2013, MS Excel...

...Using Excel Themes and cell Styles. Setting row and column heights. Working with Spreadsheet Data Moving, copying and deleting sections of your spreadsheet... Learn about: Microsoft Excel Beginner training, Microsoft excel training, Microsoft excel introduction course...

...Customize Workbooks Topic 7B: Manage Themes Topic 7C: Create and Use Templates Topic 7D: Protect Files... Learn about: Microsoft Excel, MS Excel, Microsoft excel training...

...Introducing Macros Recording commands in macros to simplify routines. Editing macros and assigning to objects. Object Linking & Embedding Embedded Objects and Linking Objects... Learn about: Data Management, Graphic representation, Microsoft Excel...

...You will learn how to Record a Macro, Run a Macro, create a Standard Module, create a Sub Procedure, create a Function Procedure, create an Event Procedure and much... Learn about: Excel 2010, Excel 2007, Excel 2016...

...You will acquire sufficient skills and knowledge in Microsoft Excel 2013 to enable you to develop your skills and techniques working with formulas and functions... Learn about: Charting Features, MS Excel, Financial functions...

...Variables Lesson 5: Controlling Program Execution Understanding Control-of-Flow Structures Working with Boolean Expressions Using the If...End If Decision... Learn about: Visual Basic, Visual Basic training, MS Excel...

...Upon completion the delegate will be able to: Use Excel to create, save & open spreadsheets Enter & edit information in worksheets Use formulas & simple functions to... Learn about: Spreadsheet for Beginners, Microsoft Excel 2007 Beginner, Excel Sheet...

...perform advanced data operations, data considerations, filters and advanced Pivot Table techniques, macros, and much more. Upon Completion of the course... Learn about: Data Considerations, Create Recorded Macros, Analyse Data...

...Combine functions in formulas & create Nested IFs Use Protection to prevent accidental changes to formulas Use formulas to link data in separate Worksheets... Learn about: Ms Office, Microsoft Office, Keyboard Skills...

...This training course is designed to advance users' knowledge of the features and functions within Microsoft Excel 2000 and realize the advantages of using a powerful electronic spreadsheet. The course is entirely 'hands on', so those attending will get practice in using Microsoft Excel to create... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...This training course is designed to let users get to grips with the main features of Microsoft Excel 2000.It is entirely 'hands on', so delegates will learn through practical experience of creating and modifying actual spreadsheets in the classroom. Suitable for: New or intending users of Microsoft... Learn about: Office IT, Microsoft Excel, Ms Office...

...· Adding Fields By Inserting Columns · Adding Records By Inserting Rows · Adding Records With A Data Form · Finding And Deleting Records Working with Lists... Learn about: Ms Word, MS Excel, Microsoft excel training...

...and Dropping Cells · How to Cut, Copy, and Paste Cells · How to Cut, Copy, and Paste Multiple Cells and Items · How to Use Paste Special · How to Insert and Delete Cells... Learn about: Office IT, Microsoft Office, Microsoft Excel...