4036 Courses delivered Online

Windows Server 2019 - Level 1 Hands-on Training Course Overview Are you looking to begin your Microsoft Server 2019 career or want to develop more advanced skills in Microsoft Server 2019? Then this Windows Server 2019 - Level 1 Hands-on Training course will set you up with a solid foundation to become a confident Windows Server 2019 administrator and help you to develop your expertise in Microsoft Server 2019. This Windows Server 2019 - Level 1 Hands-on Training course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this Windows Server 2019 - Level 1 Hands-on Training course will set you up with a solid foundation to become a confident Windows Server 2019 administrator and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as a Windows Server 2019 administrator. The Windows Server 2019 - Level 1 Hands-on Training course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a Windows Server 2019 administrator. This comprehensive Windows Server 2019 - Level 1 Hands-on Training course is the perfect way to kickstart your career in the field of Microsoft Server 2019. This Windows Server 2019 - Level 1 Hands-on Training course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as a Windows Server 2019 administrator or want to learn more skills on Microsoft Server 2019 but unsure of where to start, then this Windows Server 2019 - Level 1 Hands-on Training course will set you up with a solid foundation to become a confident Windows Server 2019 administrator and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This Windows Server 2019 - Level 1 Hands-on Training course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who is this Windows Server 2019 - Level 1 Hands-on Training Online course for? This comprehensive Windows Server 2019 - Level 1 Hands-on Training course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Microsoft Server 2019. Entry Requirement There are no academic entry requirements for this Windows Server 2019 - Level 1 Hands-on Training course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Assessment Method This windows server 2019 - level 1 hands-on training online assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. Course Curriculum Course Overview Course Overview Video Building Your Virtual Lab Environment Video - Downloading ISO and OVA Files for VirtualBox Video and Lab - Create a Virtual Install of Server 2019 Full GUI Video and Lab - Create a Virtual Install of Windows 10 VirtualBox Video - Taking a Snapshot of Your Current Confiuration Building a Windows Server 2019 Domain Using Powershell Video and Lab - Preparing Your Network for Active Directory Step 1: Rename Your Server Using Powershell Step 2: Assign a Static IP Address Using PowerShell Step 3: Install the Active Directory Domain Services Role Using Powershell Step 4: Promote Server 2019 as a Domain Controller Using PowerShell Step 5: Promote Server Core to a Domain Controller Step 6: Add a Windows 10 Client to the Domain Active Directory Administration Video - Create a User in Active Directory Video - Limit Computers a User Can Log on to Video - Limit Logon Hours for a User in Windows Active Directory Video - Reset a User's Password in Windows Active Directory Video - Unlock or Enable an Account in Active Directory Server 2019 Administration Video and Lab - Reset a Lost Administrator Password in Windows Server Video - Create a Shared Folder Using Windows Server Video - Create a Shared Folder Using Server Manager Video - Rearm the 180-Day Evaluation Period for Windows Server Video - Rearm the 30-Day Evaluation for Windows 10 Video - Windows Server 2019 Updates Settings Video - Enable Remote Desktop Using PowerShell Video - NTDSUTIL: Resetting the Directory Services Recovery Mode Password Video - Create a Heads-up Display Using BgInfo Video - Manually Enabling Remote Management Group Policy Video - Prevent Automatic Logoff Due to Inactivity Video - How to Create and Link a Group Policy to an OU Video - How to Edit Group Policy Objects to Affect a User Video - How to Edit a Group Policy Object to Affect a Computer Video - Backup and Restore Group Policy Objects in Active Directory Video - Force Screensaver and Timeouts Using Group Policy Video- Change Users Desktop Background Using Group Policy Domain Naming System (DNS) Video - Installing the DNS Role Using Server Manager Video - Create a Secondary or Backup DNS Server Video - Create a Secondary or Backup DNS Server Using Server Core Video - Create a DNS Reverse Lookup Zone in Server 2019 Video - Create a Host Record for a New Website in Microsoft DNS Video - Create a Host Record for a New Website in Microsoft DNS DHCP Video - Install the DHCP Role Using PowerShell Video - Installing the DHCP Server Role Using Server Manager Video - How to Authorize/Unauthorize a DHCP Server Video - How to Edit the Default Gateway Settings in DHCP Video - How to Edit DNS Server List in DHCP Video - Edit a DHCP Scope video - How to Backup and Restore the DHCP Database Video - Use Filters in DHCP to Deny Clients DHCP Services Video - Create Predefined Options in DHCP Video - Use DHCP User Classes to Assign Alternate DHCP Options Disk Management Video - Adding Additional Virtual Hard Disks Video - How to Shrink or Extend a Volume in Windows Server 2019 Video - How to Format a Volume With ReFS in Windows Server 2019 Video - How to Format a Volume With FAT32 in Windows Server 2019 Firewall Administration video -Turn the Windows Firewall On and Off Video - Using Netsh to Manage the Windows Firewall Video - Using Powershell to Gather Firewall Information Troubleshooting Video - Allow PING Between Windows Server and Windows 10 Video and Lab - Troubleshooting Internet Connectivity Video - NSLookup Video - Windows Reliability Monitor Certificate of Achievement Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Power BI - Business Data Analysis and Visualization Training Course Overview Are you looking to begin your Microsoft Power BI career or want to develop more advanced skills in Microsoft Power BI? Then this power BI - business data analysis and visualisation training course will set you up with a solid foundation to become a confident Power BI user and help you to develop your expertise in Microsoft Power BI. This power BI - business data analysis and visualisation training course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this power BI - business data analysis and visualisation training course will set you up with a solid foundation to become a confident Power BI user and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as a Power BI user. The power BI - business data analysis and visualisation training course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a Power BI user. This comprehensive power BI - business data analysis and visualisation training course is the perfect way to kickstart your career in the field of Microsoft Power BI. This power BI - analyze and interactively visualize business data course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as a Power BI user or want to learn more skills on Microsoft Power BI but unsure of where to start, then this power BI - business data analysis and visualisation training course will set you up with a solid foundation to become a confident Power BI user and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This power BI - business data analysis and visualisation training course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who should take this course? This comprehensive power BI - business data analysis and visualisation training course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Microsoft Power BI. Entry Requirement There are no academic entry requirements for this power BI - business data analysis and visualisation training course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Method of Assessment On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately. Career path This power BI - business data analysis and visualisation training course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. Course Curriculum Introduction - What is Power BI. Introduction - What is Power BI. Getting Started with Power BI Pro Getting Started with Power BI Pro Working With Various Data Sources in Power BI Using Data from Excel Tables in Power BI Using Data from Normalized Excel Spreadsheets in Power BI Update Data in Power BI Import Data from Websites into Power BI Import Data from a PDF File into Power BI Import Data from a CSV File into Power BI Import Data from Access Databases into Power BI Elaborate a Power BI Report to Enable Decision Making Elaborate a Power BI Report to Enable Decision Making Improve a Power BI Report to Increase Informative Value Optimize Power BI Reports to Improve Readability Edit Field Properties in Power BI to Improve Readability Format Axes to Make Data Comparable Visualize Benchmarks with Reference Lines Add Annotations Using Text Boxes Create YoY Comparisons Conveniently Visualize Data on Maps to Valorize Reports Enrich Visualisations with Radial Gauges - Speedometer and Thermometer Enrich Visualisations with Conditional Formatting Perform Advanced Data Analysis by Using Filters and Slicers If Default Visualizations are not Enough: Add Custom Visuals Customize the Design of a Report Save Key Findings in Easy-to-Access Bookmarks Optimize Reports for Mobile Devices Access from Anywhere with Power BI Working With Data - Advanced Techniques Improve Datasets by Extracting Data from Fields and Adding Fields Create Calculated Columns if the Data Source is Insufficient Take Advantage of Predefined Calculations Using Quick Measures Create Virtual Columns Using Measures Power BI Service - The Online Version of Power BI Power BI Service - First Steps Share Power BI Reports for Collaboration Provide Power BI Reports in Microsoft Teams Publish Power BI Reports Manage Roles and Assign Users From Complex Reports to Clear Dashboards Set Up Alerts for Target Values Commenting on Reports and Dashboards Use Data Gateways to Access Local Data Safely Optimizing Power BI with Advanced Settings Appendix: The Various Power BI Components and How to Install Power BI Installing Power BI Pro Activate the Power BI Service Final Remarks Final Remarks Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

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.

