Excel Courses Hertfordshire

...Utilise the Office Assistant & Help features...

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

...Track and manage changes on shared workbooks. Save the worksheet and components as HTML Documents for use on the web. Apply protection to secure formulae...

...Changing numerical formatting Applying borders and shading Changing column widths and row heights Inserting/deleting rows and columns Using AutoFormat...

...in formulae Linking and Consolidating Linking cells and formulae between sheets and workbooks Consolidating multi-worksheet data Further Functions Using...

...and modifying Pivot Tables Refreshing the data Grouping data within a Pivot Table Data Management Using worksheet auditing tools Tracing dependent...