68 CBD courses

Discover the more complex features of Word for long document creation. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 1 day (6.5 hours) Our Word Document Production (Part 2) course shows you some of the more advanced features of Word that are key for long document creation. This course will enable you to create longer, more complex documents with ease, including adding cross references, headers and footers and a table of contents. This course is aimed at existing Word users who have attended our Word Document Production (Part 1) course or have equivalent knowledge and who want to extract the most out of the package. OBJECTIVES  By the end of the course you will be able to: * Create, amend and use templates * Use styles for easy formatting * Work with section breaks * Manage linked headers and footers * Insert pictures and objects * Add cross references * Create a table of contents * Use tracked changes CONTENT CREATING TEMPLATES * Creating templates * Using templates * Amending templates USING STYLES IN TEMPLATES * Adding styles to a template * Using Heading Styles * Managing Styles * Applying template style changes directly from a document * Copying styles between templates WORKING WITH DIFFERENT TYPES OF SECTION BREAK  * Next page section breaks * Odd and even section breaks INSERTING PAGE NUMBERS, HEADERS AND FOOTERS * Creating custom headers and footers * Inserting fields * Using Section breaks * Dynamic linking between Sections * Page numbering in Sections GRAPHICS * Inserting pictures * Inserting objects from other packages * Object text wrapping options * Picture options ADDING CROSS REFERENCES * Creating cross references CREATING A TABLE OF CONTENTS * Generating a table of contents * Setting table of contents styles * Updating a table of contents TRACK CHANGES * Setting track changes * Accepting and rejecting changes * Viewing comments * The reviewing pan

Learn all the quick tips and tricks you didn’t know about in Word and how to properly setup new documents. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 1 day (6.5 hours) Our Word Document Production (Part 1) course shows you how Word was designed to be used and demonstrates the powerful tools available. This course will enable you to originate professional documents with ease, ensuring that modifications are quick and uncomplicated.  It looks at some of the common frustrations and how to avoid them. This course is aimed at existing Word users who want to get the best out of the package OBJECTIVES  By the end of the course you will be able to: * Customise Word * Use different Word views * Use line, paragraph and page breaks correctly * Set indents and tabs * Use styles for easy formatting * Work with section breaks * Work with automatic correction features * Insert and modify tables CONTENT Word setup * Using different views * Customising the status bar * Customising the Quick Access bar and Ribbon DOCUMENT SETUP * Using the Navigation Pane * Using Show / Hide * Line vs paragraph breaks * Using page break USING THE RULER  * Setting indents and tabs * The different types of indent * Using dot leader tab BULLETS AND NUMBERING * Working with simple numbered and bulleted lists * Sorting lists * Working with multi level lists STYLES * The importance of styles * Creating, amending and applying Character Styles * Amending and applying Paragraph Styles * Setting bullet point styles * Using the Style Inspector REORGANISING A DOCUMENT * Using Outline View * Promoting and demoting headings * Displaying Styles names in Draft and Outline views PAGE AND NUMBER FOMATTING * Section vs page breaks * Setting page orientation * Setting page margins * Displaying page border  AUTOMATIC CORRECTIONS * Working with Quick Parts * Setting autocorrect options * Autoformat while typing CREATING SIMPLE TABLES * Inserting or drawing a table * Modifying table formatting * Adding rows and columns * Changing row heights and column widths

