PC Applications training

...Conditional Functions & Formats and Date Calculations Benefits and purpose If Statements , Nested If And, Or, Not Combining If, And, Or, Not Sumif... Learn about: MS Excel...

...It may be especially useful to Sage users who currently export data out of Sage software and into Excel. Important Note: although this course uses...

...teach you how to make the most of planning and managing projects using Microsoft Project, building on your existing skills and teaching you to make... Learn about: IT Project Management, Microsoft Project, Project Management...

...Channels Create a new Channel Starting a conversation Replying Add fun elements - emotions, gifs and stickers Add files for sharing Using @ Mentions Adding... Learn about: Microsoft Teams Training, Office 365, Microsoft Collaboration...

...Fairly experienced Excel 2007 users whom need to learn more complex functions, nesting, data manipulation and automation using basic macros. Course Contents... Learn about: MS Excel...

...to creating templates and using macros. Suitable for: This one day course is aimed at anyone who wishes to utilise the more advanced features within the Excel program...

...such as Excel and Word, so it is a popular choice for many businesses. For example, many of the views available are similar to an Excel spreadsheet... Learn about: MS Excel, Formatting Text & Text Styles, Assign Resources to Tasks...

...functions, ranges, sorts, filters and formatting commands. This Course Covers: Formulae and Functions Using Absolute Cell References ‘Insert’ Function...

...Window Code Window Properties Window Navigating between Excel and the VB Editor Editing Code + Methods of Executing Using the Visual Basic Editor Structure... Learn about: MS Excel...

...gained by combining the built-in features of Excel with the programming capabilities of Visual Basic for Applications (VBA). Visual Basic For Applications... Learn about: Microsoft excel training, Microsoft Office, Visual Basic...

...Driven Scheduling and Task Types Resources Resource Calendar Resources Controlling when a Resource starts work on a Task Assigning Costs to Tasks and Resources...

...demand forecasting, - sample size determination The curriculum is delivered using practical case studies. For students, graduates, engineers... Learn about: Microsoft Excel, Statistical analysis, Microsoft excel training...

...Windows , Toolbar , Menus, Task Pane Learn While You Work, Map, Traditional Help System Entering and Linking Tasks Entering Tasks, Setting Durations and Milestones Linking...

...perform calculations, modify a worksheet, format a worksheet, print a workbook and manage workbooks. This is a beginners course and is suitable for someone... Learn about: Excel 2016, Excel 365, Excel Formula...

...Time Management Create and manage folders Out of Office Assistant Meetings, appointments and events Schedule a meeting Notes, Tasks and Journals Tasks—...

...Graphical analysis, process optimisation techniques. Dates will be arranged on request. We are happy to run with small class sizes. Participants are expected... Learn about: MS Excel, Statistical analysis, Process mapping...

...Objects to Tasks or Dates Showing / Hiding Embedded Objects Adding Hyperlinks Internal Hyperlinks Links to Word Bookmarks Links to Excel Range Names Hyperlink...

...create user-interactive macros, work with multiple worksheets, and perform calculations. This course will appeal to students looking to gain the skills... Learn about: Visual Basic training, Microsoft Excel, Microsoft excel training...

...want to learn more about the colour correction and grading capabilities of Color 101. This Apple-certified three-day hands-on course will familiarize you with Color...

...This course is suitable for anyone who already has basic IT skills, however our friendly Centre staff will help you identify whether this course or...