47639 Courses in Cardiff delivered On Demand

Course Overview From maintaining the files to ensuring confidentiality, a medical secretary has a wide range of duties. Therefore, they are required to have adequate skills to pull off all the tasks. The Medical Secretary Course will help you acquire these skills. In this course, you will grasp the ability to become a proficient medical secretary. The Medical Secretary Course will show you the roles and responsibilities of a medical secretary. You will learn how to organise schedules and maintain medical records. From the easy-to-follow modules, you will receive a clear understanding of the effective filing system. You will be able to learn the medical jargon and terminology. In addition, this course will equip you with the skills to manage the stocks and supplies. After completing this Medical Secretary Course, you will receive a valuable certificate. This certificate will help you build an impressive resume. Enrol now and start building your skills.  What You Will Learn Learn the principles of organising schedules Understand the strategies of maintaining medical records Enrich your knowledge of medical jargon and terminology Know the methods of effective filing system Develop the ability to maintain confidentiality in the workplace Grasp the skills to control stocks and supplies Understand how to maintain workplace safety Why Should You Choose this Medical Secretary Course Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment, and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential Who is this Course for? The Medical Secretary Course is for current and future medical secretaries. Anyone interested in learning about this area can also take this course.  Requirements Our Medical Secretary Course is fully compatible with any kind of device. Whether you are using Windows computers, 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 This Medical Secretary Course will assist you in pursuing a career in the relevant fields. Medical Secretary (Salary Range £13,000-£34,000) Medical Secretary Course Module 01: Introduction to Medical Secretary 00:15:00 Module 02: Organise Schedules 00:21:00 Module 03: Maintaining Medical Records 00:19:00 Module 04: Effective Filing Systems in Medical Offices 00:16:00 Module 05: Confidentiality in a Medical Environment 00:14:00 Module 06: Controlling Stocks and Supplies 00:09:00 Module 07: Medical Jargon and Terminology 00:25:00 Module 08: Maintaining Workplace Safety 00:20:00 Module 09: Information Technology in Health Care 00:14:00 Module 10: Legal aspects and Ethics 00:19:00 Assignment Assignment - Medical Secretary Course 02:00:00

Course Overview From maintaining the school culture to supporting child development, a school administrator's duties are a mixture of diverse roles. As a result, it becomes difficult to complete the tasks without proper training. So, before you join this sector, train yourself with the School Administrator Training course. This all-in-one course will equip you with the core skills to become an excellent school administrator. In the School Administrator Training course, you will learn the essentials of UK schools. The easy-to-follow modules will teach you the school culture strategies to maintain. You will pick up the fundamental skills to carry out the administrative duties and manage everything proficiently. The course will also help you acquire the skills to safeguard children and support their development. In addition, there will be lessons on how to manage the school premises.  This School Administrator Training course will ensure you are ready to take up the challenges that come with this job. Along with that, you will receive a valuable certificate. This certificate will boost your employability. Enrol now! What You Will Learn Learn about different types of schools in the UK Understand how to create and maintain a school culture Develop the essential skills for educational administration and management Grasp the principles of safeguarding children Build the competence to support child development Know how to help children to resolve their problem Gain the skills to control and manage the school premises Why Should You Choose this School Administrator Training Course Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment, and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential Who is this Course for? The School Administrator Training course is for those who want to develop their skills and knowledge to pursue a school administrator career.  Requirements Our School Administrator Training course is fully compatible with any kind of device. Whether you are using Windows computers, 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 This School Administrator Training course will assist you in pursuing a career in the relevant fields. School Administrator (Salary Range £17,000-£25,000) School Administrator Training Module 01: Introduction to School Administration 00:12:00 Module 02: Types of Schools In The UK 00:15:00 Module 03: Workplace Development 00:12:00 Module 04: Creating and Maintaining a School Culture 00:13:00 Module 05: Educational Administration and Management 00:11:00 Module 06: Safeguarding Students 00:14:00 Module 07: Child Development 00:13:00 Module 08: Serious Behavioural Issues and Problems of Students 00:12:00 Module 09: Managing School Premises 00:10:00 Module 10: Safety and Maintenance As an Administrator 00:08:00 Module 11: Self-Management and Dealing with Stress 00:13:00 Assignment Assignment - School Administrator Training 02:00:00