Follow your dreams by enrolling on the Financial Planning and Cashflow Management course today and develop the experience, skills and knowledge you need to enhance your professional development. Financial Planning and Cashflow Management will help you arm yourself with the qualities you need to work towards your dream job. Study the Financial Planning and Cashflow Management training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Financial Planning and Cashflow Management course will allow you to enhance your CV, impress potential employers, and stand out from the crowd. This Financial Planning and Cashflow Management 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 Financial Planning and Cashflow Management course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Financial Planning and Cashflow Management course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Financial Planning and Cashflow Management 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 Financial Planning and Cashflow Management course. The Financial Planning and Cashflow Management course is designed by industry experts and is tailored to help you learn new skills with ease. The Financial Planning and Cashflow Management is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Financial Planning and Cashflow Management when it suits you. Access the Financial Planning and Cashflow Management course modules from any internet-enabled device, including computers, tablets, and smartphones. The Financial Planning and Cashflow Management course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Financial Planning and Cashflow Management now and start learning instantly! What You Get Out Of Studying Financial Planning and Cashflow Management With Janets Free PDF certificate upon successful completion of the Financial Planning and Cashflow Management Full one-year access to Financial Planning and Cashflow Management Course materials Instant assessment results with the Financial Planning and Cashflow Management No hidden fees with the Financial Planning and Cashflow Management Full tutor support available from Monday to Friday with the Financial Planning and Cashflow Management Study the Financial Planning and Cashflow Management at your own pace Benefit from instant feedback through mock exams and multiple-choice assessments Gain a complete understanding of Financial Planning and Cashflow Management Accessible, informative modules taught by expert instructors Get 24/7 help or advice from our email and live chat teams with the Financial Planning and Cashflow Management Study the Financial Planning and Cashflow Management in your own time through your computer, tablet or mobile device Improve your chance of gaining professional skills and better earning potential by completing the Financial Planning and Cashflow Management Description  The Financial Planning and Cashflow Management training course is delivered through Janets' online learning platform. Access the Financial Planning and Cashflow Management content from any internet-enabled device whenever or wherever you want to. The Financial Planning and Cashflow Management 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 Financial Planning and Cashflow Management 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 Financial Planning and Cashflow Management course. After successfully passing the Financial Planning and Cashflow Management course exam, you will be able to apply for a CPD-accredited certificate as proof of your Financial Planning and Cashflow Management qualification. Certification All students who successfully complete the Financial Planning and Cashflow Management course can instantly download their digital certificate. You can also purchase a hard copy of the Financial Planning and Cashflow Management course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Financial Planning and Cashflow Management is ideal for those who already work in this sector or are an aspiring professional. This Financial Planning and Cashflow Management 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 Financial Planning and Cashflow Management is open to all students and has no formal entry requirements. To study the Financial Planning and Cashflow Management 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 Financial Planning and Cashflow Management 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 Financial Planning and Cashflow Management and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Personal Finance Calculations Calculating Your Net Worth 00:01:00 Calculating Your Real Hourly Wage 00:02:00 Expenses for Life Energy 00:02:00 Calculating a Monthly Budgeting 00:05:00 Saving for Retirement Paying Off Debt 00:02:00 Build an Emergency Fund 00:02:00 Personal Savings 00:04:00 401K Basics 00:03:00 Asset Allocation 00:04:00 Investment Strategies 00:03:00 Advice on Financial Advisors 00:01:00 3h-Questions-About-Investing 00:15:00 Building Credit to Buy a Home FICO Score 00:09:00 Starting Credit 00:03:00 Increasing Credit Score 00:02:00 Owning vs. Renting 00:02:00 Types of Mortages 00:03:00 Personal Finance Guides for Beginners Advice to Teenagers 00:04:00 Guide to Buying a Car 00:05:00 Cashflow Management Forecasting 00:20:00 What is Cashflow? 00:20:00 Planning and Management9 00:10:00 Planning Part 2 00:12:00 Where it can go Wrong 00:09:00 Personal Cashflow Analysis 00:05:00 Personal Cashflow Analysis my Numbers Story 00:06:00 Debt 00:10:00 Budgets and Money Management Finance Jeopardy 00:15:00 The Fundamentals of Finance 00:15:00 The Basics of Budgeting 00:15:00 Parts of a Budget 00:15:00 The Budgeting Process 00:30:00 Budgeting Tips and Tricks 00:15:00 Monitoring and Managing Budgets 00:15:00 Crunching the Numbers 00:15:00 Getting Your Budget Approved 00:15:00 Comparing Investment Opportunities 00:15:00 ISO 9001:2008 00:15:00 Directing the Peerless Data Corporation 00:30:00 Assessment Assignment - Financial Planning and Cashflow Management 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.

