3412 Office Skills & Productivity courses in Killamarsh delivered Online

Learn how to use OneNote to create, organize and populate electronic notebooks. Course overview Duration: 4 hours OneNote is a digital notebook and can be a great way to easily take notes. Whether for meetings, on training courses or to help with to do lists. It works very much like it’s paper copy equivalent but, of course, with lots of enhanced features. Its integration with Outlook and the other office applications means you can easily take notes and link them to documents meeting details and then email them out. You can even add audio and video notes as reminders. Objectives  By the end of the course you will be able to: Create and manage notebooks Add contents Tag and prioritise content Create notes from other applications Create To Do Lists and integrate into Outlook Content Using OneNote Creating notebooks Creating sections and pages Formatting pages Using page templates Creating page templates Reordering sections and pages Deleting sections and pages Creating OneNote content Adding text Bullet lists Adding tables Adding images Adding drawings Adding links Adding audio and video notes Tagging Tagging Creating custom tags Creating to-do lists Searching and filtering for tags Notes Creating quick notes Filtering them in OneNote notebooks Linked notes Outlook integration Linking to tasks in Outlook Flagging notes for follow up Inserting Outlook meeting content Taking minutes Emailing OneNote pages Send emails to OneNote

We use it everyday but there are so many additional tools to save you time and make your work in Outlook more efficient and less stressful. Course overview Duration: 4 hours People tend to think they know how to use Outlook however there are so many lesser known features that can make working in Outlook so much more efficient. Simply understanding the layouts, how to turn things on and off and customising the environment to your preferences can save time and frustration. You then have search features, things such as conversation clean up and quick steps that can help to tidy up and organise what you do. Objectives  By the end of the course you will be able to: Customise Outlook to your preferences Manage email conversations Setup and use Quick Steps Create folders and organise information Setup rules Search for information Work effectively with calendars Content Customising the user interface Using the Navigation Pane and “To-do Bar” Setting folder pane options Adding favourites Peak preview Customising the quick access bar Setting reading pane and message preview Customizing email mail views Using the field chooser Email options Email conversations Conversation clean up Using Quick Steps Creating folders and organising information Setting email options Setting up rules Searching for information Using the Search bar Setting what to search for Setting where to search Searching for categories Adding more search options Working with calendars Setting what to view Using Schedule View Setting calendar options Weather bar Adding different time zones Adding meetings and appointments Setting up and using categories Opening other people’s calendars Setting calendar permissions Calendar groups Working with Tasks Lists Setting task options Adding and amending tasks Setting dates, deadlines and reminders Adding attachments to tasks Assigning tasks to others Flagging tasks Using and setting Quick Click Recurring tasks Flagging emails to appear on your task list Converting emails to tasks Converting tasks to calendar appointments

Discover the amazing features this tool has to offer in combining, collating and editing documents and the forms, markups and redaction techniques available. Duration 1 day (6.5 hours) Overview This Adobe Acrobat course looks at the powerful features of the tool quite often overlooked.  The course requires the use of either the Standard or Professional versions of Acrobat as the free Acrobat Reader only has limited functionality. Learn how to combine documents into a single file, edit and mark up PDFs, compare documents, redact data from documents and create fillable forms. Objectives  By the end of the course you will be able to: Create PDFs from other tools Set security Collate and combine files into a single PDF Edit PDF files Complete and sign documents Create fillable forms Mark up PDF documents Compare files Redact data Content Creating PDFs Building PDF documents from Word, Excel and PowerPoint Setting PDF options for print, image quality and security Working in Acrobat Home, Tools and Document Views Using the Navigation Panel and Pane Floating toolbar and Contextual menus Collating and Combining Files Combining multiple files into a single PDF Adding extra files Deleting pages and reorganising pages Editing Files Editing text and graphics Adding text and images Adding headers and footers, watermarks and backgrounds Adding Links Adding manual links Automatic links Completing and signing documents Using fill and sign to complete forms Adding signatures Creating Fillable and Signable Forms Prepare a form Autodetect fillable fields Add manual fillable fields Adding drop downs, check boxes, etc. Naming fields Setting field properties Previewing the form Marking Up Documents Marking up changes Using sticky notes Using the highlighter pen Adding stamps Attaching documents and audio Replying to comments Comparing Files Selecting settings Comparison report Reviewing differences Using the changes pane Redacting Data (Acrobat Professional only) Setting redaction options Redacting chosen text Searching and redacting words, phrases or patterns Redacting whole pages Applying redaction

