Excel courses Leicester

...Apply Basic Conditional Formatting Create and Use Templates Printing Workbooks Preview and Print a Workbook Set Up the Page Layout Configure Headers... Learn about: Microsoft Office, Excel 365, MS Excel...

...• Workgroup collaboration Using templates • Built in templates • Creating & managing templates...

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

...Course Objectives This course will help improve your familiarity with Excel and statistics and as a result increase the effectiveness and efficiency of your work or research... Learn about: Data analysis, Microsoft Excel, Microsoft excel 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: MS Excel, Office IT, Ms Office...

...Error GoTo On Error Resume Next Excel Model Object Application Object Workbook Object and Workbooks Collection Worksheet Object and Worksheets Collection ThisWorkbook... Learn about: Visual Basic training, MS Excel, Visual Basic...

...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 Office, MS Excel...

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

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

...the validation Macros - automation tasks in sheets Registration macros Understanding and modifying the code macros (VBA items) Connecting the interface... Learn about: MS Excel, Database Management, Database training...

...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: Construction Training, MS Excel, Data analysis...