Learn to design using Adobe XD and create a real-world iPhone app with the Adobe XD Design Diploma course. Adobe XD is the all-in-one UX/UI solution for designing websites, mobile apps, and many more. In this course, you will learn the necessary tools of Adobe XD and learn how to apply Paper Prototyping techniques. The course guides you to create Interactive Prototype using the software and teaches you how to open sketch, Photoshop and Illustrator files with Adobe XD. Instead of these, you will master the techniques of collaborating with other developers using Zeplin & Avocode in the course. Upon completion, you will be able to design a fantastic iPhone (IOS) real world App in Adobe XD following iOS Design guidelines. What Will I Learn? Get grip on all the basic tools and techniques of Adobe XD Learn to apply Paper Prototyping techniques Design a stunning iPhone (IOS) real world App in Adobe XD Create Interactive Prototype using Adobe XD Export Assets and Design Specification for Developers Use Zeppelin and Avocode to Handoff your designs to developers Design with IOS Design guidelines Batch Export all assets in 1x 2x and 3x resolutions Requirements Install Adobe XD (at least trial version) MAC or Windows 10 at least Enterprise Edition Update Pencil, Black Pointer and Highlighter for Paper Prototyping Module: 01 What Is Adobe XD 00:07:00 Download And Install Adobe Xd 00:03:00 Why Adobe XD Is So Awesome - Talkinghead FREE 00:04:00 Updates And Upcoming Features Xd 00:03:00 Adobe XD Interface Welcome Screen FREE 00:03:00 Adobe Xd Top Nav Bar 00:02:00 Adoe Xd Interface Toolbar 00:02:00 Properties Panel Adoe Xd Interface 00:03:00 Xd Mac And Win Differences 00:05:00 First Assignment Simple One 00:07:00 Module: 02 Artboards and grids 00:08:00 Tools in xd 00:05:00 Rectangle tool to create buttons 00:06:00 Background and object blur 00:03:00 Ellipse tool 00:02:00 Basics of pen tool 00:03:00 Pen tool to creat Icons 00:06:00 Line tool 00:01:00 Text-tool 00:03:00 Colors Palettes 00:04:00 Color Gradients in Xd 00:06:00 Coolors.io 00:04:00 Masks in xd 00:06:00 Character styles in Xd 00:05:00 Creating and reusing symbols 00:07:00 Repeat grid 00:09:00 Common Shortcuts 00:06:00 Shortcut keys part2 00:08:00 Nested symbols in xd 00:06:00 Module: 03 S03L01 block-level design 00:12:00 S0302 Sketching First Design Idea-block Level Paper 00:08:00 S0303 First Paper Prototype- Adding Details 00:04:00 S0304 Vertical Horizontal Prototypes T Proto 00:09:00 S0305 Level Of Fidelity and prototypes 00:04:00 S0306 adding details to your block design 00:08:00 S0307 using ui design patterns 00:06:00 S0308 creating signup ios screen EXERCISE 00:14:00 Module: 04 S0401 Design preparations 00:05:00 S0402 Color scheme and insprations 00:05:00 S0403 Solving UX problems of old app 00:04:00 S0404 Welcome Screen design 00:10:00 S0405 designing the login screen 00:14:00 S0406 login-activated 00:12:00 S0407 Signup Screen 00:07:00 S0408 dashboard design part 1 00:12:00 S0409 dashboard design part 2 00:11:00 S0410 Sidebar Navigation 00:09:00 S0411 actitivies screen 00:11:00 S0412 sync screen 00:08:00 S0413 sync status update 00:04:00 S0414 using grids to improve designs further 00:05:00 S0415 refining style guides 00:08:00 S0416 IOS Design guidelines 00:09:00 Module: 05 S0501 fixing tap targets 00:06:00 S0502 prototype login and signup screens 00:10:00 S0503 prototyping dashboards and other screens 00:11:00 S0504 sharing prototype with others 00:04:00 S0505 recording prototype on mac 00:02:00 S0506 design Inspect beta 00:04:00 Module: 06 S0601 why to export in 1x 2x 3x 00:09:00 S0602 Perfect example of 1x 2x 3x 00:03:00 S0603 export artboards to create mockups 00:08:00 S0604 batch export 00:06:00 Module: 07 S0701 Live Preview Your App On Iphone 00:02:00 S0702 Developer handoff with Zeplin 00:13:00 S0703 Developer Handoff using Avocode 00:14:00 S0704 open sketch-psd-illustrato import 00:08:00 Module: 08 XD updtaes april may 2018 00:04:00 1st Exercise Asssignment-1 00:03:00 Second Assignment-1 00:03:00 Third Last Assinment - Google Drive 00:03:00 Resources Resources - Adobe XD Design Diploma 00:00:00

