402 Spreadsheet courses

Overview The Advanced Diploma in Microsoft Excel is the best way for you to gain deep insight and knowledge of this topic. You will learn from industry experts and obtain certificates after completing the course. Enrol now for a limited-time discounted price. Like all the courses of The Teachers Training, this Advanced Diploma in Microsoft Excel is designed with the utmost attention and thorough research. All the topics are broken down into easy to understand bite-sized modules that help our learners to understand each lesson very easily. We don't just provide courses at The Teachers Training; we provide a rich learning experience. After purchasing a course from The Teachers Training, you get complete lifetime access with tutor support.  Our expert instructors are always available to answer all your questions and make your learning experience exquisite. After completing the Advanced Diploma in Microsoft Excel, you will instantly get an e-certificate that will help you get jobs in the relevant field and will enrich your CV. What You Will Learn Get to know about relevant job opportunities. Format data labels, create excel values and build basic formulas in excel. Learn all the functions like SUM(), MIN(), MAX() etc Be able to insert images and shapes and customise icons Change layout views, convert spreadsheets into PDFs and print specific ranges of cells Learn how to group and filter pivot table data Skills You Will Gain Keyboard shortcuts Conditional formatting Flash Fill Filters/ AutoFilter Fast Track your Excel skills Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Assessment To successfully complete the course you must have to attend the MCQ assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Certification CPD Certification from The Teachers Training: Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.

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

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want Excel is an essential tool for data management and analysis and in this course, you will master everything from the fundamentals to advanced functionalities. You will learn to navigate the interface, create and format spreadsheets and perform calculations with ease and you will unlock the true potential of Excel for business and personal use. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Understand the basics of Excel Know how to use Excel at an intermediate level Be aware of sum and numerical functions Understand how to manipulate text Know about logical functions Create effective spreadsheets Be confident with lookup functionality and date and time functions Easily use financial functions and sort and filter Progress to using Microsoft Excel at an advanced level Know how to create accurate and clear visual presentations Consolidate and validate data Use pivot table and what-if analysis Understand automation and macros Why Microsoft Excel Training Course right for you? Develop advanced skills in Microsoft Excel training course basic to advanced course, with this course. Learn from scratch or build on prior knowledge, to gain a good understanding of Excel functions. You will learn to accelerate your tasks efficiently using Excel techniques and formulae. The course covers how to create professional reports in no time, with Excel tools for data analysis and creating charts. This course will demystify the functions and tools in easy steps. It will teach you to work smart and save time. It is an excellent addition to your CV and is a valued skill in all businesses. Microsoft Excel Training Course Details Accredited by 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.   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. Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the Interface 0102 Enter Data & Saving Workbook 0103 Applying Formulas 0104 Changing a Worksheet's Structure 0105 Find, Replace & Spell Check 0106 Applying Fonts, Background Colors, and Borders 0107 Formatting Numbers and Dates 0108 Making the Fieces fit 0109 Inserting Headers & Footers and Repeating Rows 0110 Managing Large Workbooks Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) Ex 0201 Formula Writing (Don't Miss this) Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs Ex 0301 SumIf & SumIfs 0302 Count Functions Ex 0302 Count Functions 0303 AverageIf & AverageIfs Ex 0303 AverageIf & AverageIfs Text Functions - Manipulating Text 0401 Change Case (Upper, Lower,Proper) Ex 0401 Change Case (Upper, Lower, Proper) 0402 Separating Text on Symmetrical Data Ex 0402 Separating Text on Symmetrical Data 0403 Separating Text on Non-Symmetrical Data Ex 0403 Separating Text on Non-Symmetrical Data Logical Functions - Working With Conditions 0501 If Functionality Ex 0501 IF Functionality 0502 If with AND Ex 0502 If with AND 0503 If with OR Ex 0503 If with OR 0504 If with 'AND' & 'OR' / IF with Countif Ex 0504 If with 'AND' & 'OR' / IF with Countif 0505 Nested IF (A Genie with 3 wishes) Ex 0505 Nested IF (A Genie with 3 wishes) Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 Ex 0601 Vlookup (Exact Match) # 1 0602 Type of References (Use of $ sign) 0603 Vlookup (Exact Match) # 2 Ex 0603 Vlookup (Exact Match) # 2 0604 Double Vlookup Ex 0604 Double Vlookup 0605 Vlookup on Duplicate Values Ex 0605 Vlookup on Duplicate Values 0606 Vlookup (Approximate Match) Ex 0606 Vlookup (Approximate Match) 0607 Vlookup with If (Conditional Vlookup) Ex 0607 Vlookup with If (Conditional Vlookup) 0608 Hlookup (Exact Match) Ex 0608 Hlookup (Exact Match) 0609 Hlookup (Approximate Match) Ex 0609 Hlookup (Approximate Match) 0610 Lookup (Don't use this !) Ex 0610 Lookup (Don't use this !) 0611 Vlookup with Match (Create Magical Vlookup) Ex 0611 Vlookup with Match (Create Magical Vlookup) 0612 Match (Gives us Column/Row Index #) Ex 0612 Match (Gives us Column/Row Index #) 0613 Index & Match (Made for Each Other) Ex 0613 (1) Index & Match (Made for Each Other) Ex 0613 (2) Index & Match (Made for Each Other) Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 0702 Now, Today & Autofill 0703 DateValue & TimeValue 0704 Calculate WorkingDays 0705 DatedIf Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 0802 Creating a Loan Table Ex 0802 Creating a Loan Table 0803 Calculate Depriciation Ex 0803 Calculate Depriciation Sort & Filter 0901 Basic Sorting & Shortcut keys Ex 0901 Basic Sorting & Shortcut keys 0902 Sorting Using Custom List Ex 0902 Sorting Using Custom List 0903 Horizontal Sorting Ex 0903 Horizontal Sorting 0904 Basic Filter & Shortcut Keys Ex 0904 Basic Filter & Shortcut Keys 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 0906 Filter Problem # 2 (Pasting Values on Filtered Data) Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 0908 Advanced Filter (Applying Complex Criteria's) Ex 0908 Advanced Filter (Applying Complex Criteria's) Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 1002 Format Axis 1003 Plot Values on Secondary Axis 1004 Life of Pie (Charts) 1005 How to Show Axis Title 1006 How to Show Data Label 1007 Show data with chart in Data Table 1008 Column Chart 1009 Bar Chart 1010 Line Chart 1 1011 Line Chart 2 1012 Area Chart 1013 Pie Chart 1014 Pie of Pie or Bar of Pie 1015 Line Chart with Log Scale 1016 Bubble Chart 1017 Selecting Chart Elements 1018 Use of Format Dialog box 1019 Modifying Chart & Plot Area 1020 Modifying Data Series 1021 How to handle Missing Data 1022 Modifying 3-D Charts 1023 Creating Combination of upto 5 Different Charts 1025 Creating Picture Charts Data Consolidation - Multiple WorkBooks WorkSheets Consolidate Data using Excel Inbuilt Function Ex Consolidate Data using Excel Inbuilt Function Data Validation 1201 Applying Data Validation Ex 1201 Applying Data Validation 1202 Dependent Dropdown List Ex1202 Dependent Dropdown List Using Data Validation with Vlookup & Match Other Data Validation Examples Protection of Worksheet Workbook 1301 Worksheet Level Protection Ex 1301 Worksheet Level Protection 1302 Cell Level Protection Ex 1302 Cell Level Protection 1303 Hiding Formulas from Formula Bar Ex 1303 Hiding Formulas from Formula Bar 1304 Protecting Workbook Structure Ex 1304 Protecting Workbook Structure 1305 Workbook Level Protection Ex 1305 Workbook Level Protection Pivot Table & Techniques 1401 Understanding pivot Table 1402 Using Pivot Table in Real Scenario Ex 1402 Using Pivot Table in Real Scenario 1403 Grouping in Pivot Table Ex 1403 Grouping in Pivot Table 1404 Using Slicers (A Visually attractive Filter) Ex 1404 Using Slicers (A Visually attractive Filter) What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) Ex 1501 Goal Seek (A Reverse Approach) 1502 One Way Data Table 1503 Two Way Data Table 1504 Scenario Manager 1505 Solver Add-In Automation in Excel - Macros 1601 Record your first Macro 1602 Record Another Macro 1603 Assigning macro to a Shape, Button, Picture etc 1604 Editing or Deleting a Macro 1605 Security Settings of a Macro Who should take this course? Absolute beginners to Microsoft Excel People who wish to use Microsoft Excel more confidently People who wish to refresh their existing skills in Microsoft Excel Entry Requirements There are no academic entry requirements for this Microsoft Excel training course basic to advanced course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This Microsoft Excel training course basic to advanced course 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%. Certification 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

