Excel courses

...complex tasks using macros summarise data using pivot tables analyse and extrapolate data using scenarios and solver create complex formulae using combinations...

...which has been exported from Sage Line 50 into Microsoft Excel, it does not seek to show how to perform the export function (i.e. the linking process)...

...Learning Objectives This 3 hour course has been designed for existing users/self taught users who need to create and edit simple charts and those who...

...The ‘Average’ Function ‘Minimum’ and ‘Maximum’ Functions ‘Count’ and ‘Count If’ Functions Range Names Creating Range Names Using Range Names Protection...

...create formulae with excel functions, including conditional and nested functions produce a variety of reports and models including what if analysis...

...Customers who wish to learn how to link Sage 50 Accounts with Excel should attend the Linking Sage 50 Accounts with Microsoft Office course. This one...

...use Excel correctly or is currently using workarounds or asking colleagues for advice would benefit from this course. Course Overview On this course...

...formatting data and content, creating and modifying formulas, presenting data visually, and collaborating on and securing data. Benefits to the Employer...

...what delegates wish to learn on each course as well and try to include this in the content. Completion of this course will map delegates towards the Microsoft...

...Collaborating with Others Topic 2A: Protect Files Topic 2B: Share a Workbook Topic 2C: Set Revision Tracking Topic 2D: Review Tracked Revisions Topic...

...Course review: On this course you will be taught some of the more advanced functions of MS Excel allowing you to create and use pivot tables as well...

...Instructor lead at DBIC Duration: 1 day intensive Times/dates: Cost: £185 (includes course materials, lunch and refreshments) Corporate rates available...

...or Windows NT Workstation 4.0: Introduction Lesson 1 : Excel Basics Excel Basics Lesson 2 : Entering Data and Navigating in a Worksheet Entering and Correcting...

...Insert and Delete Cells, Columns, and Rows Topic 2E: Find, Replace, and Go To Cell Data Topic 2F: Spell Check a Worksheet Lesson 3: Performing Calculations Topic...

...Web Site EXCEL FILE TYPES Spreadsheet files Online Publishing files XML files Template files EXCEL ENVIRONMENT Working with the Excel window Using...

...Instructor lead at DBIC Duration: 1 day intensive Times/dates: Cost: £185 (includes course materials, lunch and refreshments) Corporate rates available...

...On this one-day Excel spreadsheet introduction course you will learn to budgeti, analyse sales, produce reports, create basic charts and graphs and manage small lists...

...This one day course focuses on building on existing knowledge of Excel and the elements include: ♦ More advanced formulas and functions ♦ How to use “IF”...

...hidden Worksheets FREEZING PANES Freezing a horizontal pane Freezing a vertical pane Freezing horizontal and vertical panes Unfreezing panes GROUPING...

...1 day intensive Times/dates: Cost: £185 (includes course materials, lunch and refreshments) Corporate rates available please contact us for further information...