Description Here at iStudy, we put our heart and soul into every single course we design. We make sure that all our courses are designed and developed by industry experts. Our aim is to always provide value to our learners with quality courses. Our learners are our top priority, and you as a learner will gain tremendous knowledge and skill on this topic from this How to Earn from Home Training. The certification that you will receive upon completing this How to Earn from Home Training will help to boost your resume and will help you stand out among your peers in the competitive job market. Our course will help you get employed in the relevant field and advance your career. Enjoy this expertly made course from iStudy. Enrol now! Why You Should Choose How to Earn from Home Training Lifetime access to the course No hidden fees or exam charges Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? How to Earn from Home Training is CPD Qualification Standards and CiQ accredited, and IAO accredited. 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 backgrounds. Requirements Our How to Earn from Home 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. Earning Money from Home Course Promo 00:03:00 Lesson 1 - Introduction: Making Money From Home 00:03:00 Lesson 2 - Latest Ways to Earn Money Online 00:08:00 Lesson 3 - Work from home jobs for beginners 00:07:00 Lesson 4 - Best Selling Niches for making money online 00:10:00 Lesson 5 - How to make money from an awesome blog 00:08:00 Lesson 6 - How to make money selling online courses 00:09:00 Lesson 7 - How to sell your photos online for more cash 00:06:00 Lesson 8 - How to make money as a freelance writer 00:07:00 Lesson 9 - How to make money from customer service jobs from home 00:06:00 Lesson 10 - How to be a Virtual Assistant and start making income 00:07:00 Lesson 11 - How to make money with a podcast 00:05:00 Lesson 12 - How to make money on Amazon 00:09:00 Lesson 13 - How to make money with transcription jobs 00:05:00 Lesson 14 - How to make money as an online proofreader 00:06:00 Lesson 15 - Making money with membership sites 00:07:00

Description Here at iStudy, we put our heart and soul into every single course we design. We make sure that all our courses are designed and developed by industry experts. Our aim is to always provide value to our learners with quality courses. Our learners are our top priority, and you as a learner will gain tremendous knowledge and skill on this topic from this Email List Building Formula. The certification that you will receive upon completing this Email List Building Formula will help to boost your resume and will help you stand out among your peers in the competitive job market. Our course will help you get employed in the relevant field and advance your career. Enjoy this expertly made course from iStudy. Enrol now!   Why You Should Choose Email List Building Formula Lifetime access to the course No hidden fees or exam charges Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Email List Building Formula is CPD Qualification Standards and CiQ accredited, and IAO accredited. 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 backgrounds.   Requirements Our Email List Building Formula 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. Email List Building Formula Lesson 1 - Intro To The List building Formula Video Training 00:03:00 Lesson 2 - List building an overview 00:03:00 Lesson 3 - Lead magnet marketing - popular lead magnets 00:05:00 Lesson 4 - Selecting the right email service provider 00:04:00 Lesson 5 - Creating premium content upgrade for list building 00:06:00 Lesson 6 - Amazing Squeeze page secret to capturing email leads 00:05:00 Lesson 7 - How pop-ups can help you build a responsive list 00:05:00 Lesson 8 - Top 10 ways to capture email leads 00:04:00 Lesson 9 - Actionable list building strategies 00:03:00 Lesson 10 - Using giveaways to build an email list 00:06:00 Lesson 11 - Building an email list with webinars 00:05:00 Lesson 12 - How to build an email list with free online courses 00:04:00 Lesson 13 How to build an email list with social media 00:04:00 Lesson 14 - Building an email list using Facebook lead ads 00:04:00 Lesson 15 - What to do after you capture an email? 00:06:00

