9505 Confidence courses in Congleton delivered Online

[vc_row][vc_column][vc_column_text] Description: In this course, you will be able to identify the elements of the Microsoft Excel interface. You will learn how to create a basic worksheet and to get comfortable with the parts of the screen. This Microsoft Office 2013 Excel Beginners - Complete Video Course covers the basic functions and features of Excel 2013. You will learn about calculations and how to modify and format a worksheet. You will also learn how to customize the Excel environment and how to manage and print workbooks. In this course, you will take your knowledge up a notch as you get acquainted with Microsoft Excel 2013's most sophisticated features. If you think you know Excel 2013, think again, as this course goes way beyond the basics, leaving you with knowledge of all of the best Excel tips and tricks out there. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2013 Excel Beginners - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2013 Excel Beginners - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.[/vc_column_text][/vc_column][/vc_row] Getting Started with Microsoft Excel 2013 Identify the Elements of the Excel Interface FREE 00:14:00 Create a Basic Worksheet 00:16:00 Use the Help System 00:04:00 Performing Calculations Create Formulas in a Worksheet 00:15:00 Insert Functions in a Worksheet 00:13:00 Reuse Formulas 00:15:00 Modifying a Worksheet Manipulate Data 00:13:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:08:00 Search for and Replace Data 00:12:00 Spell Check a Worksheet 00:06:00 Formatting a Worksheet Modify Fonts 00:11:00 Add Borders and Color to Cells 00:10:00 Apply Number Formats 00:10:00 Align Cell Contents 00:10:00 Apply Cell Styles 00:08:00 Printing Workbook Contents Define the Basic Page Layout for a Workbook 00:16:00 Refine the Page Layout and Apply Print Options 00:13:00 Managing Large Workbooks Format Worksheet Tabs 00:03:00 Manage Worksheets 00:09:00 Manage the View of Worksheets and Workbooks 00:10:00 Customizing the Excel Environment Customize General and Language Options 00:08:00 Customize Formula Options 00:04:00 Customize Proofing and Save Options 00:04:00 Customize the Ribbon and Quick Access Toolbar 00:04:00 Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:06:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: We all know the importance of good writing. In business writing, the language is concrete, the point of view is clear and well expressed. This course will help you will get all the tools to become a good writer, and how to use writing skills for the improvement of your business. Report writing is a skill you will use again and again in your business. Here, you will learn how to write reports and proposal's, you will get a writing skill to present information in formal, informal, and proposal style. This Professional Business Writing will brush up your writing skills more if you are already a good writer. So, thinking to get an improvement in your writing skills? Join this course now. Learning Outcomes: The worth of accurate, written communication Learn how to write proofread your task so that it is clear, accomplished and correct How to exploit your skills in the realistic circumstances The correct format for memos, letters, as well as e-mails Prepare reports and proposals that inform, persuade, and provide information. Review your work so that it is clear, concise, complete, and correct. Apply these skills in real work applications. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Professional Business Writing is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Professional Business Writing is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module 01 Active and Passive Voice 00:15:00 Be Clear 00:15:00 Be Concise 00:00:00 Be Correct 00:05:00 Inclusive Language 00:05:00 Manners and Courtesy 00:05:00 Practical Language 00:15:00 Punctuation 00:15:00 Readability Index 00:15:00 Reviewing Your Writing 00:15:00 Sentence Construction 00:05:00 Sentences and Sentence Types 00:15:00 Spelling and Proofreading 00:15:00 Why Write? 00:15:00 Word Agreement 00:05:00 Writing Business Letters 00:15:00 Writing Effective E-mails 00:15:00 Module 02 The Stages of Report Writing 00:15:00 The First Stage - Investigating 00:15:00 The Second Stage - Planning 00:15:00 The Third Stage - Writing 00:15:00 The Fourth Stage - Revising 00:15:00 Using Headings 00:15:00 Using Charts and Graphs 00:15:00 The Proposal 00:15:00 Persuasion 00:30:00 Giving Credit 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Outlook helps you communicate faster with more ways to organize your professional email, contacts, and calendar. Learn about Outlook 2007 features, support options, and tips to help you get more out of your email. In this Microsoft Office 2007 Outlook Beginners - Complete Video Course you will learn the basic components and functions of Microsoft Outlook 2007. You will be introduced with Outlook 2007 Window. It will provide you with an overview of the features and functions of Microsoft Office Outlook 2007. You will learn to connect to your primary e-mail account, troubleshoot the startup wizard, personalize your outlook workspace, explore the advanced toolbar, work in the contact window, save and update contact information, and more. This basic series is designed for them who want to learn beginning-level Outlook 2007 skills. So, if you are interested to learn all the basics of Microsoft Office Outlook 2007, then you should join this course now. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2007 Outlook Beginners - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2007 Outlook Beginners - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started The Program Window FREE 00:15:00 Outlook Today 00:02:00 Getting Help 00:02:00 E-mail E-mail Accounts 00:07:00 Creating and Sending E-mail Messages 00:10:00 Creating and Sending E-mail Messages 00:10:00 Working with Messages 00:07:00 Attachments 00:07:00 E-mail Management Message Options 00:13:00 E-mail Security 00:14:00 Junk E-mail 00:06:00 Search Folders 00:02:00 Printing Messages 00:03:00 Contact Management Managing Contacts 00:17:00 Distribution Lists 00:04:00 Electronic Business Cards 00:10:00 Tasks Working with Tasks 00:14:00 Managing Tasks 00:08:00 Appointments and Events Creating and Sending Appointments 00:14:00 Modifying Appointments 00:03:00 Calendar Views 00:08:00 Events 00:05:00 Meeting Requests and Responses Meeting Requests 00:12:00 Meeting Request Responses 00:04:00 Managing Meeting Responses 00:03:00 Mock Exam Mock Exam- Microsoft Office 2007 Outlook Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Outlook Beginners - Complete Video Course 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Learn all the essential skills to become an expert in Lomi Lomi Massage. From this comprehensive Lomi Lomi Massage course, you will be able to understand the principles of Lomi Lomi Massage. In the step-by-step training process, you will acquire practical skills along with theoretical knowledge. The Qualified professionals will assist you throughout this learning process. This Lomi Lomi Massage is structured to ensure you have all the adequate skills to secure a position in this competitive industry. You will achieve the confidence and competency to bear all the responsibilities of this profession. The course will add all the right credentials to your resume and increase your employability in this growing industry. Who is this course for? Anyone who is now employed in this field or who aspires to be one should take this course. Your knowledge will grow through taking this course, which will also strengthen your resume. To demonstrate your newly gained knowledge, develop crucial abilities and receive a professional credential. 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. Certification After you have successfully completed the course, 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 hardcopy at the cost of £39 or in PDF format at the 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 recognized 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 The Lomi Lomi Massage course is intended to assist you in obtaining the dream job or maybe the promotion you've always desired. With the assistance and direction of our Lomi Lomi Massage course, learn the vital abilities and knowledge you require to succeed in your life.   Getting Started Introduction 00:03:00 Forearm technique-vital elements to your massage! 00:13:00 The Table-The 4 most Important things about your Table 00:07:00 Creams or oils 00:04:00 The set-up. Do Not do what I did 00:05:00 One factor that makes a HUGE Difference! 00:03:00 It's all in the Timing! 00:04:00 Contraindications to massage, intake forms and more 00:01:00 Why I Don't include these things in my massages 00:04:00 A close look at using your forearms 00:02:00 Do no harm 00:01:00 The Perfect Person to Practice your massage on 00:01:00 Why most therapists don't last and what you SHOULD do instead 00:07:00 Practice Makes Perfect 00:02:00 Putting it all together 00:02:00 Lomi Lomi Massage Techniques A close look at using your forearms 00:02:00 The Back 00:13:00 Another look at the back sequence 00:14:00 The back of the legs 00:09:00 The back of the legs opposite side 00:09:00 The front of the legs 00:03:00 The front of the legs opposite side 00:03:00 The arms 00:07:00 The arms opposite side 00:07:00 The neck and head 00:06:00 The whole sequence Whole Massage Sequence 00:57:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Description: Adult Nursing & Social Care sectors have always been popular with those who aspire to work within the changing environment of today's modern social and health care service. This Adult Nursing and Social Care Training will be of great interest to all health care professionals who would like to learn more about advanced Nursing practices and procedures in adult patient care. The course will provide an overview of the skills and techniques required in areas such as advanced patient hygiene procedures, environmental health and safety awareness for the practice nurse, and how to ensure patient safety and comfort in the adult care setting. You will learn how to assess the needs of the patient through acute and long-term illness, promote health and wellbeing, communicate effectively with professional colleagues, and provide sensitive support for the patient and their families. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Adult Nursing and Social Care Training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Adult Nursing and Social Care Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Adult Nursing Introduction to Adult Nursing 00:05:00 Communication in Nursing 00:15:00 Communication Theories in Nursing 00:30:00 Health and Safety in Nursing 01:00:00 Psychology of Older Age What is 'Developmental Psychology'? 00:05:00 What is 'Gerontology'? 00:09:00 What we consider as 'old age' 00:09:00 What is 'ageing' and how it happens 00:08:00 Common stereotypes of older people 00:08:00 How stereotyping affects older people 00:08:00 Life stages and Theories 00:11:00 What do we look forward to in our older age? 00:06:00 Mental Health and Old Age Memory-related issues 00:12:00 Learning disabilities 00:08:00 Alzheimer's disease and Dementia 00:09:00 Chronic illness and Disabilities 00:08:00 Substance abuse (addictions) 00:06:00 Improving Health and Wellbeing The effects of exercising 00:09:00 Is it worth eating 'healthy' in older age? 00:09:00 What else affects 'health' and 'wellbeing'? 00:08:00 Caring for older people 00:06:00 Dementia Awareness Awareness and Misunderstanding 00:30:00 Symptoms of Dementia 01:00:00 Prevention and Treatment 01:00:00 The Impact Of Stigma 01:00:00 Caring for Dementia Victims 02:00:00 Home Adaptations for People with Dementia 01:00:00 Mock Exam Mock Exam - Adult Nursing and Social Care Training 00:20:00 Final Exam Final Exam - Adult Nursing and Social Care Training 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Description: Windows 10 is the latest iteration of Microsoft's widely used Windows operating system. This new version of Windows incorporates hundreds of new features as well as improvements to existing ones. This Microsoft Windows 10 Transition from 8.1 will give you the knowledge of Windows 8.1 users become familiar with the many changes that have been made to Windows with release. It focuses on new and improved features in Windows 10, such as the return of the Start menu, the addition of Microsoft Edge, and more. If you are interested to increase your knowledge and skills, you can join this course now. Learning Outcomes: Learn to use desktop and Start menu, multitask using apps, and focus on the new Snap Assist feature Familiarize yourself with notifications, Action Center, Contana, search fields, and virtual desktops in the Windows 10 environment before learning how to connect devices to PC Customize the Window according to your needs using the Settings window and Control panel to modify Windows settings Further personalize the lock screen, desktop, and get introduced to OneDrive - a prominent feature of this version of Windows Work with 3 key productivity apps: Mail, Calendar and Camera Have fun with the entertainment side of Windows 10 by getting to know Groove Music, Movies &TV, and Xbox apps Browse the internet using Microsoft Edge Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Windows 10 Transition from 8.1 is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Windows 10 Transition from 8.1 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Navigating the Windows 10 Environment Navigate the Desktop 01:00:00 Explore the Start Menu 01:00:00 Multitask with Apps 00:15:00 Working with the Windows 10 Environment View Notifications 00:30:00 Search Your Computer 01:00:00 Work with Virtual Desktops 00:30:00 Connect Devices to Your PC 00:30:00 Customizing the Windows 10 Environment Change Basic Windows Settings 01:00:00 Customize the Lock Screen 00:30:00 Customize the Desktop 00:30:00 Store and Share Files with OneDrive 00:30:00 Working with Apps in Windows 10 Use Mail 01:00:00 Use Calendar 01:00:00 Use Camera 00:30:00 Having Fun in Windows 10 Use Groove Music 00:30:00 Use Movies & TV 00:30:00 Use Xbox 01:00:00 Using Microsoft Edge Navigate Microsoft Edge 00:30:00 Use Microsoft Edge 01:00:00 Manage Tabs 00:15:00 Modify Microsoft Edge Options 01:00:00 Mock Exam Mock Exam- Microsoft Windows 10 Transition from 8.1 00:20:00 Final Exam Final Exam- Microsoft Windows 10 Transition from 8.1 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: If you are already able to create, edit, and print word 2016 documents, then this next level is designed for you. In this Microsoft Office 2016 Word Intermediate - Complete Video Course you will learn advanced formatting, how to use word 2016's advanced editing tools, work with image, including placing and sizing images, wrapping text around images, and using borders and effects, how to adjust page orientation and layout, work with columns, work with page and section breaks, document views, using the navigation pane, and viewing multiple windows, and more. You can join this course, if you have basic skills and knowledge with Microsoft Word 2016 and want to take another step forward or want to learn the topics covered in this course in the 2016 interface. So, don't be late, come and join this course now. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Word Intermediate - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Word Intermediate - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Organizing Content Using Tables and Charts Sort Table Data FREE 00:07:00 Control Cell Layout 00:08:00 Perform Calculations in a Table 00:10:00 Create a Chart 00:11:00 Add an Excel Table to a Word Document 00:05:00 Customizing Formats Using Styles and Themes Create and Modify Text Styles 00:17:00 Create Custom List or Table Styles 00:07:00 Apply Document Themes 00:09:00 Inserting Content Using Quick Parts Insert Building Blocks 00:10:00 Create and Modify Building Blocks 00:07:00 Insert Fields Using Quick Parts 00:10:00 Using Templates to Automate Document Formatting Create a Document Using a Template 00:09:00 Create a Template 00:10:00 Manage Templates with the Template Organizer 00:05:00 Controlling the Flow of a Document Control Paragraph Flow 00:07:00 Insert Section Breaks 00:04:00 Insert Columns 00:05:00 Link Text Boxes to Control Text Flow 00:09:00 Simplifying and Managing Long Documents Insert Blank and Cover Pages 00:05:00 Insert an Index 00:09:00 Insert a Table of Contents 00:06:00 Insert an Ancillary Table 00:10:00 Manage Outlines 00:06:00 Create a Master Document 00:09:00 Using Mail Merge to Create Letters, Envelopes, and Labels The Mail Merge Feature 00:23:00 Merge Envelopes and Labels 00:08:00 Mock Exam Mock Exam- Microsoft Office 2016 Word Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Word Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2007 Excel Advanced - Complete Video Course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts and record basic macros. You will also learn to use key advanced financial, logical, text, statistical and math, and lookup functions, audit formulas for errors, analyze data using subtotals, goal seek and the scenario manager, use custom and conditional formatting, manage data with tables, filtering and sorting, create, edit and format PivotTables and PivotCharts, import and export date to and from a workbook, create and use macros. So, by taking this course you will have a complete understanding of the higher functions of Excel. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2007 Excel Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2007 Excel Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Advanced Functions Logical Functions FREE 00:08:00 Math and Statistical Functions 00:06:00 Financial Functions 00:03:00 Displaying and Printing Formulas 00:02:00 Lookups and Data Tables Using Lookup Functions 00:03:00 Using MATCH and INDEX 00:01:00 Creating Data Tables 00:03:00 Advanced List Management Validating Cell Entries 00:01:00 Exploring Database Functions 00:01:00 PivotTables and PivotCharts Working with PivotTables 00:04:00 Rearranging PivotTables 00:02:00 Formatting PivotTables 00:02:00 PivotCharts 00:01:00 Exporting and Importing Exporting and Importing Text Files 00:07:00 Exporting and Importing XML Data 00:02:00 Querying External Databases 00:03:00 Analytical Options Goal Seek and Solver 00:05:00 The Analysis ToolPak 00:01:00 Scenarios 00:02:00 Views 00:01:00 Macros and Custom Functions Running and Recording a Macro 00:02:00 Working with VBA Code 00:01:00 Creating Functions 00:05:00 Conditional Formatting and SmartArt Conditional Formatting with Graphics 00:03:00 SmartArt Graphics 00:02:00 Mock Exam Mock Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Microsoft Office offers a wide range of working interface. Outlook app is one of them. It makes human life easier and faster than the previous time. Do you want to know how it works? How does it assist in human's the fastest activities? Look at the MS Office 365 - Outlook Web App course. It can solve your desired quest. The course incorporates the functions of Outlook such as reading and answering to emails, formatting and creating messages, regulating the mailbox, creating folders for organizations and the printing emails which enable the students working ability knowing all these facts. theMS Office 365 - Outlook Web App course will also teach how to maintain calendar, arrange meetings and appointment, and work with contacts and tasks. The purpose of the course is to make a learner far better than others. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? MS Office 365 - Outlook Web App is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our MS Office 365 - Outlook Web App is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:02:00 Getting Started With Outlook Online Navigating the Outlook Views 00:08:00 Working with the My Day View 00:03:00 Creating a New Email Message 00:05:00 Attaching a File 00:03:00 Working with Email Replying to an Email 00:03:00 Liking an Email Message 00:02:00 Formatting Email Text 00:03:00 Working with Conversation View 00:02:00 Deleting Emails 00:04:00 Printing Emails 00:02:00 Using the Notes Feature 00:03:00 Managing the Outlook Mailbox Using Sweep 00:02:00 Flagging Emails 00:02:00 Creating a Rule 00:04:00 Editing a Rule 00:02:00 Working with Favorites 00:02:00 Organizing Mail Working with Folders 00:07:00 Working with Clutter 00:04:00 Pinning and Searching for Emails 00:03:00 Using the Focused Inbox 00:05:00 Using Groups 00:05:00 Customizing Outlook Customizing the Environment 00:07:00 Setting Out of Office 00:05:00 Showing BCC and Using Read Receipts 00:04:00 Working with Contacts 00:07:00 Exploring the Calendar Exploring the Calendar View 00:05:00 Working with Calendars 00:07:00 Working with Shared Calendars 00:06:00 Working with Tasks Viewing Tasks 00:02:00 Creating Tasks 00:03:00 Conclusion Course Recap 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: The 70-410 - Installing and Configuring Windows Server 2012 R2 (MCSA/MCSE) course teaches you how to install and configure Windows Server 2012 R2. You will learn the basics of the server, server 2012 management, working with server core, and PowerShell examples for user management. Throughout the course, you will learn the system of configuring local storage. The method of file shares and permissions and configure print and document services will also be taught in the course. Apart from these, you will able to know about remote management and virtualization. The course also includes discussion on the components of network infrastructure, TCP/IP diagnostics and IPv6 over IPv4 tunneling. Finally, you will learn about the DHCP, DNS, Active Directory domain services and Windows security. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? 70-410 - Installing and Configuring Windows Server 2012 R2 (MCSA/MCSE) training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our 70-410 - Installing and Configuring Windows Server 2012 R2 (MCSA/MCSE) training course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Server 2012 Overview On Premise vs Cloud FREE 00:30:00 Windows Server Installation 00:09:00 Windows Activation 00:15:00 Windows Server 2012 Management Server Manager 00:22:00 Working with Server Core Introduction to PowerShell 00:33:00 PowerShell Examples for User Management 00:12:00 Configuring Local Storage Key Features of Storage 00:45:00 Configure Basic Disks 00:19:00 Configure File and Print Access File Shares and Permissions 00:25:00 Configure Print and Document Services 00:10:00 Remote Management and Virtualization Remote Management 00:22:00 Virtualization 00:26:00 Differencing Disks 00:18:00 TCP/IP Protocol Suite Components of Network Infrastructure 00:52:00 TCP_IP Diagnostics 00:51:00 IPv6 Over IPv4 Tunneling 00:08:00 DHCP and DNS DNS 00:41:00 DHCP 00:22:00 Overview of Active Directory Domain Services Physical Components of Active Directory 00:59:00 Operations Master Roles 00:29:00 The AD DS Logon Process 00:13:00 User Accounts 00:50:00 Computer Accounts 00:22:00 Windows Security Windows Security 00:18:00 Group Policy 00:21:00 Software Restriction Policies 00:04:00 Windows Firewall 00:09:00 Mock Exam Mock Exam- 70-410 - Installing and Configuring Windows Server 2012 R2 (MCSA/MCSE) 00:20:00 Final Exam Final Exam- 70-410 - Installing and Configuring Windows Server 2012 R2 (MCSA/MCSE) 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00