Birmingham - Bristol - Cambridge - Coventry - Edinburgh - Glasgow - Kingston - Leeds - London - Manchester - Slough

Excel training courses and schools
Microsoft Excel

School: Activia
[All Courses]

Microsoft Excel 2007 Advanced
Course Format: Classroom
This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Excel tools and concepts in order to increase their knowledge and productivity. Who Should Attend? Users with a good understanding of Microsoft Excel 2007 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledg...
 

Excel for Accounting : Advanced
Course Format: Classroom
Sorting and Filtering Data Create a data list Perform single and multi-level sorts Apply a filter to a data list Adding Charts and Pictures to a Workbook Use the Chart Wizard to create a chart Move and size worksheet charts Change the chart type Format chart elements Change the source data for a chart Preview and print charts Insert, move and delete clip art and picture obje...
 

Excel for Accounting : Introduction
Course Format: Classroom
Formatting a Worksheet Font styles (typeface, size, colour, styles) Modify alignment & orientation of cell contents Merge and unmerge cells Value formats (currency, percent, date, comma) Adjust the decimal place Modify the size of columns and rows Clear cell content and formats Borders, Shading and Other Formatting Apply cell borders and shading Apply AutoFormat Use the Form...
 

School: ABC Dee Training
[All Courses]

NLP for Business Excellence
Course Format: On-site
Modelling - Replicating Successful Strategies All behaviour has a structure If they can do it, so can you Creating a model for driving a car Observing and mapping the successful behaviours of others Eliciting success: a strategy to reach the desired state What do they do How do they do it Why do they do it Behaviour Thinking processes Beliefs Your Map of The World Experienci...
 

Excel VBA
Course Format: Classroom
Running a macro Recording a macro Examining module design Assigning macros Specifying the location of recorded macros Assigning shortcut keys to macros Assigning macros to menus Assigning a macro to a button on a sheet Assigning a macro to a button on a toolbar Creating decision-making code The If...Then decision structure The If...Then...Else decision structure The Select Case ...
 

Excel Advanced
Course Format: Classroom
Insert and edit graphic objects to enhance worksheets and charts Format graphic objects Advanced techniques for filtering data Multiple-condition criteria Manage a filtered list Create name ranges Use name ranges in formula Manage name ranges LOOKUP functions VLOOKUP, HLOOKUP functions IS, ERROR functions Create Pivot tables Edit pivot tables Group and summarise data ...
 

Excel Intermediate
Course Format: Classroom
Absolute references Work with multiple worksheets Work with multiple workbooks Link cells in different workbooks Create workspaces Formula construction Logic functions: IF, nested IF functionAND, OR function SUMIF, COUNTIF functions Create, edit and delete comments Use the auditing toolbar Use data validation Sort data Single-level and multiple-level sorting Sorting opt...
 

Excel Introduction
Course Format: Classroom
Introduction to Excel basics The workbook environment Enter and edit data Navigate in a worksheet Correcting data Edit cell contents Use AutoComplete Save a file Open a second and third file Navigation and movement techniques Modifying a workbook Work with ranges Create formulae Move and copy data Cut and paste data Drag and drop data Insert rows and columns Use the cl...
 

School: Eden House College
[All Courses]

MS Excel
Course Format: Classroom
Microsoft Office Excel is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. With the Microsoft Office user interface, rich data visualization, professional-looking charts are easier to create and use. You can share information more broadly with enhanced security with your co-workers, customers, and business partners...
 

School: NobleProg
[All Courses]

Excel For Statistical Data Analysis
Course Format: On-site
This course will help improving your familiarity with Excel and statistics and as a result increase the effectiveness and efficiency of your work or research. This course describes how to use the Analysis ToolPack in Microsoft Excel, statistical functions and how to perform basic statistical procedures. It will explain what Excel limitation are and how to overcome them. Training Course O...
 

Page(s):- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 [ Popular Topics ] [ Schools Only ]