Learning Objectives Introduction , Advanced Document Tools , Adding Rich Media , Using the Measurement Tools , Creating Forms , Understanding Accessibility , Creating Signatures and Certificates , Conclusion   Pre-Requisites Adobe Acrobat Pro DC Beginner or equivalent knowledge and skills.   Description Workplace demand for digital media skills including creating, managing, and integrating PDF documents is on the rise. Adobe Acrobat training is an excellent way to learn and validate your digital communication skills. This brings value to prospective clients and employers.  Adobe Acrobat is a family of computer programs developed by Adobe Systems, designed to view, create, manipulate and manage files in Adobe's Portable Document Format (PDF). Some software in the family is commercial, and some is freeware. In this course, students will learn to use advanced document tools and modify document properties, compare documents, enhance scans, as well as enhance documents by adding rich media such as sound, video, and interactive buttons. Students will learn to use the measurement tool, the distance tool, the perimeter tool and the area tool. Students will create interactive forms from a Word document or InDesign document, add form elements, add checkboxes and radio buttons, and distribute forms for feedback. Students will understand the importance of accessibility and test for accessibility. Finally, students will understand signatures, create signatures, and add signatures to a document. Adobe Acrobat Pro DC puts the power of the Portable Document Format, literally, at your fingertips. By taking advantage of the functionality & features available in Acrobat, you will ensure the integrity of your documents in regards to who views them. Introduction to the Course Introduction 00:02:00 Module 1: Advanced Document Tools Using Document Properties 00:04:00 Comparing Documents 00:07:00 Using Scan and OCR 00:06:00 Module 2: Adding Rich Media Adding Sound 00:06:00 Adding Video 00:05:00 Adding Buttons 00:10:00 Module 3: Using the Measurement Tools Understanding the Measurement Tool 00:03:00 Using the Distance Tools 00:04:00 Using the Perimeter Tool 00:02:00 Using the Area Tool 00:03:00 Module 4: Creating Forms Creating a Form from a Word Document 00:06:00 Creating a Form from InDesign 00:03:00 Adding Form Elements 00:09:00 Adding Checkboxes and Radio Buttons 00:08:00 Distributing Forms 00:05:00 Tracking Forms 00:03:00 Module 5: Understanding Accessibility What is Accessibility 00:02:00 Running Accessibility Checker 00:08:00 What is a Digital Signature 00:03:00 Module 6: Creating Signatures and Certificates Creating a Digital Signature 00:08:00 Using Adobe Sign and Fill 00:03:00 Recap to the Course Recap SWR 00:01:00 Final Exam Final Exam - Adobe Acrobat Pro DC Advanced 00:20:00