Master the skills you need to propel your career forward in personal trainer or fitness trainer. Equip yourself with the essential knowledge and skillset that make you a confident personal trainer or fitness trainer and take your career to the next level. This comprehensive course is designed to help you reach your professional goals. The skills and knowledge that you will gain through studying this personal trainer course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective personal trainer or fitness trainer practice and equip you with the essential skills, confidence and competence to assist you in the personal trainer or fitness trainer industry. You'll gain a solid understanding of the core competencies required to drive a successful career in personal trainer or fitness trainer. Learn from expert tutors with industry experience, teaching you the latest expertise and best practice. This extensive course is designed for personal trainer or fitness trainer professionals who are aspiring to specialise in personal trainer or fitness trainer. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV. Enrol today and take the next step towards your personal and professional goals. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Introduction 00:03:00 Roles & Responsibilities Of A Strength Coach 00:02:00 The Major Muscle Groups Explained Most Important Muscle Groups Overview 00:03:00 The Diffent Types of Muscle Fibers 00:03:00 Muscle Agonists & Antagonists 00:01:00 Quadriceps Explained 00:01:00 Hamstrings Explained 00:01:00 Calf Muscles Explained 00:01:00 Chest Muscles Explained 00:01:00 Back Muscles Explained 00:02:00 Shoulder Muscles Explained 00:01:00 Biceps Explained 00:01:00 Triceps Explained 00:01:00 Abdominal Muscles Explained 00:01:00 Muscle Growth Fundamentals Common Muscle Growth Myths Debunked 00:04:00 Muscle Hypertrophy Explained 00:03:00 Progressive Overload 00:02:00 How Much Muscle Can You Gain in A Week/Month/Year 00:03:00 Client Assessment Client Interview 00:02:00 Estimating 1 Rep Maximum Strength 00:04:00 Workout Design Workout Design Overview 00:01:00 Adherence 00:03:00 The 4 Most Important Exercises For Beginners 00:02:00 How Many Isolation Exercises Should You Do? 00:02:00 Exercise Order 00:01:00 Volume: How Many Sets & Reps? 00:02:00 Intensity: How Heavy Should You Train? 00:01:00 How Often Should You Train? 00:02:00 The Ideal Rest Periods 00:02:00 Time Under Tension Explained 00:02:00 Sample Workouts Sample Workouts Intro 00:01:00 How To Design A Beginner Workout Plan 00:08:00 How To Correctly Warm Up Before Lifting Weights 00:03:00 3 Day Beginner Routine 00:06:00 4 Day Routine 00:04:00 5 Day Routine 00:02:00 Exercise Videos: Compound Exercises Exercise Videos Overview 00:01:00 5 Most Important Aspects Of Correct Lifting Form 00:03:00 Bench Press 00:01:00 Chest Press Machine 00:01:00 Squats 00:01:00 Deadlift 00:01:00 Overhead Press 00:01:00 Dumbbell Overhead Press 00:01:00 Lat Pulldown 00:01:00 Dips 00:01:00 Barbell Row 00:01:00 Barbell Row (Different Grip) 00:01:00 Cable Row 00:01:00 Iso Row Machine 00:01:00 Exercise Videos: Isolation Exercises Hammer Curls 00:01:00 Triceps Rope Pushdown 00:01:00 Calf Raise 00:01:00 Shoulder Front Raise 00:01:00 Shoulder Side Raise 00:01:00 Butterfly / Pec Deck 00:01:00 Dumbbell Flyes 00:01:00 Setting Up A Bodybuilding Diet Nutrition Overview 00:01:00 Calories Explained 00:03:00 How to determine your calorie maintenance level (TDEE) 00:03:00 How to track calories 00:05:00 Ideal Protein Intake 00:01:00 Ideal Carb Intake 00:01:00 Ideal Fat Intake 00:01:00 What about the remaining calories 00:02:00 Determining Meal Structure 00:03:00 Quality Protein Foods 00:01:00 Quality Carb Foods 00:01:00 Quality Fat Foods 00:01:00 Adjusting Your Diet For Muscle Gains 00:04:00 Adjusting Your Diet For Weight Loss 00:05:00 The Perfect Pre Workout Meal 00:03:00 The Perfect Post Workout Meal 00:01:00 Supplements Supplements Overview 00:01:00 Top 3 Beginner Supplements 00:04:00 How To Use Protein Powder 00:05:00 How To Use Creatine 00:04:00 Beta Alanin 00:01:00 BCAAs 00:04:00 Rest & Recovery Recovery Overview 00:01:00 Post Workout Recovery Routine 00:03:00 How To Break Through A Strength Plateau 00:06:00 How To Deload Correctly 00:04:00 The importance of sleep 00:04:00 6 Tips To Fall Asleep Faster 00:03:00 FAQ & Misceallenaous Should Men & Women Train Differently? 00:02:00 What Should You Eat Before Bed To Build Muscle? 00:03:00 Does Electric Muscle Stimulation (EMS) Work? 00:01:00 What Should You Train On Your First Day At The Gym? 00:07:00 Assessment Assessment - Personal Trainer Diploma 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Description: If you like practical work and enjoy being artistic, this could be a perfect course for you. This practical course will equip you with the specialist techniques in painting and decorating. This introductory course is the first step to a career as a successful painter and decorator. You will learn about paint systems, application techniques, applying foundation and plain papers and decorative finishes. Painting and decorating has fantastic job prospects and could provide you with a career for life. Painters and decorators use a range of coverings to enhance and protect surfaces. These surfaces could include plaster, metal and wood. Painters and decorators work on a variety of jobs which require a different set of skills and techniques. Who is the course for? Artists or painters who want home paintings as a business. People who have an interest in professional painting Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Diploma in Art and Painting is a useful qualification to possess, and would be beneficial for the following careers: Visual Artists Portrait Specialist Sketch Artists Logo Designers Module-1 Painting 101 00:30:00 Understanding Paints 00:30:00 Choosing Your Brushes 00:30:00 Color Your World 00:30:00 Light Sources in Painting 00:30:00 What type of painter are you? 00:30:00 Module-2 Choosing A Subject 01:00:00 Setting Up Your Studio 00:30:00 Art Supply Resources 01:00:00 Clean Up Time 00:30:00 Free Art Lessons 01:00:00 Take Care of Your Creation 00:15:00 Module-3 Pay Attention to Detail 01:00:00 Enjoy Your Subject 01:00:00 Frequently Asked Questions 00:30:00 Art Schools 00:30:00 Museums of Fine Art 00:15:00 One Final Word 01:00:00 Module-4 INTRODUCTION 01:00:00 BRIEF HISTORY OF PENCIL DRAWING 00:15:00 GETTING STARTED 01:00:00 LEARNING THE BASICS OF DRAWING AND SKETCHING 01:00:00 Basic Perspectives on Drawing 01:00:00 Basic Elements of Light, Shadows, and Shading 01:00:00 Different Shading Techniques 00:15:00 How to Add Tones and Values? 00:30:00 FINISHING TOUCHES 00:30:00 MIXED MEDIA APPLICATIONS 01:00:00 Drawing with Pencils in Oil Painting 01:00:00 CONCLUSION 00:15:00 Module-5 Start Your Own Art Business 00:15:00 Steps to Creating a Successful Business from Your Art 01:00:00 How to Write an Artist Business Plan 00:30:00 Module-6 Introduction 00:30:00 Incorporate Your Business 01:00:00 Employing Or Contracting - What Is The Difference? 00:30:00 From Where Can You Hire Workers 01:00:00 Getting Insurance 01:00:00 Getting Ready - Portfolios, Flyers And Cards 00:30:00 What Do You Need For Outdoor Painting 01:00:00 What Do You Need To Know About Indoor Painting 01:00:00 Fancy Indoor Painting Touches - How To Get Them 00:30:00 Paint Primer 101 01:00:00 How To Get Customers 01:00:00 The Non-Paying Customers! 00:30:00 Module-7 Safety Tips for Painting 00:15:00 Interior Painting 00:15:00 Painting your Interiors 00:15:00 Walls and Ceilings 00:15:00 Windows and Doors 00:15:00 Wallpapering 00:15:00 Applying Wallpaper 00:15:00 Exterior Painting 00:15:00 Product Selection 00:15:00 Application Tips & Techniques 00:15:00 Module-8 Priming & Staining 00:30:00 Working over a ground color 00:30:00 Building Up: Oil & Acrylic 00:30:00 Surface Mixing 00:30:00 Corrections 00:30:00 Brushwork 00:30:00 Module-9 HOW TO REARRANGE A ROOM 02:00:00 HOW TO ANALYZE A ROOM AS PROFESSIONALS DO BEFORE YOU 01:00:00 HOW TO CREATE A ROOM 02:00:00 HOW TO DETERMINE CHARACTERS OF HANGINGS AND FURNITURES-COVERING FOR A GIVEN ROOM 01:00:00 CANDLESTICKS, LAMPS, FIXTURES FOR GAS AND ELECTRICITY, AND SHADES 01:00:00 WINDOW SHADES AND AWNINGS 00:30:00 TREATMENT OF PICTURES AND PICTURE FRAMES 01:00:00 TREATMENT OF PIANO CASES 00:15:00 TREATMENT OF DINING-ROOM BUFFETS AND DRESSING-TABLES 00:15:00 TREATMENT OF WORK TABLES, BIRD CAGES, DOG BASKETS AND FISH GLOBES 00:30:00 TREATMENT OF FIREPLACES 00:30:00 TREATMENT OF BATHROOMS 01:00:00 PERIOD ROOMS 01:00:00 PERIODS IN FURNITURE 01:00:00 CONTINUATION OF PERIODS IN FURNITURE 01:00:00 THE GOTHIC PERIOD 00:30:00 THE RENAISSANCE 01:00:00 FRENCH FURNITURE 01:00:00 THE PERIODS OF THE THREE LOUIS 01:00:00 THE MAHOGANY PERIOD 02:00:00 THE COLONIAL PERIOD 00:30:00 THE REVIVAL OF DIRECTOIRE AND EMPIRE FURNITURE 00:30:00 THE VICTORIAN PERIOD 00:30:00 PAINTED FURNITURE 00:30:00 TREATMENT OF AN INEXPENSIVE BEDROOM 01:00:00 TREATMENT OF A GUEST ROOM (Where economy is not an item of importance) 01:00:00 A MODERN HOUSE IN WHICH GENUINE JACOBEAN FURNITURE IS APPROPRIATELY SET 00:30:00 UNCONVENTIONAL BREAKFAST-ROOMS AND SPORTS BALCONIES 01:00:00 SUN-ROOMS 01:00:00 TREATMENT OF A WOMAN'S DRESSING-ROOM 00:30:00 THE TREATMENT OF CLOSETS 00:30:00 TREATMENT OF A NARROW HALL 00:15:00 TREATMENT OF A VERY SHADED LIVING-ROOM 00:15:00 SERVANTS' ROOMS 00:15:00 THE BABY'S ROOMS: THE DAY ROOM, THE NIGHT ROOM 01:00:00 ROOMS FOR THE ELDERLY 01:00:00 A YOUNG GIRL'S ROOM 01:00:00 THE YOUNG BOY'S ROOM 00:30:00 TABLE DECORATION 01:00:00 WHAT TO AVOID IN INTERIOR DECORATION: RULES FOR BEGINNERS 01:00:00 FADS IN COLLECTING 01:00:00 WEDGWOOD POTTERY; OLD AND MODERN 01:00:00 ITALIAN POTTERY 00:15:00 VENETIAN GLASS, OLD AND MODERN 00:30:00 CONCLUSION 00:15:00 Mock Exam Final Exam Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Do your inner guts tell you to pursue a career in the hairdresser industry? Have you spent a lot of time watching videos on hair designs? If you are one of them, the Hairdressing Training course is one of the best online hairdressing courses for you. In the UK, the hairdressing sector has grown 35%. Luckily, a hairdresser's average income is more than £25,000 annually, making it a lucrative career in the UK.  The first module of this CPD-accredited online hairdressing course focuses on the role of hairdressers and how it evolves with the trend. This module will educate you to assess the human skull so that you can create fabulous hairstyles for your clients. You will also explore versatile hair types like curly, straight, and wavy. It will help you to understand hair properties and the impact of specific hair types on hairstyling. The first module ends with introducing you to the hair salon equipment and furniture. The second module will teach you how to create sleek and timeless one-length hairstyles. Moreover, you will discover the hidden technique that leads to a smooth, balanced, uniform layer. Furthermore, the skills to add volume and texture to the long hair will also be introduced. With the completion of module three, you will become a master in cutting and styling curly hair and fringe hair. Module three of this online hairdresser course for beginners focuses on hair braiding. You will learn about multiple types of hair braids and their applications. Besides, an in-depth lesson on health and safety will help you to ensure a safe & hygienic salon environment for the clients. Get enrolled in this online hairdressing course with certificates for a secure future in the hairdressing industry. Learning Outcome Ability to identify versatile hair types and to recommend suitable styling & products Gain expertise in analysing face shape to provide top-notch hairstyles to enhance client's facial shape Achieve the skills to perform multiple hair cutting along with precisions Acquire the proficiency to create intricate braided hairstyles Learn salon safety & hygiene to ensure the healthy well-being of clients Capable of doing creative hair styling for clients Entry Requirement Passionate about hairdressing Basic academic knowledge Fast internet connection Smartphone/Laptop/PC Career path Professional Hair Stylist Salon Manager Freelance Hairdresser Hair Educator Fashion Stylist Product Sales Representative Course Curriculum Introduction to Hairdressing Who are Hairdressers? 00:15:00 Anatomy of the skull 00:15:00 Hair Type 00:15:00 Face shapes, Characteristics & Style concepts 00:15:00 Hair Salon Equipments & Furnitures 00:15:00 Hair Cutting Cutting the Hair 00:15:00 Cutting hair - One length hair 00:15:00 Cutting hair - Uniform Layer 00:15:00 Cutting hair - Short graduation 00:15:00 Cutting hair - Long graduation 00:15:00 Cutting hair - Curly hair 00:15:00 Cutting hair - Fringes 00:15:00 Hair Braiding Braiding Hair 00:00:00 Applying Braiding Techniques 01:00:00 Finishing Hair 00:15:00 Health & Safety in Hairdressing 01:00:00 Hair Styling About Of Hair Style 00:30:00 Check Out Your Face Shape 01:00:00 Choosing Your Style On Your Shape 01:00:00 Best Hairstyles For A Long Face 00:30:00 Best Hairstyles For A Square Face 00:30:00 Best Hairstyles For A Round Face 00:30:00 Best Hairstyles For A Heart Shaped Face 01:00:00 How To Love Your Style 00:30:00 Wrapping Up 00:02:00 Recommended Materials Workbook - Hairdressing Training 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

