3993 Office Skills courses

Duration 5 Days 30 CPD hours This course is intended for This basic course is for IT personnel with a theoretical background of z/OS. Overview Review the main concepts of z/OS Log on to TSO and start ISPF/PDF Navigate through ISPF/PDF dialogs and use the basic ISPF/PDF functions and the ISPF Editor Use ISPF/PDF to allocate data sets and edit data sets (including hierarchical file system (HFS) files) via the ISPF Editor primary and line commands Use ISPF to create and manipulate (copy, rename, delete, list, sort and merge) data sets Identify security considerations for Multiple Virtual Storage (MVS) data sets and HFS files Describe and use TSO/E commands Perform simple modifications to existing ISPF/PDF panels Invoke a REXX exec and TSO CLIST Tailor existing JCL and submit batch jobs Review job status and job output using SDSF Invoke UNIX processes Manipulate HFS directories and file systems using the UNIX System Services ISHELL This course is designed to teach students the fundamental practical skills to navigate and work in a z/OS environment. This includes the use of ISPF/PDF dialogs, TSO/E commands, JCL, UNIX System Services shell, and BookManager. Review of the z/Architecture and z/OS An Introduction to ISPF, ISPF/PDF, and RACF System familiarization Working with ISPF/PDF (Part 1 & 2) Allocate new data sets ISPF editor primary commands ISPF editor line command Copy/move/rename/delete data sets and members Data set lists Working with TSO/E Using TSO/E commands Working with JCL Submit a job JCL exercises Working with UNIX System Services Procedures ISHELL and hierarchical file system Additional course details: Nexus Humans ES10 IBM Fundamental System Skills in z/OS training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the ES10 IBM Fundamental System Skills in z/OS course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Are you ready to embark on an enlightening journey of wisdom with the Microsoft bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Microsoft Tips and Tricks Bundle. Delve into eight immersive CPD Accredited courses, each a standalone course: Microsoft Outlook - 25 Must-Know Tips and Tricks Microsoft Office 365 Automation Course Microsoft Access - 25 Must-Know Tips and Tricks Microsoft Excel - 25 Must-Know Formulas and Functions Microsoft PowerBI - 25 Must-Know Tips and Tricks Microsoft Teams - 25 Must-Know Tips and Tricks QuickBooks Desktop: 25 Must-Know Tips SharePoint Site Owner Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Microsoft Tips and Tricks Bundle bundle illuminate your path to wisdom. The Microsoft Tips and Tricks Bundle bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Microsoft Tips and Tricks Bundle package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Microsoft bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Microsoft Tips and Tricks Bundle community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Microsoft bundle. Establish robust bases across each course nestled within the Microsoft bundle. Decipher intricate concepts through the articulate content of the Microsoft bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Microsoft bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Microsoft bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Microsoft bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Microsoft bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Microsoft bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Microsoft journey and let knowledge guide you towards a brighter future. CPD 85 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the Microsoft bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Microsoft bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

