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: Project Online Premium, MS Excel, Resource Leveling...

...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 365, Microsoft Apps, Teams training...

...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: Planning methods, Text Styles, Microsoft Project...

...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, Microsoft excel training, Excel Formula...

...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: MS Excel, Pivot charts, Data analysis...

...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 for Accounting, Microsoft Office, Excel 2016...

...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: Process Improvement, MS Excel, Microsoft excel training...

...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: Excel Programming, MS Excel, Excel 2013...

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