Learning Objectives Introduction , Getting Started with OneNote , Managing Notebooks , Working with Containers , Working with Text Containers , Adding Advanced Content , Working with Drawing Tools , Organizing Notebooks , Using Advanced OneNote Features , Conclusion   Pre-Requisites Basic Computer Skills. Understanding Microsoft Office is helpful but not mandatory.   Description This course is an introduction to, and in-depth look at OneNote for Windows. During the course, students will learn how OneNote can help them to organize their notes more efficiently, and allow them to access their content from anywhere. Students will also learn how to share the contents of their OneNote notebooks with others, and collaborate. Unit One: Basic Navigations in OneNote What is OneNote for Windows 00:02:00 Understanding the OneNote Environment 00:04:00 Navigating in OneNote 00:03:00 Changing Views in OneNote 00:04:00 Using Touch Gestures 00:01:00 Getting Help 00:03:00 Unit Two: Notebook Features Creating a Notebook 00:02:00 Creating Sections 00:04:00 Creating Pages 00:05:00 Opening an Existing Notebook 00:02:00 Unit Three: Containers and Images Adding a Text Container 00:03:00 Inserting an Image 00:06:00 Inserting Files 00:05:00 Working with Containers 00:03:00 Unit Four: Text Features Advanced Text Techniques 00:03:00 Formatting Text 00:07:00 Using the Built-In Styles 00:04:00 Working with Automatic Spell Check 00:04:00 Adding Date and Time 00:02:00 Inserting Tables 00:09:00 Unit Five: Clipping, Recording and Translating Adding a Screen Clipping 00:02:00 Adding Web Content 00:03:00 Working with Cut, Copy and Paste 00:04:00 Recording Audio 00:02:00 Using Voice to Text Dictation 00:02:00 Translating Notes 00:02:00 Inserting an Online Video 00:02:00 Unit Six: Drawing Features Using the Drawing Tools. 00:03:00 Creating a New Pen 00:04:00 Selecting Objects 00:02:00 Converting Ink to Type 00:01:00 Adding and Modifying Shapes 00:04:00 Converting Drawings to Shapes 00:02:00 Converting Ink or Text to Math 00:03:00 Graphing in OneNote 00:02:00 Working with the Ruler 00:02:00 Unit Seven: Advanced Features Using Tags 00:04:00 Creating Custom Tabs 00:04:00 Sending to OneNote from Outlook 00:04:00 Searching Content 00:04:00 Advanced Page Management 00:08:00 Advanced Section Management 00:06:00 Advanced Notebook Management 00:05:00 Unit Eight: Sharing and Printing Using Immersive Reader 00:01:00 Sharing a Notebook 00:03:00 Syncing Notebooks 00:04:00 Exploring Printing Options 00:03:00 Using Print to OneNote 00:02:00 Resource Resource - OneNote for Windows 10 - A Complete Guide Beginner 00:00:00 Final Exam Final Exam - OneNote for Windows 10 - A Complete Guide Beginner 00:20:00

Description Here at iStudy, we put our heart and soul into every single course we design. We make sure that all our courses are designed and developed by industry experts. Our aim is to always provide value to our learners with quality courses. Our learners are our top priority, and you as a learner will gain tremendous knowledge and skill on this topic from this Superior Brain Health. The certification that you will receive upon completing this Superior Brain Health will help to boost your resume and will help you stand out among your peers in the competitive job market. Our course will help you get employed in the relevant field and advance your career. Enjoy this expertly made course from iStudy. Enrol now! Why You Should Choose Superior Brain Health Lifetime access to the course No hidden fees or exam charges Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Superior Brain Health is CPD Qualification Standards and CiQ accredited, and IAO accredited. 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 backgrounds. Requirements Our Superior Brain Health 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. Boost Your Brain Power & Mental Wellness Course Promo 00:03:00 Lesson 01: Introduction 00:02:00 Lesson 02: Brain Power and Brain Health 101 00:09:00 Lesson 03: The Science Behind Brain Function Improvement 00:08:00 Lesson 04: How to Train Your Brain 00:08:00 Lesson 05: Perks of Improved Brain Health 00:07:00 Lesson 06: Habits That Support Brain Health 00:08:00 Lesson 07: Best Foods That Boost Brain Health 00:09:00 Lesson 08: Top Brain Health Supplements 00:07:00 Lesson 09: How Seniors Can Preserve Brain Health 00:08:00 Lesson 10: Conclusion - Final Thoughts & Ideas 00:02:00

