Excel Training London

...on worksheet Pivot Chart What If Analysis Scenarios Custom Views Reports Goal Seek Solver Data Tables Protecting & Sharing Files Sharing a file Tracking... Learn about: MS Excel...

...Excel Advanced Requirements: All attendees must be proficient with basic Mouse, Keyboard and Windows skills. You should be familiar with the topics covered...

...data out of Sage software and into Excel. Important Note: although this course uses data which has been exported from Sage Line 50 into Microsoft Excel...

...Programming Special Features Programming Pivot Tables and PivotCharts Programming Special Features Using and Programming Excel Lists Programming the Visual... Learn about: Analytic Expert...

...Watch Pane Step through Functions using the immediate Window Looping Structures Do Loops For Next Loops For Each Next Loops Interactive Macros Msgbox Conditional... Learn about: MS Excel...

...Chart basics Modifying charts Printing charts Web features Saving workbooks as Web pages Hyperlinks Sending workbooks via e-mail -Excel intermediate course...

...Excel training course session 1 Named Ranges Microsoft Excel training course session 2 Advanced Formulas & Worksheet Auditing Microsoft Excel training...

...it is now possible for all of your Excel users to become power users! Our Excel power user courses show delegates who have an intermediate to advanced... Learn about: Excel power, Microsoft excel training, Microsoft Excel...

...sheets at once Window Split Data consolidation Basic List Management Sorting Data Adding Subtotals AutoFilter Freeze Panes Group and Outline Data... Learn about: MS Excel...

...Maximum 8 This course is suitable for users with a basic understanding of Excel who want to consolidate and expand on their knowledge of the basic features...

...Using COUNT, COUNTA, and the status bar Mathematical Functions Working with ROUND, ROUNDUP, and ROUNDDOWN; Working with MROUND, CEILING, and FLOOR for specialized rounding... Learn about: Blank cells, Text Functions, Tabulating blank...

...Delegate numbers are restricted to 8, to ensure personal attention from the trainer. Structure: PC for every delegate All pass training courses involve...

...Applying names to formulas, Understanding external references Working with functions Inserting functions, Supplying function arguments, Supplying range arguments... Learn about: Database training, Microsoft Excel, IT Auditing...

...Excel / Introduction Objective: To give users an introduction to Excel and enable them to realise the advantages of using a powerful electronic spreadsheet...

...Transforming date columns Transforming Rows Promoting row headers; Removing unwanted rows of data; Removing duplicate rows; Removing rows which contain error values... Learn about: DAX formula, Data Types, DAX Language...

...Adding a TextBox control, The CheckBox control, The OptionBox control, ComboBox and ListBox, SpinButton controls, Adding CommandButtons, Setting control... Learn about: Alerts property, Cut Copy, MS Excel...

...Cutting And Pasting Data, Copying And Moving Cells Using Drag-And-Drop, Changing Column Width, Changing Row Height, Inserting And Removing Rows And Columns... Learn about: MS Excel, Cell borders, Cell styles...

...Using Sparklines, Customizing Sparklines Working With Graphics Adding Clip Art, Adding Pictures, Adding Shapes, Formatting Drawing Objects, Inserting Wordart... Learn about: MS Excel, Totaling Data, Chart Text...

...#DIV/0!, #NAME?, #REF, #NULL!, #N/A, Using conditionals to anticipate error values, Using IFERROR(), Using the formula error checker, Auditing a worksheet... Learn about: Pivottable Data, MS Excel, Optimizing Lookup...

...a Pivot Table Controlling the Report Layout, Adding Blank Rows in the Layout, Using a Pivot Table Style, Adding Row and Column Shading, Formatting the Row and Column Headers... Learn about: PivotTable Style, Report Filter, Table Layout...