Learn new skills and develop your professional knowledge with our Advanced Diploma in Microsoft Office and learn from home at a pace that suits you. The Microsoft Office 2019 course has been expertly designed for you to complete through distance e-learning and achieve a professional qualification without leaving your own home! Learn and Explore the New Features of Microsoft Office 2019 in this course. From creating documents and spreadsheets, to presenting information in a slide show and managing projects, this Microsoft Office 2019 course is your step-by-step guide to getting it all done. Get started now, and be on your way to mastering Word, PowerPoint, Excel, and more. Learn the skills you'll need to improve your CV and land the job of your dreams. Complete the Advanced Diploma in Microsoft Office to earn an industry-recognized credential that will help you excel in the workplace. Become confident of your abilities and use them to develop your profile online and in the marketplace.

Learn new skills and develop your professional knowledge with our Advanced Diploma in Microsoft Office and learn from home at a pace that suits you. The Microsoft Office 2019 (Updated and New Features 2022) course has been expertly designed for you to complete through distance e-learning and achieve a professional qualification without leaving your own home! Learn and Explore the New Features of Microsoft Office 2019 (Updated and New Features 2022) in this course. From creating documents and spreadsheets, to presenting information in a slide show and managing projects, this Microsoft Office 2019 (Updated and New Features 2022) course is your step-by-step guide to getting it all done. Get started now, and be on your way to mastering Word, PowerPoint, Excel, and more. Learn the skills you'll need to improve your CV and land the job of your dreams. Complete the Advanced Diploma in Microsoft Office to earn an industry-recognized credential that will help you excel in the workplace. Become confident of your abilities and use them to develop your profile online and in the marketplace.

