Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included
Business Writing 1 Day Workshop in Bromley
Course Objectives At the end of this course you will be able to: Identify the components of the PowerPoint interface Create slides Format text on slides Add and modify graphical objects to a presentation Work with tables in a presentation Add charts to a presentation Prepare the SlideShow '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Very patient Trainer. Happy to adapt course + help with problems on existing presentations. Andrea Lethbridge - CNN ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Getting Started with PowerPoint Identify the Components of the PowerPoint Interface Create a PowerPoint Presentation Accessing Help Choose the right view for the task in PowerPoint Normal view Slide Sorter view Notes Page view Outline view Add, rearrange, and delete slides in PowerPoint Working with Themes Add colour and design to my slides with themes Remove the current slide design (theme) Slide Layout What is a slide layout? Apply or change a slide layout Working with text Add text to a slide Create a new text box Format text Tables Add a table to a slide Format a Table Copy and paste a table from Word Insert an Excel spreadsheet within PowerPoint Edit Cells, Rows and Columns Delete a table Graphics Working with Clipart, and Shapes Selecting objects, shapes, pictures or text boxes Arrange a picture, shape or other object Adding Charts to Your Presentation Create a Chart Format a Chart Insert a Chart from Microsoft Excel Inserting date and slide numbers Add slide numbers to your presentation Hide slide numbers on the title slide Change where the page numbers appear on your slides Start your slide numbering with a specific number Print slides, notes, or handouts Create the Slide Show Record your slide show Preview the recorded slide show Turn slide timings off Set the slide timings manually Add or remove transitions between slides Add Animations to Text and Objects Deliver the Presentation Speakers notes Add speaker notes to your slides View your speaker notes as you deliver your slide show Who is this course for? Who is this course for? This course is designed for end users who are interested in learning the fundamentals needed to create and modify engaging presentations. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included
This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing
Commission an original, traditional and quirky Portrait in oils, acrylics or digital sketches
“You don't take a photograph. You make it" - Ansel Adams Photography For Parents - Editing In Lightroom Next course starts 11 March 2024 Editing is an essential skill for anyone with even just a passing interest in photography. Much as we try, we can't always get everything right in camera and editing tools help us bring our vision to life, help correct problems and allow our images to look beautifully polished. We teach how to do all these things in Adobe Lightroom because it's a powerful, intuitive and affordable tool used by Pros around the world for that very reason. KEY COURSE INFO: Course type: Instructor-led Course duration: 4 weeks + prep module Course format: Online course with interactive edit-along live classes, feedback on your learning and support group WHAT YOU LEARN: From being able to correct issues such as over/under exposure, issues with colour or graininess to bringing your vision to life, creating mood and tone to your images, knowing how to use editing software is a must. But good and purposeful editing goes way beyond just slapping on a preset or a filter - in our course we teach you all about the tools - not just what all of them do but how, and we teach you how to know what to use and when to achieve certain effects.everything you need to allow you to style your photos, confidently use the software and fix common problems. editing to correct common photo problems creating good editing workflow using powerful precision tools editing to achieve beautiful skin tones using light and colour creatively editing to bring out a mood of a feel THIS IS THE COURSE FOR YOU IF : Love taking photos but want them to look more polished - with colours that pop and light that's perfectly balanced You want to be able to fix common issues such as under- or overexposure, white balance or colour casts so that you never need to bin an image just because it wasn't right straight out of camera You want to get more creative with light and colour to make the images look just like the moment felt. Bring on the moody edits or sun soaked edits or light kissed skin tones or creative black and white conversions You want to confidently use the editing techniques so you can bring your vision to life every time, without guesswork You want to be able to prepare your images for print so that your walls can beam with pride at the beauty that you captured Next Editing in Lightroom course starts 11 March 2024 4 core course modules plus prep module Support Facebook group Weekly edit-along live webinar Practice files to learn on Feedback on your images HERE IS WHAT YOU WILL LEARN in this course : Our Photo Editing in Lightroom course guides you through the photo editing process in Adobe Lightroom from start to finish – from setting it up correctly, organising your collections and creating a workflow that works for you, through learning the capabilities of all the editing tools - such as adjusting exposure, colours, light or sharpening the images; all the way to printing and creating photo books. We’ll show you how to create specific artistic effects ( high impact Black and white, vintage, light and airy, dark and moody etc ), and how to fix common photography problems ( grainy images, underexposed images, wrong colours etc). At the end of the course you will be able to confidently manage your photo collection with Lightroom, achieve desired artistic effects and make your photos truly stand out. Getting around in Lightroom and Lightroom Classic - shooting in full manual - but with clarity and purpose Correcting common problems - whether your photo started too dark or too bright, your child's face was in a shade, the white balance and colours were off, the grain was heavy, the light looked dull - you can fix it all within a couple of clicks in Lightroom Using Lightroom's super powerful intelligent masking tools to quickly and efficiently edit specific parts of your image - from brightening up the eyes to rescuing overblown skies Enhancing and adding beautiful light - light makes images stand out, but it can be hard capturing the atmosphere it creates in camera at times. Lightroom is where you can bring light to life and make your images feel how what you saw in real life Knowing how to shoot in camera so you can get the most in editing - photographers will often purposefully under or overexpose images in camera so that they have more chance of balancing the image just they way they want in Lightroom. INSIDE THE MODULES - aka WHAT DO YOU LEARN? Module 0: Getting set up in Lightroom This module is released a week before the course starts to give you a chance to fully familiarise yourself with the layout, structure and the best way of working in Lightroom Classic, including guidance of creating a smooth selection and culling process that helps you see and keep the best of your images, without getting bogged down with 100s near duplicates. Module 1: Getting Started In Lightroom - Global Edits In this module we introduce you to Lightroom's most powerful tools - the global edits. We help you understand how to tweak your images to achieve the effects you're after quickly - from adjusting over and under exposure, to correcting white balance in a few different ways, to having a play with my favourite Lightroom tool - the tone curve. Major Takeaways: At the end of the module you will have gained full control of lightroom key global tools and will be able to use them to correct any global - as in affecting the whole image - issues with your images. This includes perfecting your exposure, balancing your colour and white balance, sharpening and creating clarity and more. Module 2: Targeted Edits - Masks! Lightroom allows us to apply edits to selected parts of the image through a range of its very powerful, intelligent and manual masks. This means you can now effortlessly select your subject from the photo to adjust them separately with just one click, you can pick only the sky, the subject's eyes or only colour green or any other element and treat them differently to the rest. Major Takeaways: You will be able to use the full range of masks in lightroom and apply your edits exactly where they are needed, and nowhere else. This includes working with with the new AI powered masks which can detect a person's individual features and allow you to selectively edit them in a few simple steps, as well as those more manual tools, that allow you to literally paint with light and colour on your photographs. Module 3: Creative Editing in Lightroom This is a brand new module in our course where we take all the tools introduced in Modules 1 and 2 and actually use them to achieve different effects on our photos. Wer show you how to be guided by light when editing, how to achieve a light and airy or a moody edit on your images, how to add light and how to convert to black and white, as well as how to edit skin in Lightroom! This module is all play! Major Takeaways: You will learn how to create yoru own editing process - from knowing where to start and to understanding what elements of your photograph may need or benefit from adjusting and knowing how you can do so to achieve different outcomes. You will also learn how to edit your skin tones so they look delightful - no matter what your subject's complexion. Module 4: After the edits We close the course with a module centered around all the things you might want to do after the edits - from preparation for print, creating photo books, but also sharing your images online and syncing them between different machines and adobe workplaces. PLUS there is a little Photoshop intro so you get a glimpse at how it's different and what it can do. Major Takeaways: You will learn how to connect all of your Adobe ecosystem and sync and share your images across multiple devices. You will learn how to prepare your images for print so they look their very best and how to create photobooks. Next course starts 11 March 2024 Absolutely, without a doubt book Editing. I was very unsure at first. My interest in photography is to capture those memories so it felt like it was 'cheating' to edit. I can honestly say it's like magic.To finish off the pictures you love and just give you complete control over the exposure, colours to make them perfect, to rescue the disasters etc. I learnt so much in those few weeks and it made the biggest difference to my photos. Kerry White Editing in LIGHTROOM Book your space now: COURSE STARTS : 11 March 2024 ( 4 weeks + 1 prep week)COURSE COST : £179 ( payment plans available ) What’s included: 4 weekly modules with step by step illustrated tutorials and videos + prep module weekly edit along class online class ( also recorded) - on Wednesday evenings feedback and advice on your edits private support group PDF workbook and downloadable videos Practice images to learn on Join our next group to really bring life to your images and make them look sleep, polished and full of light COURSE PREREQUISITES: Lightroom or Lightroom Classic CC software installed on your computer or tablet. RECOMENDED : Lightroom Photography Plan 25GB – a monthly subscription at approx £9pm – including Lightroom CC, Lightroom Classic CC and Photoshop. This plan can also be occasionally purchased at a lower price via Amazon or Groupon if you purchase a year’s worth of subscription in one go ( average savings – around 2-4 months worth depending on the deal) Please note that Adobe also has a Lightroom Plan with 1TB of storage – we do not recommend this plan as it restricts you to one version of software only. The increased Cloud storage can always be purchased as an add on or your plan can be switched from Photographer plan to CC only at a later stage if you prefer.
Price £750 inc VAT Finance options In Company training - £750 for groups of up to 8 delegates. Discounts for Nonprofits/Charities... Study method On-site Duration 2 days, Full-time Qualification No formal qualification Certificates Certificate of completion - Free Additional info Tutor is available to students Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Description Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements General knowledge of the Windows OS Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills
This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print
COBOL training course description A hands on training course providing an introduction to COBOL. What will you learn Write COBOL programs Debug COBOL programs Examine existing code and determine its function. COBOL training course details Who will benefit: Programmers working with COBOL. Prerequisites: None although experience in another high level language would be useful. A 10 day version of this course would be more applicable for those new to programming. Duration 5 days COBOL training course contents Introduction to COBOL Compilation, linkage editor. Compile errors, compiler options. Divisions, syntax and format, COBOL character set, program structure. COBOL statement structure COBOL words, format of statements. Divisions Identification entries, Environment entries, Data division: FD, record descriptions, hierarchy and level numbers, description-string entry. File and Working-Storage Sections Literals, figurative constants, redefines clause, data representation, Usage clause, synchronization, sign clause. Procedure Division File status codes; Open, Read, Write, Close, Stop, Goback; Accept, display; Move, Justified, data name qualification, reference modification. Perform statement Out-of-line, With test ... Until, ... Times, in-line statement; Go to statement. Program design Design techniques, design considerations, procedure names, program structure. Printing Printed output, Write, advancing option, editing characters; Initialize. Condition testing Conditional statements: IF, class, sign and relation conditions, condition-name conditionals, Set, compound conditions, logical operators. Evaluate, Continue. Arithmetic Rounded option, On Size Error option, Add, Subtract, Multiply, Divide, Compute. Non-sequential files File access modes, Select. Indexed and relative files. Open, Close, creating / reading sequential access files, Write, Read, Invalid key clause, reading, writing / updating Random access files, Rewrite, Delete, Start. Declarative routines Clauses. Subroutines Call, Using clause - calling program/called program, Linkage Section, returning control. Table handling Subscripted tables: One/two/three dimensional tables, Perform, variable length tables. Indexed tables: Set, using an index; Search. Copy code: Copy, Suppress, Replacing. Data Manipulation Inspect, String, Unstring. COBOL/370 LE/370 and Intrinsic Functions.