This is an essential programme for any member of staff whose role requires a high level of attention to detail. The focus is specifically on the handling of text and data, whether at the input stage or when collating information into reports and documents for use by others. The session looks at both prevention and cure. For 'prevention', it focuses on understanding how common errors occur and on developing an awareness of the factors which influence our level of attentiveness. It introduces key psychological theories around attentiveness including the 'capacity' and 'bottleneck filter' models. And it looks at how working styles can affect attention to detail. For 'cure', the programme looks at how to minimise the effect of stress on concentration as well as introducing a number of tools and techniques for promoting accuracy - at both the input and the checking stages. Particular attention is paid to proof-reading techniques. By the end of the session, participants will: Appreciate why errors occur Understand how stress and other factors can affect focus and accuracy Know how to improve accuracy and reduce errors when handling text and data Be able to proof-read text and number-based documents more accurately 1 The importance of accuracy The impact of mistakes Why accuracy is so important Main reasons why errors occur 2 Attentiveness theory The 'capacity' and 'bottleneck filter' models Selective attention Chunking - big picture / little picture 3 Preparing for accuracy Working styles - how they affect detail-orientation Identifying and minimising the impact of stress on concentration 4 Practical strategies How to improve accuracy and reduce errors when inputting text Managing interruptions and distractions Proofing text and numbers

Data Done Right - The Value of Good Communication Wouldn't it be great if you could see important textual and graphical information quickly and easily? What if it could be updated automatically or by using a simple refresh? What if you could easily change that information as needed, or see it right now with tools you already have, on multiple devices? In this presentation we will show you all of those things. You'll see reports that are produced in MS Project and MS Excel, graphical reports in Visio, and a dashboard that uses all of these tools. And we'll top it off with a discussion about what information to present and not present. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Data Done Right - The Value of Good Communication Wouldn't it be great if you could see important textual and graphical information quickly and easily? What if it could be updated automatically or by using a simple refresh? What if you could easily change that information as needed, or see it right now with tools you already have, on multiple devices? In this presentation we will show you all of those things. You'll see reports that are produced in MS Project and MS Excel, graphical reports in Visio, and a dashboard that uses all of these tools. And we'll top it off with a discussion about what information to present and not present. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Overview This comprehensive course on Data Entry Administrator will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Data Entry Administrator comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Data Entry Administrator . It is available to all students, of all academic backgrounds. Requirements Our Data Entry Administrator is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 1 sections • 7 lectures • 01:44:00 total length •Introduction to Data Entry: 00:08:00 •Using the Computer for Data Entry: 00:08:00 •Common Rules and Guidelines for Data Entry: 00:16:00 •Using Excel for Efficient Data Entry: 00:10:00 •Using Excel's Flash Fill and Autofill to Automate Data Entry: 00:13:00 •How to Create a Data Entry Form in Excel?: 00:33:00 •Using Statistics Packages in Data Entry: 00:16:00

Overview This comprehensive course on Excel Data Analysis for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Data Analysis for Beginner comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel Data Analysis for Beginner. It is available to all students, of all academic backgrounds. Requirements Our Excel Data Analysis for Beginner is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 3 sections • 11 lectures • 01:11:00 total length •Tracing Formulas: 00:04:00 •Using the Scenario Manager: 00:07:00 •Goal Seek: 00:03:00 •Solver: 00:03:00 •Data Tables: 00:11:00 •Data Analysis Tools: 00:16:00 •Forecast Sheet: 00:02:00 •Sumif, Countif,Averageif, Sumifs, and Countifs formulas: 00:09:00 •If, And, Or, and Nested If formulas: 00:16:00 •Resource - Excel Data Analysis for Beginner: 00:00:00 •Assignment - Excel Data Analysis for Beginner: 00:00:00

Overview This comprehensive course on Data Analysis and Forecasting in Excel will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Data Analysis and Forecasting in Excel comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Data Analysis and Forecasting in Excel. It is available to all students, of all academic backgrounds. Requirements Our Data Analysis and Forecasting in Excel is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 10 sections • 31 lectures • 04:43:00 total length •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00

Overview This comprehensive course on Data Center Training Essentials: General Introduction will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Data Center Training Essentials: General Introduction comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Data Center Training Essentials: General Introduction. It is available to all students, of all academic backgrounds. Requirements Our Data Center Training Essentials: General Introduction is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 7 lectures • 02:41:00 total length •Module 01: Data Center Introduction: 00:37:00 •Module 02: Data Center Reliability: 00:23:00 •Module 03: Data Center Equipment: 00:24:00 •Module 04: Data Center White Space: 00:24:00 •Module 05: Data Center Support Spaces: 00:27:00 •Module 06: Data Center Security, Safety, Networks and IT: 00:26:00 •Assignment - Data Center Training Essentials: General Introduction: 00:00:00