Master 75+ Excel tips and techniques and become a certified POWER USER, with unique hands-on demos and real-world projects to help you wrangle, analyze, and visualize your data in Excel.

Embark on a journey of discovery and mastery with our Adventures in Excel Course. Explore the endless possibilities of Microsoft Excel as you learn essential tips, tricks, and techniques for spreadsheet management, data analysis, and visualization. Whether you're a beginner or seasoned user, this course offers exciting adventures to enhance your Excel skills and unlock new capabilities for productivity and efficiency in both personal and professional settings.

🌟 Unlock the Power of Excel 2019! 🌟 Are you ready to master Microsoft Excel 2019 and elevate your skills to new heights? Introducing our comprehensive online course: 'Microsoft Excel 2019 - Beginner Level Training.' 🚀 Dive into Excel's World-Class Features 🚀 📚 Section 1 - Excel Beginner Get started with a solid foundation. Learn the interface, navigation, and essential tools to kickstart your Excel journey. 📊 Section 2 - Excel Fundamentals Discover the core functionalities of Excel 2019, from cells and formulas to tables and more. Lay the groundwork for proficient data manipulation. ️ Section 3 - Entering and Editing Text Master the art of inputting and refining text within Excel. Gain efficiency and accuracy in handling textual data. Section 4 - Basic Excel Functions Explore the fundamental functions that make Excel a powerhouse. From basic calculations to data analysis, unlock Excel's potential. 🔄 Section 5 - Modifying an Excel Worksheet Learn techniques to manage, organize, and customize worksheets effectively. Boost productivity and streamline your workflow. 🎨 Section 6 - Formatting Data Transform raw data into visually appealing, easy-to-read formats. Elevate your reports and presentations with polished data formatting skills. 🖼️ Section 7 - Images, Shapes, and Smart Art Enhance your spreadsheets with visuals! Master the incorporation of images, shapes, and smart art for impactful data representation. 🖨️ Section 8 - Printing in Excel Navigate the intricacies of printing in Excel. Optimize layouts and settings to produce professional-looking documents. 📑 Section 9 - Templates Harness the power of pre-designed templates. Learn how to utilize and customize templates for various Excel projects efficiently. 🎓 Section 10 - Excel Beginner - Conclusion Wrap up your journey with a comprehensive understanding of Excel's beginner level. Recap key takeaways and prepare to advance your skills further. 🔥 Join Now and Excel in Excel 2019! 🔥 👩‍💻 Whether you're a student, professional, or an Excel enthusiast, this course is your gateway to proficiency in Microsoft Excel 2019. Enroll today and unlock a world of possibilities with data manipulation, analysis, and presentation! 🌟 Don't miss this opportunity! Enroll now and empower yourself with Excel mastery! 🌟 Course Curriculum Section 1 - Excel Beginner Introduction 01:02 Section 2 - Excel Fundamentals Launching Excel 01:59 Start Up Screen 02:54 The Excel Interface 06:46 The Quick Access Toolbar 02:13 The Ribbon 04:43 Creating New Excel Workbooks 01:27 Saving Excel Files 02:22 Opening Excel Files 01:38 Beginner Shortcut Keys 01:37 Section 3 - Entering and Editing Text Entering Text 06:41 Working with Numbers 06:55 An Introduction to Dates 01:15 Find and Replace 04:10 Sorting Data 04:13 Working with Cell References 06:05 Relative Versus Absolute Cell Reference in Formulas 06:24 Understanding the Order of Operation 02:41 Section 4 - Basic Excel Functions The structure of an Excel Function 00:00 Working with the Sum Function 00:00 Working with Min and Max 00:00 Working with Averages 00:00 Working with Count and CountA 00:00 Section 5 - Modifying an Excel Worksheet Moving and Copying Data 00:00 Inserting and Deleting Rows and Columns 00:00 Changing the Width and Height of Cells 00:00 Hiding and Unhiding Rows, Columns and Sheets 00:00 Renaming Worksheets 00:00 Deleting Worksheets 00:00 Moving and Copying Worksheets 00:00 Section 6 - Formatting Data Adding Borders to Cells 00:00 Formatting Percentages 00:00 Merging and Centering Cells 00:00 A Quick look at Styles 00:00 Basic Conditional Formatting 00:00 Section 7 - Images, Shapes and Smart Art Inserting Images and Shapes 00:00 Working with SmartArt 00:00 Section 8 - Printing in Excel Print Preview 00:00 Margins, Scaling and Orientation 00:00 Printing 00:00 Section 9 - Templates Intro to Excel Templates 00:00 Opening an Existing Template 00:00 Creating a Custom Template 00:00 Section 10 - Excel Beginner - Conclusion Conclusion 00:00

