Register on the Excel Essentials for Office Administrators today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Excel Essentials for Office Administrators is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Excel Essentials for Office Administrators Receive a e-certificate upon successful completion of the 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) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This 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 online training is open to all students and has no formal entry requirements. To study the Excel Essentials for Office Administrators, 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. Course Content Excel Beginner Identify the Elements of the Excel Interface 00:24:00 Activity - Identify the Elements of the Excel Interface 00:10:00 Create a Basic Worksheet 00:40:00 Activity - Create a Basic Worksheet 00:16:00 Use the Help System@ 00:08:00 Activity - Use the Help System 00:12:00 Create Formulas in a Worksheet 00:08:00 Activity - Create Formulas in a Worksheet 00:10:00 Insert Functions in a Worksheet@ 00:10:00 Activity - Insert Functions in a Worksheet 00:12:00 Reuse Formulas 00:12:00 Activity - Reuse Formulas 00:14:00 Manipulate Data 00:16:00 Activity - Manipulate Data 00:08:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:18:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows@ 00:12:00 Search For and Replace Data 00:20:00 Activity - Search For and Replace Data 00:12:00 Spell Check a Worksheet 00:06:00 Activity - Spell Check a Worksheet 00:08:00 Modify Fonts 00:10:00 Activity - Modify Fonts 00:18:00 Add Borders and Colors to Cells 00:12:00 Activity - Add Borders and Colors to Cells 00:14:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:08:00 Align Cell Contents 00:12:00 Activity - Align Cell Contents 00:10:00 Apply Cell Styles 00:00:00 Activity - Apply Cell Styles 00:00:00 Define the Basic Page Layout for a Workbook 00:32:00 Activity - Define the Basic Page Layout for a Workbook 00:08:00 Refine the Page Layout and Apply Print Options 00:18:00 Activity - Refine the Page Layout and Apply Print Options 00:10:00 Format Worksheet Tabs 00:06:00 Activity - Format Worksheet Tabs 00:06:00 Manage Worksheets@ 00:16:00 Activity - Manage Worksheets 00:08:00 Manage the View of Worksheets and Workbooks 00:14:00 Activity - Manage the View of Worksheets and Workbooks 00:06:00 Customize General and Language Options 00:14:00 Activity - Customize General and Language Options 00:10:00 Customize Formula Options 00:04:00 Activity - Customize Formula Options 00:08:00 Customize Proofing and Save Options 00:10:00 Activity - Customize Proofing and Save Options 00:08:00 Customize the Ribbon and Quick Access Toolbar 00:06:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:14:00 Customize the Functionality of Excel by Enabling Add-Ins 00:12:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:12:00 Customize Advanced and Trust Center Options@ 00:08:00 Activity - Customize Advanced and Trust Center Options 00:10:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Excel Intermediate Apply Range Names 00:34:00 Use Specialized Functions 00:44:00 Use Text Functions@ 00:34:00 Use Logical Functions@ 00:22:00 Use Lookup Functions 00:20:00 Use Date Functions@ 00:12:00 Use Financial Functions 00:26:00 Create and Modify Tables 00:26:00 Sort and Filter Data@ 00:26:00 Use Subtotal and Database Functions to Calculate Data 00:34:00 Create Charts 00:30:00 Modify and Format Charts 00:22:00 Create a Trendline 00:22:00 Create Advanced Charts@ 00:34:00 Create a PivotTable 00:38:00 Filter Data by Using Slicers 00:14:00 Analyze Data with PivotCharts 00:20:00 Insert and Modify Graphic Objects 00:38:00 Layer and Group Graphic Objects 00:14:00 Incorporate SmartArt 00:16:00 Customize Workbooks 00:26:00 Manage Themes 00:10:00 Create and Use Templates 00:24:00 Protect Files 00:36:00 Preparing a Workbook for Multiple Audiences 00:34:00 Activities and Exercise Files - Microsoft Excel 2016 Intermediate 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
Through this course, you will learn to transform yourself from a passive learner who watches to one who sees the process of learning for what it truly is-a mechanism to better oneself. You will build 40 amazing applications to master the concepts of computer science and Python programming.
Duration 5 Days 30 CPD hours This course is intended for This is an intermediate course for system administrators, database administrators, and other technical individuals, who manage and implement DB2 10 for z/OS. Administrators of DB2 11 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 11 for z/OS subsystem. Course Outline Start and stop the DB2 subsystem Explain the allocation CLIST used at logon for DB2 data sets Use Set SYSPARM command Locate the Command recognition character for the DB2 subsystem Query the system log to gain knowledge about the IPL process and information in the system log when DB2 is initialized or stopped Explore DB2 Address Spaces information Select the DB2 functions that best satisfy your site requirements Explain the use of RACF for DB2 connection security Explain the use of Roles and Trusted Context Implement security procedures for a DB2 environment Describe the components and address space structure of a DB2 subsystem Explain DB2 Program Flow for all environments Invoke and use DB2 TSO Facilities Use the DB2 Catalog to monitor authorizations Increase the size of the Active Log data sets Explain DB2 Logging Use SET LOG SUSPEND and SET LOG RESUME Use DSNJU004 to Print Log Map Interpret the output of the Print Log Map Utility DSNJU004 Use DSNJU003 to rename DB2 data sets Plan for recovery of a BSDS failure Monitor and control DB2 Explain transaction flow in IMS and CICS Describe the CICS and DB2 environment Make use and implement the extended 10-byte RBA and LRSN
Duration 4 Days 24 CPD hours This course is intended for This is an intermediate course for experienced DBAs and technical individuals, with experience on other relational database platforms, who plan, implement, and maintain Db2 11.1 for Linux, UNIX, and Windows databases. These skills can also be utilize to support cloud based databases using Db2 on Cloud or Db2 Hosted environments. Overview Please refer to course overview This course teaches you to perform, basic and advanced, database administrative tasks using Db2 11.1. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. The access strategies selected by the Db2 Optimizer will be examined using the Db2 Explain tools. Various diagnostic methods will be presented, including using various db2pd command options. Students will learn how to implement automatic archival for database logs and how to plan a redirected database restore to relocate either selected table spaces or an entire database. The REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces, will be discussed. We will also cover using the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. The selection of indexes to improve application performance and the use of SQL statements to track database performance and health will be covered. This course provides a quick start to Db2 database administration skills for experienced relational Database Administrators (DBA). Overview of Db2 11Command Line Processor (CLP) and GUI UsageThe Db2 EnvironmentCreating Databases and Data PlacementCreating Database ObjectsMoving DataBackup and RecoveryLocks and ConcurrencyDatabase Maintenance, Monitoring and Problem DeterminationSecurityDatabase Rebuild SupportDb2 Database and Table Space RelocationUsing Explain ToolsUsing Indexes for PerformanceAdvanced Monitoring
Duration 1.5 Days 9 CPD hours This course is intended for Application developers on the beginner and intermediate level seeking to create and deploy secure Android applications. Overview Understand Android software architecture. Understand Android?s security model. Build Android applications with security best practices in mind. Build more secure and more robust application that appeals to clients. This is a two-day (12 hours) professional course, which thoroughly covers the Android security model and concerns of both the developer and end-user point of view. This course is mapped for AND-802 exam. PermissionsManaging the Policy FileUsers? Data Privacy and ProtectionSecuring Storage Additional course details: Nexus Humans Android Security Essentials 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 Android Security Essentials 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.
Duration 5 Days 30 CPD hours This course is intended for This intermediate course is appropriate for experienced UNIX system administrators who want to support AIX running on POWER processor based systems in a mult-iuser POWER (System p) partitioned environment. Overview At course completion, you will be able to:- Install the AIX operating system, filesets, and RedHat Package Manager (RPM) packages - Perform system startup and shutdown - Discuss and use system management tools such as System Management Interface Tool (SMIT) and IBM systems director console for AIX - Manage physical and logical devices - Discuss the purpose of the logical volume manager - Perform logical volume and file system management - Perform and restore system backups - Use the AIX error log as a tool in problem determination - Configure TCP/IP networking Students will learn to install, customize and administer the AIX operating system in a multi-user POWER (System p) partitioned environment. Introduction to AIX and IBM Power systems AIX system management tools AIX software installation and maintenance System configuration and devices TCP/IP networking System startup and shutdown Basics of configuring logical partitions AIX installation Working with the Logical Volume Manager File systems administration The Object Data Manager LVM metadata Disk management procedures Backup and restore Error monitoring System initialization - I System initialization - II (00:35) Exercise 17 (00:25) Unit 18: The AIX system dump facility (00:15) Exercise 18 Advanced install techniques Alternate disk installation Alternate disk - part 1 (pre-clone) Using multibos Alternate disk - part 2 (post-clone) multibos Appendix A: Survey of additional AIX facilities
Duration 4.5 Days 27 CPD hours This course is intended for This is an intermediate course intended for IBM i system administrators, data processing managers and other individuals who implement and manage security, backup and recovery, system software and problem determination. This course is not recommended for s Overview Describe and implement the components of IBM i security, such as user profile, group profile, authorization list, adopted authority and object / resource security Develop a security plan for your Power Systems with IBM i Describe the options to implement security auditing Develop a plan to audit security on your Power Systems with IBM i Describe the IBM i availability products and features and choose the option(s) that best fit your company requirements Describe how to backup and recover user, IBM and full system data on your Power Systems with IBM i Develop a backup and recovery plan for your Power Systems with IBM i Describe the system diagnostics and problem determination procedures available on your Power Systems with IBM i Learn how to plan for, implement, and manage the ongoing operations of an IBM i. Class administration and introductions . IBM i overview and concepts . Management central overview . Security concepts and overview . System values . User security . Resource security . Security auditing . Designing security . IBM i availability overview . Disk management . Backup and recovery strategy using Save/Restore . Journal management . Commitment control overview . Backup and recovery planning . Problem determination . Overview of Systems Director Navigator for i . Introduction to BRMS .
Overview With the ever-increasing demand for Teaching and Child Care Training in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Teaching and Child Care Training may be. Learning about Teaching and Child Care Training or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Teaching and Child Care Training . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Teaching and Child Care Training is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Teaching and Child Care Training course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Teaching and Child Care Training course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Teaching and Child Care Training course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Teaching and Child Care Training , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Teaching and Child Care Training , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Teaching and Child Care Training , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Teaching and Child Care Training course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 1 Concept of TA and differentiating with LSA Concept of TA and differentiating with LSA 00:00 Module 2 Building relationships in the school team Building relationships in the school team 00:00 Module 3 School policies relevant to the job of a TA School policies relevant to the job of a TA 00:00 Module 4 Assisting learning and teaching in the classroom Assisting learning and teaching in the classroom 00:00 Module 5 Understanding the curriculum Understanding the curriculum 00:00 Module 6 Self development Self development 00:00 Module 7 Daily care of the baby Daily care of the baby 00:00 Module 8 Problems of Infancy Problems of Infancy 00:00 Module 9 Inoculations Inoculations 00:00 Module 10 The child's development and relevant activities The child's development and relevant activities 00:00 Module 11 One to two year old One to two year old 00:00 Module 12 Three to six year old Three to six year old 00:00 Module 13 Keeping an eye on children Keeping an eye on children 00:00 Module 14 Reduce The Risk Of Poisoning Reduce The Risk Of Poisoning 00:00 Module 15 Happy Parenting Happy Parenting 00:00
Overview With the ever-increasing demand for Soft Skills in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Soft Skills may be. Learning about Soft Skills or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Soft Skills. That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Soft Skills is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Employability : Soft Skills course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Employability : Soft Skills course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Employability : Soft Skills course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Soft Skills, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Soft Skills, Anyone looking for a certificate of completion on doing an online training on this topic, Students of Soft Skills, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Employability : Soft Skills course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 1 - Introduction to Self-Improvement Introduction to Self-Improvement 00:00 Module 2 - How to Motivate Yourself How to Motivate Yourself 00:00 Module 3 - Grow Assertiveness Grow Assertiveness 00:00 Module 4 - Self Confidence and Self Esteem Self Confidence and Self Esteem 00:00 Module 5 - Improve Your Communication Skills Improve Your Communication Skills 00:00 Module 6 - Manage Your Time Properly Manage Your Time Properly 00:00 Module 7 - Cultivate Growth Mindset Cultivate Growth Mindset 00:00 Module 8 - All about Leadership Skills All about Leadership Skills 00:00 Module 9 - Think Critically and Solve Problem Think Critically and Solve Problem 00:00 Module 10 - Learn Teamwork and Collaboration Learn Teamwork and Collaboration 00:00 Module 11 - Negotiate Effectively Negotiate Effectively 00:00 Module 12 -Stress Management Stress Management 00:00 Module 13 - Being Competent to Decide Yourself Being Competent to Decide Yourself 00:00 Module 14 - Influencing and Persuasion Skills Influencing and Persuasion Skills 00:00 Module 15 - Adaptability and Flexibility Adaptability and Flexibility 00:00 Module 16 - Know How to Resolve Conflicts Know How to Resolve Conflicts 00:00 Module 17 - Planning and Organizing Skills Planning and Organizing Skills 00:00 Module 18 - Being Creative and Innovative Being Creative and Innovative 00:00