Ensure you can fully utilize this powerful tool to create a range of flowcharts and diagrams. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 1 day (6.5 hours)  Microsoft Visio is a powerful tool designed to simplify complex information through the creation of simple, professional-looking diagrams. While Visio is capable of producing almost any type of drawing this training concentrates on flowcharts, swim lane process diagrams and organisation charts. You will also discover the real power of Visio by adding essential data to the content of your diagrams and producing reports in Excel using this data. This course is designed for either new users of Visio or those who have dabbled and can create basic diagrams. Our course will give you the skills and knowledge you need to navigate your way around this powerful program and produce different types of diagram. OBJECTIVES  By the end of the course you will be able to: * Create and amend flowcharts * Create cross functional (Swim Lane) process flows * Produce organisation charts by importing data * Add essential data to shapes * Export diagram data reports to Excel * Present, publish and print Visio diagrams CONTENT VISIO ESSENTIALS * Finding your way around Visio * Using the ribbon and Quick Access toolbar * Keyboard shortcuts * Shapes and stencils explained * What Visio can do for you CREATING BASIC FLOWCHARTS * Working with shapes * Adding and deleting shapes * Joining, aligning and sizing shapes * Using Auto-Connect * Labelling shapes and connectors EDITING AND IMPROVINC FLOWCHARTS  * Amending shape and connector labels * Using colours to emphasise * Changing line styles * Moving and copying objects * Grouping diagram elements * Quick ways of working CROSS FUNCTIONAL FLOWCHARTS * Creating Cross-Functional Flowcharts * Manipulating functional bands * Creating off-page references within diagrams and hyperlinks to other documentation ORGANISING CHARTS AND SHAPE DATA * Using the wizard to create an organisation Chart * Importing existing Data into to create an organisation chart * Modifying an organisation chart * Shape Data * Adding shape data to a shape * Creating shape data sets DIAGRAM REPORTS * Exporting data to a report in Excel * Exporting to HTML * Creating and customizing reports PRESENTING, PUBLISHING AND PRINTING * Using Page Setup * Print previewing * Embedding backgrounds * Adding headers and footers * Converting your final documentation to PDF * Saving as HTML * Visio with PowerPoint

Learn the proper way to use PowerPoint and the background features that can make a real difference. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 1 day (6.5 hours) Our PowerPoint – Professional Presentations course looks at creating professional, business focussed presentations quickly and easily. It ensures delegates are aware of the key concepts in using the tool such as slide masters and by the end of the day you will be able to create and run high quality presentations. This course is designed for new and existing users of PowerPoint who want to get the best out of the tool. OBJECTIVES  By the end of the course you will be able to: * Create a new presentation * Amend the slide master/template * Create text slides * Animate text on slides * Insert pictures and objects * Set object animation * Insert and work with SmartArt * Create charts * Run a presentation CONTENT CREATING A NEW PRESENTATION * Creating a new presentation from a template * Using your company template * Changing slide layouts * Copying, deleting and inserting slides USING THE SLIDE MASTER * Modifying the Slide Master * Using Slide layouts * Multiple Slide Masters * Slide dates, footers and numbers CREATING TEXT SLIDES  * Working with bullet points * Setting spacing * Changing text and bullet styles * Using Outline view * Text animation on a slide * Slide titles * Bullet points * Applying animation to the Slide Master ANIMATING TEXT * Slide titles * Bullet points * Applying animation to Slide Master DRILL DOWN VS DRILL THROUGH * Review of drill down * Creating drill through pages * Using drill through INSERTING AND WORKING WITH PICTURES * Inserting pictures * Inserting online pictures * Formatting pictures ADDING DRAWINGS * Inserting lines and shapes * Using Quick Styles * Selecting and grouping objects * Aligning and positioning objects * Add text to a shape * Duplicating objects OBJECT ANIMATION * Simple object animations WORKING WITH SMARTART * Inserting SmartArt Graphics * SmartArt formatting * Converting text to SmartArt INSERTING CHARTS * Creating a slide with a graph * Changing chart types * Setting chart options * Graph animations PRESENTING YOUR PRESENTATION * Slide show settings * Using Presenter view * Using the PowerPoint viewer * Slide show presentation tips