Have you ever wondered how businesses transform raw data into actionable insights or how financial analysts accurately pinpoint market trends? Microsoft Excel stands tall as the fulcrum that balances numerous sectors of the business world. This 8-course Microsoft Excel Mastery: AutoCAD, SQL, Data Analysis, Financial Modelling & Marketing bundle dives deep into the myriad applications of Microsoft Excel, from interfacing with AutoCAD to crafting marketing strategies and comprehensive financial models. In an era defined by data-driven decisions, this 8-course Microsoft Excel Mastery: AutoCAD, SQL, Data Analysis, Financial Modelling & Marketing bundle is tailored to equip learners with the multifaceted applications of Microsoft Excel. Ranging from foundational Excel operations to advanced integrations with tools like AutoCAD and MySQL, the course bundle aims to foster expertise in data management, analysis, and visualisation. Whether you're venturing into financial modelling, HR analytics, or design integration, this bundle serves as a comprehensive guide to mastering Excel in diverse professional realms, ensuring you are well-prepared to leverage its capabilities in the modern workplace. Ready to excel in your career? Embrace the transformative power of data and design by mastering Microsoft Excel with our comprehensive course bundle. Dive in now and shape your future with unparalleled proficiency! The Eight CPD Accredited courses that the bundle includes are: Course 1: Microsoft Excel Course for Everyone - Complete Excel Course Course 2: Excel VBA/Macros Foundations Course 3: Dynamic Excel Gantt Chart and Timelines Course 4: Hands on Programming on AutoCAD to Excel Using VB.NET Course 5: Learn MySQL from Scratch for Data Science and Analytics Course 6: Data Analytics Course 7: Build HR Dashboard using Excel Course 8: Financial Modelling Using Excel Learning Outcomes: Gain comprehensive knowledge and understanding of Microsoft Excel and its vast capabilities. Understand the seamless integration between Excel and tools like AutoCAD and MySQL. Develop proficiency in creating intricate financial models and marketing strategies. Acquire skills to analyse data, forecast trends, and build informative dashboards. Learn the principles of personal finance management using Excel. Master the art of crafting Gantt charts and timelines for effective project management. Microsoft Excel Course for Everyone - Complete Excel Course: Acquaint yourself with the foundational and advanced facets of Microsoft Excel, fostering data management expertise. Excel VBA/Macros Foundations: Dive into the transformative world of VBA, unlocking Excel's programming potentials. Dynamic Excel Gantt Chart and Timelines: Grasp the essentials of project management by designing insightful Gantt charts and timelines in Excel. Hands on Programming on AutoCAD to Excel Using VB.NET: Bridge the realms of design and data by merging AutoCAD functionalities with Microsoft Excel's prowess. Learn MySQL from Scratch for Data Science and Analytics: Understand the confluence of Excel and MySQL, anchoring data science and analytics. Data Analytics: Master the techniques of transforming raw numbers into actionable insights using Microsoft Excel. Build HR Dashboard using Excel: Curate informative HR dashboards, offering a snapshot of organisational metrics, all within Excel. Financial Modelling Using Excel: Unravel the intricacies of financial markets, crafting accurate models in Microsoft Excel. CPD 90 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on enhancing their Microsoft Excel skills for professional or personal reasons. Marketing professionals aiming to refine their strategic planning with Excel. Financial analysts and enthusiasts looking to build and understand models in Excel. Data scientists and analysts desire to integrate Excel with tools like MySQL. Design engineers and architects keen on integrating AutoCAD designs with Excel data. Career path Data Analyst Financial Modeller Marketing Strategist HR Dashboard Specialist Database Administrator (with Excel integration knowledge) Project Manager (familiar with Gantt and timelines in Excel) Design Engineer using Excel with AutoCAD Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

Follow your dreams by enrolling on the Microsoft Excel Masterclass course today and develop the experience, skills and knowledge you need to enhance your professional development. Microsoft Excel Masterclass will help you arm yourself with the qualities you need to work towards your dream job. Study the Microsoft Excel Masterclass training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Microsoft Excel Masterclass course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This Microsoft Excel Masterclass course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Microsoft Excel Masterclass course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Microsoft Excel Masterclass course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Microsoft Excel Masterclass course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Microsoft Excel Masterclass course. The Microsoft Excel Masterclass course is designed by industry experts and is tailored to help you learn new skills with ease.  The Microsoft Excel Masterclass is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Microsoft Excel Masterclass when it suits you. Access the Microsoft Excel Masterclass course modules from any internet-enabled device, including computers, tablets, and smartphones. The Microsoft Excel Masterclass course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Microsoft Excel Masterclass now and start learning instantly! What You Get Out Of Studying Microsoft Excel Masterclass With Janets: Receive a digital Certificate upon successful completion of the Microsoft Excel Masterclass course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The Microsoft Excel Masterclass training course is delivered through Janets' online learning platform. Access the Microsoft Excel Masterclass content from any internet-enabled device whenever or wherever you want to. The Microsoft Excel Masterclass course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Microsoft Excel Masterclass course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Microsoft Excel Masterclass course. After successfully passing the Microsoft Excel Masterclass course exam, you will be able to apply for a CPD-accredited certificate as proof of your Microsoft Excel Masterclass qualification. Certification All students who successfully complete the Microsoft Excel Masterclass course can instantly download their digital certificate. You can also purchase a hard copy of the Microsoft Excel Masterclass course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Microsoft Excel Masterclass is ideal for those who already work in this sector or are an aspiring professional. This Microsoft Excel Masterclass course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Microsoft Excel Masterclass is open to all students and has no formal entry requirements. To study the Microsoft Excel Masterclass course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Microsoft Excel Masterclass is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Microsoft Excel Masterclass and gain an industry-recognised qualification that will help you excel in finding your ideal job.

Learn how to create a mail merge in Word to allow you to send personalized emails to groups of people. Course overview Duration: 2 hours This course looks at how you can create a list of contacts with emails and then build a document to email out to everyone. This ensures that everyone gets a personal email but no one else sees the recipients. Objectives  By the end of the course you will be able to: Create source data to use in a merge Create a document to email out Attach source data contacts Filter recipients Send out emails to all Content Creating source contact data Creating your source data in Excel Creating a Word mail merge document Starting a mail merge document Attaching your source contact data Building the document Emailing your document Previewing the results Running a test to a document Setting up any filters Sending your document to emails

