-
All
-
Online
-
Filters
-
Location
-
Type of studies
-
+ Filters (1)
Excel inhouse
- Short course
- Inhouse
- Intermediate
- 1 Day
...for valuation presentations Save graph formatting to help maintain consistency Use comments to document their models Print comments on the spreadsheet and "move"...
- Course
- Inhouse
...within Excel and from an external source. Prerequisites To ensure your success, you must have a good grounding in Excel (to at least our Level 2 course standard or equivalent)...
- Short course
- Inhouse in Cambridgeshire
- 1 Day
...You would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others...
- Short course
- Inhouse in Cambridgeshire
- 1 Day
...Cells Copy Data to Other Cells Fill Cells with a Series of Data Insert and Delete Rows and Columns Undo and Redo an Entry Find and Replace Numbers Enter...
- Short course
- Inhouse in Cambridgeshire
- Intermediate
- 1 Day
...sorting and filtering; importing and exporting; advanced formulas; analysis tools; and collaboration. Microsoft Excel 2002 Training Course (Intermediate)...
- Course
- Inhouse
...edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in...
- Course
- Inhouse
...apply advanced analysis techniques to more complex data sets. This course is aimed at someone desiring to gain the skills necessary to create macros...
- Short course
- Inhouse
- Advanced
- 1 Day
...Solver & Data Tables Auditing Worksheets Macros, Toolbars & Menus...
- Course
- Inhouse
...Prerequisites Previous use of a keyboard and mouse is assumed for this course. Delegates should have some working knowledge of using a Windows based...
- Course
- Inhouse
...A basic understanding of mathematics is also required. Objectives Delegates will be able to : Change the view of a spreadsheet to show a different layout...
- Short course
- Inhouse
- Beginner
- 1 Day
...Delegates will learn basic worksheet techniques and how to work with data in worksheets. Delegates will learn how to create a worksheet, perform simple calculations...
- Course
- Inhouse
...with using computers and have used a mouse and keyboard. Delegates should be comfortable in the Windows environment and be able to use Windows to manage...
- Course
- Inhouse
...For a full introduction, it is suggested that this course is taken in conjunction with the Intermediate course. Pre-requisites: None other than a working...
- Short course
- Inhouse
- Advanced
- 1 Day
...Objectives How will you and your organisation benefit… Upon completion of this course you will be able to: ¨ Customise toolbars and create styles and templates...
- Short course
- Inhouse
- Beginner
- 1 Day
...Insert & Delete Rows & Columns Hiding & Showing Rows & Columns Change Column Widths & Row Heights Formatting Text & Numbers Creating & Modifying Charts...
- Short course
- Inhouse in Cambridgeshire
- Beginner
- 1 Day
...including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper...
- Short course
- Inhouse
- Advanced
- 1 Day
...of Pivot table Text Functions Using Text Functions When Importing Data from Another Application Concatenation Methods used for Combining Text Entries...
- Short course
- Inhouse
- Beginner
...Date Formats Custom Formats Conditional Formatting Defining and Naming Ranges Calculation of Named Ranges Chart Creation Creating charts Using the Chart...
- Short course
- Inhouse
...Other Features Text to Columns Concatenate Simple Macros...
- Course
- Inhouse
- Intermediate
...Switches and controls Use the IF, Choose and Offset switch functions to switch between different scenarios in a model Build nested IF statements Use...