Excel courses Liverpool

...• Using Group Editing • The IF Function • Data Calculations • Calculating Percentages • Entering Formula Across Worksheets • Conditional Formatting • Custom...

...attended our Excel Advanced course or be able to demonstrate equivalent knowledge. Microsoft Excel VBA •Introduction to Excel VBA •Recording and running...

...Working With Pivot Tables Modifying & Enhancing Pivot Tables Extracting Pivot Data Pivot Calculations Creating Pivot ChartsSetting Defaults Cell Comments...

...•Nested functions •Using data forms to enter, delete and search for data •Using Subtotals to calculate sub sets of data Tools •Naming cells and ranges...

...• Using the Insert Function feature • Relative & Absolute Cell References • Changing Page Setup • Headers & Footers • Print Preview & Printing Options...

...rows and columns Entering and Editing Data • Formatting numbers • Creating a new Excel workbook • Inserting rows and columns • Entering and editing labels...

...TablesMacros •Creating a pivot table •Recording a simple macro •Rearranging pivot tables •Editing a macro •Formatting pivot tables •Assigning a macro to...

...and how to secure it. Advanced Features of Excel Functions Panel The properties of an object from VBA Events Sheet, Workbook and Application Formula repeatedly... Learn about: MS Excel...

...Moving Average Smoothing Seasonal fluctuations analysis Comparing Populations Confidence Interval for the Mean Test of Hypothesis Concerning the Population... Learn about: Excel Formula, Data analysis, Confidence Training...

...Immediate window Traps - Watches Call Stack Error handling Types of errors and ways to avoid Capturing and handling run-time errors Structures... Learn about: Visual Basic, MS Excel, Visual Basic training...

...the Page Setup Print preview A dialog box, printing Using lists Lists Transforming the range of the list Application forms AutoFilter Advanced filters... Learn about: Office IT, MS Excel, Ms Office...

...the Page Setup Print preview A dialog box, printing Using lists Lists Transforming the range of the list Application forms AutoFilter Advanced filters... Learn about: MS Excel, Ms Office...

...the correctness Recording and editing macros Visual Basic for Applications Create your own functions Results in VBA VBA Forms... Learn about: Visual Basic, Database training, MS Excel...

...the correctness Recording and editing macros Visual Basic for Applications Create your own functions Results in VBA VBA Forms... Learn about: Database training, Data analysis, MS Excel...

...how to create Strainers having access to the filter criteria Fast text-to-column Delete duplicate data Forcing input the correct data - how to ensure... Learn about: Construction Training, Data analysis, MS Excel...

...how to create Strainers having access to the filter criteria Fast text-to-column Delete duplicate data Forcing input the correct data - how to ensure... Learn about: Data analysis, MS Excel, Construction Training...