Learn all the quick tips and tricks you didn’t know about in Word and how to properly setup new documents. Course overview Duration: 1 day (6.5 hours) Our Word Document Production (Part 1) course shows you how Word was designed to be used and demonstrates the powerful tools available. This course will enable you to originate professional documents with ease, ensuring that modifications are quick and uncomplicated. It looks at some of the common frustrations and how to avoid them. This course is aimed at existing Word users who want to get the best out of the package Objectives  By the end of the course you will be able to: Customise Word Use different Word views Use line, paragraph and page breaks correctly Set indents and tabs Use styles for easy formatting Work with section breaks Work with automatic correction features Insert and modify tables Content Word setup Using different views Customising the status bar Customising the Quick Access bar and Ribbon Document setup Using the Navigation Pane Using Show / Hide Line vs paragraph breaks Using page break Using the ruler Setting indents and tabs The different types of indent Using dot leader tab Bullets and numbering Working with simple numbered and bulleted lists Sorting lists Working with multi level lists Styles The importance of styles Creating, amending and applying Character Styles Amending and applying Paragraph Styles Setting bullet point styles Using the Style Inspector Reorganising a document Using Outline View Promoting and demoting headings Displaying Styles names in Draft and Outline views Page and number fomatting Section vs page breaks Setting page orientation Setting page margins Displaying page border Automatic corrections Working with Quick Parts Setting autocorrect options Autoformat while typing Creating simple tables Inserting or drawing a table Modifying table formatting Adding rows and columns Changing row heights and column widths

Get to grips with all the features of Teams, including calls and chats, Teams and Channels and Meetings Course overview Duration: 2 hours This session is aimed at those new or self-taught users of Teams to show them the features and how to setup and use it effectively. Objectives  By the end of the course you will be able to: Use the core functions of Microsoft Teams Set up Microsoft Teams Make Calls Send Chats to colleagues via teams Set up channels Run Teams meetings Content What is Teams Teams elements Setting up your Teams Setting up audio and video Using voicemail Setting voicemail language Calls and Chats Sending individual and group chats Making and receiving calls Missed call notification Searching Teams and Channels Creating channels Channel settings Setting channel notifications Emailing channels Creating private channels Posting to channels Alerting specific people in a channel Adding files to channels Sending links to channels Teams Meetings Setting up meetings Running meetings from channels Setting backgrounds Screen sharing in meetings Handing over control Creating meeting notes Adding files to teams or meetings Using the meeting chat

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

There is so much more to this free tool than just creating PDFs. Learn what else you can do for free. Duration: 2 hours This Adobe Acrobat Reader course looks at the features of the Acrobat Reader tool. Learn how to create PDF and what options you have, complete and sign and mark up PDFs. Objectives  By the end of the course you will be able to: Create PDFs from other tools Complete and sign documents Mark up PDF documents Content Creating PDFs Building PDF documents from Word, Excel and PowerPoint Working in Acrobat Home, Tools and Document Views Using the Navigation Panel and Pane Floating toolbar and Contextual menus Completing and signing documents Using fill and sign to complete forms Adding signatures Marking up documents Marking up changes Using sticky notes Using the highlighter pen Adding stamps Attaching documents and audio

Learn how to create fully relational databases and how to input, extract and report on data. Course overview Duration: 2 days (13 hours) Our Access Database Design and reporting course looks at the key elements to building fully relational databases and entering and extracting information from them. This course is designed for new users who need to build relational database systems. Objectives  By the end of the course you will be able to: Create a new database Create data tables Set field validation and properties Enter data and manage data Create forms Use queries to extract data Create parameter queries Create calculations in queries Build relational databases Use sub datasheets Build multi table queries Use advanced form and report design techniques Content Creating a database Creating a new database Database elements Creating a data table Setting field properties Using input masks Using input masks Validation rules Default values Setting a primary key Creating lookup fields Data entry Adding data Deleting data Quick keys for data entry Working with data Sorting data Filtering data Finding information Navigation Creating data form Creating quick forms The form wizard Amending forms Formatting Setting the tab order Entering data using forms Creating queries Creating a query Setting criteria Using the expression builder Creating parameter queries Using wildcards Using more than one parameter Using calculations in queries Adding a totals row Formatting results Adding calculations Printing and reporting Printing tables and queries Creating reports Building and amending reports Adding headers and footers Working with relational databases Relational database principles Importing data from other sources Linking information between tables One-to-one and one-to-many links Defining referential integrity Amending links Deleting links Sub datasheets Viewing a subdatasheet Removing a subdatasheet Connecting a subdatasheet Multiple table queries Deciding which tables to use Adding tables to the query Creating links between tables Setting join properties Advanced form design Field properties Creating lookup fields Adding calculated fields Applying conditional formatting Advanced report design Field properties Report properties Alternate colour bandings Concatenating fields Adding calculated fields Sorting and grouping Grouping settings Adding headers and footers Adding dates, times, page numbers