7 Courses in Bradford

Face to face One to one.

This course is for anyone wishing to understand their strengths and development areas and those who are seeking assistance to progress their careers and convey their abilities confidently.

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

BECOME A TRUE POWER USER WITH THIS INTRO TO MACROS. ON-SITE TRAINING AT YOUR OFFICES – CONVENIENT & COST-EFFECTIVE. SUMMARY Study method Classroom Duration 1 day · Part-time or full-time Qualification No formal qualification Certificates * Certificate of Completion - Free Additional info * Tutor is available to students --------------------------------------------------------------------------------  6 students enquired about this course LOCATION & DATES Location BRADFORD, BD17 7TD [https://www.reed.co.uk/courses/microsoft-excel-level-4-macros-and-visual-basic-onsite-online/191137#moreInfo0] LEEDS, LS1 4PR [https://www.reed.co.uk/courses/microsoft-excel-level-4-macros-and-visual-basic-onsite-online/191137#moreInfo1] OVERVIEW Become a true Excel spreadsheet power user with this introduction to macros and Visual Basic. ‘Hands-on’ training that will enable you to automate repetitive tasks and customize the Excel environment. Gain confidence and develop skills that can be transferred immediately to the workplace. Convenient and cost-effective training at your offices or online. The course is run by an experienced Data Analyst and Microsoft Master Instructor. Each participant will receive a manual and completion certificate. CERTIFICATES CERTIFICATE OF COMPLETION Digital certificate - Included DESCRIPTION This one day course has an emphasis on developing practical, real-world skills. It is suitable for people in any type of business. Topics covered: * Configure macro security settings * The Macro Recorder * Record workbook macros for cell operations * Run a workbook macro * Display macro instructions * Edit a workbook macro * Add a macro button to a worksheet * Record personal macros to automate workbooks * Run a personal macro * Edit a personal macro * Include relative cell references in a macro * Add a macro button to the Ribbon * Create macros using the Visual Basic Editor * Create a user-defined function * Respond to user input * Create a user form * Debug a macro * Using ChatGPT WHO IS THIS COURSE FOR? This course is for people who wish to become skilled at automating repetitive tasks with Microsoft Excel. It also provides an introduction to Microsoft Excel programming with Visual Basic. REQUIREMENTS Microsoft Excel Level 3 or advanced level skills. CAREER PATH Microsoft Office Specialist (MOS) Excel.

GAIN CONFIDENCE AND DEVELOP PRACTICAL SKILLS IN EXCEL. ONSITE TRAINING AT YOUR OFFICES – CONVENIENT & COST-EFFECTIVE. SUMMARY Study method Classroom Duration 1 day · Part-time or full-time Qualification No formal qualification Certificates * Certificate of Completion - Free Additional info * Tutor is available to students --------------------------------------------------------------------------------  26 students enquired about this course LOCATION & DATES Location BRADFORD, BD17 7TD [https://www.reed.co.uk/courses/microsoft-excel-level-1-worksheet-fundamentals-onsite-online/191143#moreInfo0] LEEDS, LS1 4PR [https://www.reed.co.uk/courses/microsoft-excel-level-1-worksheet-fundamentals-onsite-online/191143#moreInfo1] OVERVIEW Solid Excel spreadsheet skills are essential in today’s business world. Learn the basics of Excel spreadsheets with this comprehensive introductory course. Gain confidence and develop skills that can be transferred immediately to the workplace with this ‘hands-on’ training. Convenient and cost-effective training at your offices or online. The course is run by an experienced Data Analyst and Microsoft Master Instructor. Each participant will receive a manual and completion certificate. CERTIFICATES CERTIFICATE OF COMPLETION Digital certificate - Included DESCRIPTION This one day course will give you a solid foundation, with an emphasis on developing practical, real-world skills. It is suitable for people in any type of business. Topics covered: * Excel Application window * Enter labels and values into a worksheet * Enter a formula into a worksheet * Adjust column width and row height in a worksheet * Open a new workbook * Use the Spelling Checker * Use an Excel template to create a workbook * Automatically fill a range * Copy and move cells * Automatically compute a row or column total * Insert and delete rows and columns * Realign cell entries * Reset font options for cell entries * Reset the number format of cell entries * Add borders and shading to a worksheet * Sort the records of a list * Filter the records of a list * Excel Tables * Insert comments into a worksheet * Split the Worksheet window into panes * Freeze the Worksheet window * Hide rows and columns of a worksheet * Change the page setup for a worksheet * Preview a worksheet * Insert a manual page break into a worksheet * Print selected worksheet entries * Use Excel functions (SUM, AVERAGE, MAX, MIN and COUNT) WHO IS THIS COURSE FOR? This course is suitable for anyone who wishes to learn Microsoft Excel or become more proficient in the program. REQUIREMENTS Basic keyboard and mouse skills. No prior knowledge of Microsoft Excel is required. CAREER PATH Microsoft Office Specialist (MOS) Excel.

LEARN HOW TO MANAGE & PRESENT YOUR DATA EFFECTIVELY. ON-SITE TRAINING AT YOUR OFFICES – CONVENIENT & COST-EFFECTIVE. SUMMARY Study method Classroom Duration 1 day · Part-time or full-time Qualification No formal qualification Certificates * Certificate of Completion - Free Additional info * Tutor is available to students --------------------------------------------------------------------------------  16 students enquired about this course LOCATION & DATES Location BRADFORD, BD17 7TD [https://www.reed.co.uk/courses/microsoft-excel-level-2-managing-data-onsite-online/191126#moreInfo0] LEEDS, LS1 4PR [https://www.reed.co.uk/courses/microsoft-excel-level-2-managing-data-onsite-online/191126#moreInfo1] OVERVIEW Master popular Excel spreadsheet functions. Learn how to manage your data efficiently and present it effectively using Excel's visualization tools. ‘Hands-on’ training. Gain confidence and develop skills that can be transferred immediately to the workplace. Convenient and cost-effective training at your offices or online. The course is run by an experienced Data Analyst and Microsoft Master Instructor. Each participant will receive a manual and completion certificate. CERTIFICATES CERTIFICATE OF COMPLETION Digital certificate - Included DESCRIPTION This one day course has an emphasis on developing practical, real-world skills. It is suitable for people in any type of business. Topics covered: * Find and replace a specific entry in a worksheet * Create and apply a style * Apply conditional formatting to a worksheet * Use options in the Paste Special dialog box * Use alignment options in the Format Cells dialog box * Enter an absolute cell reference into a formula * Use the IF, SUMIF and COUNTIF functions * Use the PMT and FV functions * Use the DATE and NOW functions * Plot a chart * Modify and enhance a chart * Insert Sparklines * Insert a new worksheet in a workbook * Delete a worksheet from a workbook * Enter a formula to link related worksheets in a workbook * Format multiple worksheets in one operation * Use the VLOOKUP and XLOOKUP functions * Create a new workbook template * Insert a diagram into a worksheet * Insert a hyperlink into a worksheet * Linking Excel to other applications WHO IS THIS COURSE FOR? This course is for people who wish to become skilled at managing and presenting data in Microsoft Excel. REQUIREMENTS Microsoft Excel Level 1 or introductory level skills. CAREER PATH Microsoft Office Specialist (MOS) Excel.

MAXIMIZE YOUR DATA & GAIN VALUABLE INSIGHTS. ON-SITE TRAINING AT YOUR OFFICES – CONVENIENT & COST-EFFECTIVE. SUMMARY Study method Classroom Duration 1 day · Part-time or full-time Qualification No formal qualification Certificates * Certificate of Completion - Free Additional info * Tutor is available to students --------------------------------------------------------------------------------  4 students enquired about this course LOCATION & DATES Location BRADFORD, BD17 7TD [https://www.reed.co.uk/courses/microsoft-excel-level-3-analysing-data-onsite-online/191132#moreInfo0] LEEDS, LS1 4PR [https://www.reed.co.uk/courses/microsoft-excel-level-3-analysing-data-onsite-online/191132#moreInfo1] OVERVIEW Spot patterns and trends in Excel spreadsheets. Analyse your data and gain an insight into Excel's powerful business intelligence features. Also covers Excel's security features. ‘Hands-on’ training. Gain confidence and develop skills that can be transferred immediately to the workplace. Convenient and cost-effective training at your offices or online. The course is run by an experienced Data Analyst and Microsoft Master Instructor. Each participant will receive a manual and completion certificate. CERTIFICATES CERTIFICATE OF COMPLETION Digital certificate - Included COURSE MEDIA https://resources.reed.co.uk/courses/coursemedia/191132/48dd72dc-08af-44e8-bff0-c0599dbaf7bf.png DESCRIPTION This one day course has an emphasis on developing practical, real-world skills. It is suitable for people in any type of business. Topics covered: * Restrict cell entries to specific numbers, dates or times * Restrict cell entries to specific entries in a list * Create a custom number format * Define a range name * Use a range name in a formula * INDEX and MATCH vs XLOOKUP * Use the DSUM and DAVERAGE functions * Trace precedents in a worksheet * Trace dependents in a worksheet * Trace errors in a worksheet * Watch and evaluate formulas in a worksheet * Consolidate data from multiple workbooks * Add subtotals to worksheet data * Group and outline data * Create a PivotTable report * Reset the summary function in a PivotTable report * Create a PivotChart report and Dashboard * Perform data analysis using scenarios * Import data into Excel * Export Excel data to other applications * Use the Data Consolidation feature * Protecting Excel files, workbooks and worksheets WHO IS THIS COURSE FOR? This course is for people who wish to become skilled at analysing data in Microsoft Excel and are also interested in Excel’s business intelligence features. REQUIREMENTS Microsoft Excel Level 2 or intermediate level skills. CAREER PATH Microsoft Office Specialist (MOS) Excel.