Learn how to create fully relational databases and how to input, extract and report on data. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 2 days (13 hours) Our Access Database Design and reporting course looks at the key elements to building fully relational databases and entering and extracting information from them. This course is designed for new users who need to build relational database systems. OBJECTIVES  By the end of the course you will be able to: * Create a new database * Create data tables * Set field validation and properties * Enter data and manage data * Create forms * Use queries to extract data * Create parameter queries * Create calculations in queries * Build relational databases * Use sub datasheets * Build multi table queries * Use advanced form and report design techniques CONTENT Creating a database * Creating a new database * Database elements CREATING A DATA TABLE * Setting field properties * Using input masks * Using input masks * Validation rules * Default values * Setting a primary key * Creating lookup fields DATA ENTRY  * Adding data * Deleting data * Quick keys for data entry WORKING WITH DATA * Sorting data * Filtering data * Finding information * Navigation CREATING DATA FORM * Creating quick forms * The form wizard * Amending forms * Formatting * Setting the tab order * Entering data using forms CREATING QUERIES * Creating a query * Setting criteria * Using the expression builder CREATING PARAMETER QUERIES * Using wildcards * Using more than one parameter USING CALCULATIONS IN QUERIES * Adding a totals row * Formatting results * Adding calculations PRINTING AND REPORTING * Printing tables and queries * Creating reports * Building and amending reports * Adding headers and footers WORKING WITH RELATIONAL DATABASES * Relational database principles * Importing data from other sources * Linking information between tables * One-to-one and one-to-many links * Defining referential integrity * Amending links * Deleting links SUB DATASHEETS * Viewing a subdatasheet * Removing a subdatasheet * Connecting a subdatasheet MULTIPLE TABLE QUERIES * Deciding which tables to use * Adding tables to the query * Creating links between tables * Setting join properties ADVANCED FORM DESIGN * Field properties * Creating lookup fields * Adding calculated fields * Applying conditional formatting ADVANCED REPORT DESIGN * Field properties * Report properties * Alternate colour bandings * Concatenating fields * Adding calculated fields * Sorting and grouping * Grouping settings * Adding headers and footers * Adding dates, times, page numbers

Discover the powerful schedule and cost risk analysis features of PRA. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 2 days (13 hours) Our Primavera Risk Analysis course gives a detailed introduction to the schedule and risk analysis features of Primavera Risk Analysis. It shows the powerful features of the tool and give hands on practice throughout the course to ensure you can confidentially put your new skills into practice back in the workplace. This course is designed for new users of Primavera Risk Analysis, and no previous experience is required. You should however be familiar with risk management processes and terminology. OBJECTIVES  By the end of the course you will be able to: * Import schedules into PRA * Add three point estimates onto plans * Perform schedule and cost analysis * Use templated quick risk * Run risk analysis * Interpret results from the Risk Histogram and Tornado graph * Add task percentiles to a Gantt chart * Set up a risk register * Add qualitative and quantitative risks * Link risk to activities in the plan * Create reports * Use the Distribution Analyser CONTENT Importing schedules * Importing MSP and Primavera Schedules * Running import checks * Checking schedule integrity SCHEDULE RISK ANALYSIS * 3 point estimating * Entering uncertainly * Different distributions * Using quick risk * Updating plan * Importing plans with 3 point estimates COST/RESOURCE UNCERTAINTY  * Resource loadings * Creating 3 point cost estimates * Resource distributions and escalations * Simple cost estimates TEMPLATED QUICK RISK * Setting up and applying templated quick risk * Assessing risk at WBS level RUNNING RISK ANALYSIS * Running risk analysis * Interpreting results on the Risk Histogram * Setting analysis options TASK PERCENTILES * Setting task percentile options * Including task percentiles on the Gantt chart TORNADO GRAPH * Creating a Tornado graph * Viewing sensitivity * Analysing sensitivity against activities SETTING UP THE RISK REGISTER * Setting Schema levels * Defining criteria and tolerances * Setting up a Risk Breakdown Structure (RBS) * Working with manageability and proximity * Saving scoring matrices * Adding custom fields EXPORTING DATA * Exporting to Excel, Word and PowerPoint QUALITIVE RISKS * Setting risk IDs * Adding risk cause, description and effect * Setting up risk details * Entering mitigation actions QUANTITATIVE RISKS * Linking risks to activities * Adding schedule and cost impacts * Defining how multiple risks impact * Correlation MIGRATING YOUR PLAN * Adding mitigation actions to your plan as tasks * Linking tasks to mitigation actions ACTIONING YOUR RISK REGISTER * Progressing risks * Importing progressed plans * Linking register to progressed plans * Risk history * The Waterfall chart SAVING AND REPORTING * Exporting the risk register * Running reports * Creating new reports BUILDING AND COMPARING RISK PLANS * Using the distribution analyser * Comparing dates and cost