Learning Objectives Introduction , Getting Started with Excel , Creating Workbooks and Using Templates , Entering Data , Excel Formula Basics , Adjusting a Worksheet , Formatting and Aligning Data , Using Cell Styles and Themes , Inserting Objects and Graphics , Proofing a Workbook , Printing an Excel File , Managing Worksheets , Navigating and Viewing Excel Files , Conclusion   Pre-Requisites Basic Computer Skills   Description Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks. Section 01 Lesson 01: What is Excel 00:03:00 Lesson 02: Opening Excel 00:04:00 Lesson 03: Navigating the Excel User Interface-v2 00:06:00 Lesson 04: Navigating the Excel User Interface 00:04:00 Lesson 05: Using the Excel Ribbon 00:07:00 Lesson 06: Understanding Excel Worksheet Components 00:07:00 Lesson 07: Using the Backstage View 00:06:00 Section 02 Lesson 01: Creating a New Workbook 00:06:00 Lesson 02: Saving an Excel Workbook 00:05:00 Lesson 03: Using the Accessibility Checker 00:04:00 Lesson 04: Using the Accessibility Checker-v3 00:04:00 Section 03 Lesson 01: Navigating a Worksheet by Mouse or Keyboard 00:05:00 Lesson 02: Understanding Excel Data Types 00:04:00 Lesson 03: Using the Inking Tools 00:05:00 Lesson 04: Using the Inking Tools-v3 00:03:00 Lesson 05: Working with Cell and Range Addressing 00:05:00 Lesson 06: Using Various Data Selection Techniques 00:05:00 Lesson 07: Working with Common Excel Commands 00:06:00 Lesson 08: Using Flash Fill and Autofill 00:06:00 Section 04 Lesson 01: What are Formulas and Functions 00:05:00 Lesson 02: Understanding the Components of a Formula 00:05:00 Lesson 03: Understanding Calculation Hierarchy and the Order of Operations 00:03:00 Lesson 04: Creating Basic Formulas 00:05:00 Lesson 05: Working with Basic Functions and AutoSum 00:06:00 Lesson 06: Using Cell References 00:05:00 Lesson 07: Using the Quick Analysis Tool 00:03:00 Section 05 Lesson 01: Modifying Columns and Rows 00:06:00 Lesson 02: Hiding and Unhiding Columns and Rows 00:06:00 Section 06 Lesson 01: Formatting and Aligning Data 00:07:00 Lesson 02: Merging Data 00:07:00 Lesson 03: Wrapping Text and Adjusting Orientation 00:06:00 Lesson 04: Formatting Numbers 00:05:00 Lesson 05: Using the Format Painter 00:04:00 Section 07 Lesson 01: Using Cell Styles 00:06:00 Lesson 02: Applying Themes 00:05:00 Section 08 Lesson 01: Inserting and Formatting Images and Shapes 00:08:00 Lesson 02: Inserting and Formatting SmartArt 00:05:00 Lesson 03: Working with Icons 00:04:00 Lesson 04: Inserting Hyperlinks 00:06:00 Lesson 05: Inserting Symbols and Equations 00:05:00 Lesson 06: Inserting WordArt and Text Boxes 00:05:00 Lesson 07: Inserting 3-D Models 00:04:00 Lesson 08: Arranging Objects 00:06:00 Section 09 Lesson 01: Using Find and Replace 00:05:00 Lesson 02: Using Go To and Go To Special 00:03:00 Lesson 03: Using the Spell Checker 00:05:00 Lesson 04: Using the Thesaurus and Translation Features 00:05:00 Lesson 05: Using the resolve Feature-v3 00:02:00 Section 10 Lesson 01: Printing and Previewing Excel Files 00:06:00 Lesson 02: Creating Custom Margins and Scaling 00:05:00 Lesson 03: Adding Headers and Footers 00:04:00 Lesson 04: Formatting a Page with the Page Layout Tab 00:06:00 Lesson 05: Printing Titles and Specific Worksheet Areas 00:03:00 Lesson 06: Exporting to PDF-v3 00:02:00 Lesson 07: Exporting to PDF and XPS 00:04:00 Section 11 Lesson 01: Renaming and Coloring Worksheet Tabs 00:03:00 Lesson 02: Adding, Deleting and Navigating Worksheets 00:03:00 Lesson 03: Hiding and Unhiding Worksheets 00:03:00 Section 12 Lesson 01: Viewing Workbooks 00:03:00 Lesson 02: Using Zoom Tools 00:03:00 Lesson 03: Configuring Sheet Options 00:05:00 Lesson 04: Using the Freeze Panes and Split Commands 00:04:00 Lesson 05: Adjusting Worksheet Properties 00:04:00 Lesson 06: Viewing Workbook Statistics-v3 00:02:00 Course Recap Recap 00:02:00 Final Exam Final Exam - Excel 365 Beginner 00:20:00