Description: Explore all that you need at an advanced level to become a proficient Microsoft OneNote 2013 user. This course will help you learn more advanced skills for working with your Notebooks. It demonstrates the new and enhanced features in Microsoft one note 2013 for gathering and sharing information. Students will explore OneNote 2013 interface features, including the Ribbon and Backstage View, and workflow enhancements such as quick filing, linked notes, and Word styles. They will also be introduced to the new and improved ways to collaborate on notebooks with others. Who is this course for? This course would be ideal for Microsoft Office users, students and office workers. This course is designed for anyone who wants to learn Microsoft OneNote 2013 at an advanced level. 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 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 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: The Microsoft One Note Advanced Level will be very beneficial and helpful, especially to the following professionals: Event planner Project manager Real estate agent Travel agent Teacher Lawyer Microsoft One Note Advanced Level Module One - Getting Started 01:00:00 Module Two - Working with Notebooks 01:00:00 Module Three - Using Additional Notebooks 01:00:00 Module Four - Formatting and Editing Your Notes 01:00:00 Module Five - Working with Audio and Video 01:00:00 Module Six - Working with Tables 01:00:00 Module Seven - Working with Equations and Excel Spreadsheets 01:00:00 Module Eight - Researching a Topic 01:00:00 Module Nine - Advanced Review Tasks 00:30:00 Module Ten - Collaborating 01:00:00 Module Eleven - Advanced Sharing Options 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft One Note Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft One Note Advanced Level 00:20:00 Final Exam Final Exam- Microsoft One Note Advanced Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2013 Word Intermediate - Complete Video Course series covers the intermediate functions and features of Word 2013. It will provide you with sufficient 2013 Word Intermediate skills to create sophisticated analytical spreadsheets and master advanced formulae. By this course you will learn about working with tables and charts, customizing formats, using images and creating graphics. You will also learn how to use Quick Parts, controlling text flow, and using templates, mail merge and macros. Learn to use Word 2013's advanced editing tools, work with images, including placing and sizing images, wrapping text around images, and using borders and effects, adjust page orientation and layout, work with columns, work with page and section breaks, document views, using the navigation pane, and viewing multiple windows. If you want to take your Microsoft Word 2013 skills to the next level, 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 2013 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 2013 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. Working with Tables and Charts Sort Table Data FREE 00:05:00 Control Cell Layout 00:09:00 Perform Calculations in a Table 00:09:00 Create a Chart 00:08:00 Customizing Formats Using Styles and Themes Create and Modify Text Styles 00:17:00 Create Custom List or Table Styles 00:09:00 Apply Document Themes 00:06:00 Using Images in a Document Resize an Image 00:08:00 Adjust Image Appearance 00:17:00 Integrate Pictures and Text 00:15:00 Insert and Format Screenshots 00:05:00 Insert Video 00:05:00 Creating Custom Graphic Elements Create Text Boxes and Pull Quotes 00:10:00 Draw Shapes 00:05:00 Add WordArt and Other Text Effects 00:05:00 Create Complex Illustrations with SmartArt 00:06:00 Inserting Content Using Quick Parts Insert Building Blocks 00:09:00 Create and Modify Building Blocks 00:06:00 Insert Fields Using Quick Parts 00:11:00 Controlling Text Flow Control Paragraph Flow 00:07:00 Insert Section Breaks 00:10:00 Insert Columns 00:07:00 Link Text Boxes to Control Text Flow 00:06:00 Using Templates Create a Document Using a Template 00:08:00 Create a Template 00:08:00 Using Mail Merge The Mail Merge Features 00:22:00 Merge Envelopes and Labels 00:06:00 Create a Data Source Using Word 00:05:00 Using Macros Automate Tasks Using Macros 00:08:00 Create a Macro 00:09:00 Mock Exam Mock Exam- Microsoft Office 2013 Word Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Word Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00