Expand your VBA knowledge further and learn some of the more advanced coding features. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 [https://www.underscore-group.com/training/training-courses/technical-and-office-programs/vba-in-excel/] course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models OBJECTIVES  By the end of the course you will be able to: * Use comparison operators and system functions * Use Arrays * Work with ranges * Work with the worksheets and workbooks collections and objects * Use application objects * Use the FileSystemObject * Create function procedures * Import and save text files * Connect to other applications CONTENT COMPARISON OPERATORS   * Using Comparison operators and functions * The LIKE function * Wildcards * Using SELECT Case SYSTEM FUNCTIONS   * The VAL function * Case functions * Trim functions * Text functions * Date functions EXCEL WORKSHEET FUNCTIONS   * Using Excel functions in VBA ARRAYS   * Creating arrays * Using arrays * Ubound and Lbound * Single and multi dimensional arrays * Static vs dynamic arrays WORKING WITH RANGES   * Creating range objects * Passing data between range objects and arrays * Using Transpose THE EXCEL OBJECT MODEL   * The object browser WORKING WITH COLLECTIONS   * Collections * Creating object variables * Setting object variables * The For Each . . . Next Loo SHEET COLLECTIONS   * The worksheets collection * The worksheet object * The sheets collection * Using object * Grouping worksheets * Using Typename THE WORKBOOK COLLECTION   * The workbooks collection * Setting workbook variables APPLICATION OBJECTS   * Excel default information * Display/alerts * Screen updating * Status bar * On Time * Using Wait SYSTEMS DIALOG BOXES   * Showing dialog boxes * Using dialog boxes WORKING WITH FILES   * Searching for files and folders * The DIR function * The FileSystemObject FUNCTION PROCEDURES   * Creating functions * Adding arguments * Calling functions WORKING WITH TEXT FILES   * Searching for files and folders * The DIR function * The FileSystemObject * Using the FILE and FOLDER collections SHARING DATA WITH OTHER APPLICATIONS   * Early vs Late Binding * Setting references to other applications * Creating application variables * Setting application variables

Learn how to use this powerful tool to import and clean data and create some amazing visuals. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 2 days (13 hours) Power BI Desktop is a powerful tool for working with your data.  It enables you to import multiple data sources and create effective visualisations and reports. This course is an introduction to Power BI to get you started on creating a powerful reporting capability. You should have a good working knowledge of Excel and managing data before attending. OBJECTIVES  By the end of the course you will be able to: * Import data from multiple data sources * Edit and transform data before importing * Create reports * Create different visualisations * Create data models * Build data relationships * Use the drill down features * Create measures * Use the Power BI Service * Build dashboards * Use the mobile app CONTENT ESSENTIALS Importing Data * Power BI Overview * Data sources * Importing data Transforming Your Data * Editing your data * Setting data types * Removing columns/rows * Choosing columns to keep * Setting header rows * Splitting columns Creating Reports * Creating and saving reports * Adding pages * Renaming pages * Interactivity * Refreshing your data Adding Columns * Columns from example * Custom columns * Conditional columns Append Queries * Importing folders * Setting up and using append queries Creating Chart Visualisations * Adding chart elements * Choosing chart types * Setting properties * Setting values, axis and legends * Using tooltips * Visual filters * Setting page and report filters Creating Tables, Cards, Gauges and Maps * Adding table elements * Adding maps * Working with cards * Working with matrices * KPIs and Gauges Conditional Formatting * Setting rules * Removing conditional formatting   WORKING WITH DATA MODELS Merge Queries * Setting up and using merge queries * Merging in columns of data Creating a Data Model * The data model * Multiple data tables * Connecting tables * Building relationships * Relationship types * Building visuals from multiple tables Unpivoting Data * Working with summary data * Unpivoting data Using Hierarchies * Using built in hierarchies * Drill down * Drill up * See next level * Expand a hierarchy * Create a new hierarchy Grouping * Grouping text fields * Grouping date and number fields Creating Measures * DAX functions * DAX syntax * Creating a new measure * Using quick measures Using the PowerBI Service * Shared workspaces * My workspace * Dashboards * Reports * Datasets * Drill down in dashboards * Focus mode * Using Q&A * Refreshing data * Using Quick Insights Power BI Mobile App * Using the Power BI Mobile App