Learning Objectives Introduction , Linking Workbooks and Worksheets , Working with Range Names , Sorting, Filtering, and Subtotaling , Analyzing and Organizing with Tables , Using Conditional Formatting , Displaying Data Graphically , Understanding PivotTables, PivotCharts, and Slicers , Working with Advanced PivotTables and PowerPivot Features , Conclusion   Pre-Requisites Excel 365 Introduction course or equivalent knowledge or experience.   Description In this course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. Students will also apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines. Additionally, students will also understand PivotTables, PivotCharts, and slicers and work with advanced PivotTables and PowerPivot features. Section 01 Lesson 01: Linking Workbooks and Worksheets 00:06:00 Lesson 02: Linking Workbooks with 3D References 00:05:00 Lesson 03: Understanding the Consolidate Feature 00:06:00 Section 02 Lesson 01: What are Range Names 00:04:00 Lesson 02: Creating Range Names Using the Name Box and Define Name 00:06:00 Lesson 03: Creating Range Names Using Create from Selection 00:03:00 Section 03 Lesson 01: Understanding the Differences Between Sorting and Filtering 00:03:00 Lesson 02: Sorting Lists 00:06:00 Lesson 03: Filtering Lists 00:08:00 Lesson 04: Creating Subtotals 00:06:00 Section 04 Lesson 01: Creating Tables and Understanding the Benefits 00:07:00 Lesson 02: Understanding the Elements of a Table 00:06:00 Lesson 03: Formatting a Table 00:08:00 Lesson 04: Sorting and Filtering Tables 00:03:00 Lesson 05: Filtering with Slicers 00:04:00 Lesson 06: Calculating with Tables 00:04:00 Lesson 07: Removing Erroneous Table Data 00:03:00 Lesson 08: Exporting, Refreshing, and Converting Tables 00:05:00 Section 05 Lesson 01: What is Conditional Formatting 00:04:00 Lesson 02: Conditional Formatting Highlight Cells and Top Bottom Rules 00:07:00 Lesson 03: Conditional Formatting Data Bars, Icon Sets, and Color Scales 00:06:00 Lesson 04: Using Custom Fonts and Colors 00:04:00 Lesson 05: Using Custom Conditional Formatting 00:06:00 Lesson 06: Modifying or Removing Conditional Formatting 00:05:00 Section 06 Lesson 01: What are Charts 00:05:00 Lesson 02: Creating Charts 00:06:00 Lesson 03: Understanding Chart Elements 00:05:00 Lesson 04: Modifying Chart Elements 00:09:00 Lesson 05: Changing and Moving Charts 00:04:00 Lesson 06: Filtering a Chart 00:04:00 Lesson 07: Formatting Charts 00:07:00 Lesson 08: Adjusting Numbering 00:06:00 Lesson 09: Creating Dual Axis Charts 00:05:00 Lesson 10: Forecasting with Trendlines 00:05:00 Lesson 11: Creating a Chart Template 00:04:00 Lesson 12: Displaying Trends with Sparklines 00:07:00 Section 07 Lesson 01: What is a PivotTable 00:06:00 Lesson 02: Creating a PivotTable 00:07:00 Lesson 03: Working with the PivotTable Fields Pane 00:09:00 Lesson 04: Basic Data Organization and Analysis with PivotTables 00:06:00 Lesson 05: Formatting PivotTables 00:06:00 Lesson 06: Creating a PivotChart 00:04:00 Lesson 07: Modifying and Formatting a PivotChart 00:04:00 Lesson 08: Adding Slicers and Timeline Slicers 00:03:00 Lesson 09: Formatting Slicers 00:04:00 Lesson 10: Using the Ideas Feature 00:03:00 Section 08 Lesson 01: Using the PivotTable and PivotChart Wizard 00:02:00 Lesson 02: Adding a Calculated Field 00:05:00 Lesson 03: Adding a Calculated Item 00:04:00 Lesson 04: Applying Conditional Formatting to a PivotTable 00:02:00 Lesson 05: Creating Filter Pages for a PivotTable_1 00:03:00 Lesson 06: Enabling the PowerPivot Add: In 00:06:00 Final Exam Final Exam - Excel 365 Intermediate 00:20:00