This comprehensive Solidity course is designed for individuals seeking to expand their understanding of Ethereum, blockchain, and smart contract development. Whether you are an aspiring blockchain developer or an Ethereum enthusiast, this course covers all the essential topics including Solidity programming, DApp development, cryptocurrency, and more.

Level 2 Microsoft Office Essentials

Description This course is aimed at the excel user who already knows the basics of Excel 2007. This course will help you to go beyond the basics - to reach a higher-intermediate level. With shortcuts, tricks and tips - you will be able to work smarter and faster. If you want to be fairly competent on the software, then this course will be very handy. Its a lot quicker to be shown things, then to try and muddle through and work things out by yourself. Guaranteed, there'll be some items which we cover, that you have no idea that Excel was capable of doing! We don't want you to spend a day of your life in the classroom... learn 99 quick and very useful, practical things which you can apply on your job or on your projects. We'll cover: Working with Data - using series, symbols and special characters, hide rows and freeze panels Formulas and Functions - Calculate the duration between two dates/times, best loan terms, create conditional formula and conditional sums Copying Data - transposing rows into columns and paste specials Using Excel lists - sort and filter a list, remove duplicate records, count filtered records, look up information in a list Data Patterns - Pivot tables, pivot charts, what-if analysis Creating charts - histogram, trendlines, piecharts, error bars Presenting data - formatting columns and numbers Saving and printing worksheets - printing multiple worksheets, area, cell ranges, repeat headings of a row or column Extending excel - hyperlinks, embed a chart, importing a worksheet Customizing Excel - custom workspace, custom view, macros The target audience is those who have a basic level with Excel and want to learn other handy functions and features. We use Excel 2007 only in this course. If you have Excel 2003, this course will be difficult to follow as although the functions and features exist in 2003, the layout changed very dramatically between the two versions. Excel 2007 isn't too dissimilar from 2010. Where necessary, we provide a spreadsheet - but as long as you have Excel 2007, you'll be able to copy and do exactly what you see on the screen by pausing the video and following along. The course will take approx 7.5 hours to complete. Take this course if you want to take your basic understanding of Excel to a higher intermediate-level. What Will I Learn? Work with Formulas and Functions Copy data and formats Use excel lists Create charts Present worksheets nicely Save and print worksheets Who is the target audience? This is for those who are beginners in Excel and want to take it further to higher intermediate level - using Excel 2007 You should know the 'basics' in Excel and we take it from near-beginner, to higher intermediate Requirements Students will need to have Excel 2007 installed, as this is the system used in the teaching Introduction to the course and your tutor Data Enter numbers and fractions 00:05:00 Dates and Times 00:08:00 Name Cells and Ranges 00:04:00 Validate Data entry using a pick list FREE 00:07:00 Extend a series of dates with autofill 00:04:00 Add a symbol or special character 00:04:00 Compare multiple spreadsheets using freeze panels 00:06:00 Hide rows 00:04:00 Keyboard 00:10:00 Speak Cells 00:04:00 Find and replace data 00:10:00 Formulas and Functions Add values 00:03:00 Function wizard 00:06:00 Formulas with comments 00:04:00 OneNote 00:06:00 Define a constant 00:04:00 Apply names in functions 00:05:00 Figure out the best loan terms 00:04:00 Internal Rates of Return 00:04:00 Nth largest value 00:04:00 Large, Small, Max, Min 00:04:00 Conditional formula 00:03:00 Conditional formula with names 00:04:00 Conditional sum 00:03:00 Count If 00:02:00 Inner calculator 00:02:00 Square Roots 00:03:00 Calculate the duration between two times 00:04:00 Calculate days between two dates 00:04:00 Copying Data, Formats etc., Copy a range 00:03:00 Transpose a row into a column FREE 00:02:00 Chart formatting 00:07:00 Copy styles to another workbook 00:07:00 Paste special and copying worksheets 00:06:00 Track changes while Editing 00:06:00 Lists Enter list data using a form 00:05:00 Searching through a data list 00:04:00 Import a word list into excel 00:04:00 Sort a list 00:02:00 Filter a list 00:02:00 Sort by multiple criteria FREE 00:03:00 Find averages in a sorted group 00:05:00 Filter by multiple criteria 00:03:00 Remove duplicate records from a list 00:03:00 Count filtered records 00:07:00 Filter by multiple criteria in the same column 00:06:00 Chart a filtered list 00:02:00 Look up information in a List 00:05:00 Data Patterns Create a PivotTable 00:05:00 Modify a PivotTable and layout 00:03:00 Find the average of a field 00:04:00 Create a calculated field 00:03:00 Calculated fields and charts FREE 00:02:00 Hide rows and columns in a PivotTable 00:02:00 AutoFormat a PivotTable 00:01:00 Create a PivotChart 00:03:00 Turning on the Data Analysis function so that statistical information can be run 00:02:00 Describe Data with Statistics 00:03:00 Discover associations within your data 00:03:00 Product Numbers 00:02:00 What-if analysis 00:05:00 Goal seek 00:06:00 Creating Charts Create a Chart 00:06:00 Modify Chart details 00:04:00 Change the Chart Type 00:03:00 Add a Trendline to a Chart 00:06:00 Remove Chart Data 00:02:00 Add chart data 00:02:00 Missing chart data 00:04:00 Error bars 00:04:00 Pull a slice from a Pie Chart 00:03:00 Label slices of a Pie Chart 00:04:00 Histogram 00:06:00 Paste a chart into Word 00:03:00 Amending a chart in Word 00:02:00 Paste-link a Chart into Word 00:05:00 Worksheets Format Numbers as Percentages 00:04:00 Format Currencies in Currency and Accounting Formats 00:03:00 Format Column Headings 00:05:00 Format Quickly with Format painter FREE 00:02:00 Insert a background image into your worksheet 00:03:00 Create a Transparent image 00:03:00 Saving and Printing Worksheets Save a workbook as a Template 00:07:00 Save a workbook as an XML spreadsheet 00:05:00 Print multiple cell ranges on One Page 00:03:00 Print multiple worksheets of a workbook 00:01:00 Page set up, header, footer, margins - 1 page printing 00:04:00 Repeat Headings of a Row or Column 00:07:00 Print functions to show calculations & comments 00:07:00 Extending Excel Hyperlink a worksheet to another office document 00:03:00 Embed a chart within PowerPoint 00:05:00 Publish an Interactive Workbook 00:05:00 Import a Worksheet into Access 00:09:00 Use Excel Data to create labels in Word 00:10:00 Customizing Excel Launch a specific Workbook when Excel Opens 00:03:00 Save Time by Creating a Custom View 00:03:00 Create a Custom Number Format 00:06:00 Changing Text to Columns 00:05:00 Create a Macro to Format Numbers 00:06:00 Online Live Webinar Course-S3_W4_L1 - 42 - Excel Made simple 01:00:00