Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - LIBM - PowerPoint PPT Presentation

libm
9 20 2018 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - LIBM PowerPoint Presentation
Download Presentation
Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - LIBM

play fullscreen
1 / 15
Download Presentation
Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - LIBM
1 Views
Download Presentation

Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - LIBM

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. 9/20/2018 Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management HOME / COURSE / MICROSOFT OFFICE / EXCEL / VIDEO COURSE / MICROSOFT EXCEL COMPLETE COURSE (BEGINNER, INTERMEDIATE, ADVANCED) MICROSOFT EXCEL COMPLETE COURSE (BEGINNER, INTERMEDIATE, ADVANCED) Microsoft Excel Complete Course Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) (Beginner, Intermediate, Advanced)   ( 8 REVIEWS ) ( 8 REVIEWS ) 505 STUDENTS This is best a combination of Microsoft Excel Beginners , Intermediate and Advanced which is designed to make the most … TAKE THIS COURSE TAKE THIS COURSE https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/ 1/15

  2. 9/20/2018 Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management £ £603.00 603.00 £ £23.00 23.00  1 YEAR  ADVANCED ADVANCED, , BEGINNER BEGINNER, , INTERMEDIATE INTERMEDIATE  COURSE BADGE COURSE BADGE  COURSE CERTIFICATE COURSE CERTIFICATE 59 59 NUMBER OF UNITS NUMBER OF UNITS 0 0 NUMBER OF QUIZZES NUMBER OF QUIZZES  10 HOURS, 25 MINUTES 10 HOURS, 25 MINUTES     HOME HOME CURRICULUM CURRICULUM REVIEWS REVIEWS This Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) is best a combination of Microsoft Excel Beginners , Intermediate and Advanced which is designed to make the most in-depth, bestselling value for money Complete Excel Course on the market and you are getting this best selling course on only £23 £23! Microsoft Excel is one of the most widely used programmes in the world for visualising and analysing. This software is used in almost every industry, not to mention for personal use in households around the world. Small business owners rely on Excel to track hours, ?nances, and invoices, and large corporations rely on Excel for data analysis, to visualise data, and innumerable other tasks. As you participate in each of the 3 courses you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics. You can learn at your own pace, as there is no time limit, nor deadline to complete the courses. You can access the course material with any device that allows you to access the internet, and you will receive online support while you train, which means it is available whenever and wherever you require it. https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/ 2/15

  3. 9/20/2018 At completion of this course you will have mastered the most popular Excel tools and come out with con?dence to complete any Excel tasks with e?ciency and grace. Key features of the course Key features of the course: Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management Lifetime access to the course No hidden fees, only pay the price of the course which includes exam fees. Recognised quali?cation upon successful completion of the course Study from anywhere, anytime, whenever it is convenient for you. A?ordable and engaging e-learning study materials Study at your own pace from tablet, PC or smartphone Online tutor support when you are in need. Who is this course for? Who is this course for? There is no experience or previous quali?cations required for enrolment on this course. It is available to all students, of all academic backgrounds. Assessment and Certi?cation Assessment and Certi?cation The course is assessed online with a multiple-choice test, which is marked automatically. You will know instantly whether you have passed or not. Those who pass this test will have the quali?cation of Microsoft Excel Complete Course (Beginner, Intermediate, Advanced). Certi?cate will be produced in PDF format at an additional cost of £14.99 and Printed Hardcopy at £21. COURSE CURRICULUM COURSE CURRICULUM Getting Started with Microsoft O?ce Excel 2016 Getting Started with Microsoft O?ce Excel 2016  Navigate the Excel User Interface  00:28:00 00:28:00 FREE FREE  Use Excel Commands  00:10:00 00:10:00  Create and Save a Basic Workbook  00:19:00 00:19:00  Enter Cell Data  00:12:00 00:12:00  Use Excel Help  00:05:00 00:05:00 Performing Calculations Performing Calculations https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/ 3/15

  4. 9/20/2018 Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management  Create Worksheet Formulas  00:15:00 00:15:00  Insert Functions  00:17:00 00:17:00  Reuse Formulas and Functions  00:17:00 00:17:00 Modifying a Worksheet Modifying a Worksheet  Insert, Delete, and Adjust Cells, Columns, and Rows  00:10:00 00:10:00  Search for and Replace Data  00:09:00 00:09:00  Use Proo?ng and Research Tools  00:07:00 00:07:00 Formatting a Worksheet Formatting a Worksheet  Apply Text Formats  00:17:00 00:17:00  Apply Number Format  00:08:00 00:08:00  Align Cell Contents  00:09:00 00:09:00  Apply Styles and Themes  00:12:00 00:12:00  Apply Basic Conditional Formatting  00:11:00 00:11:00  Create and Use Templates  00:07:00 00:07:00 Printing Workbooks Printing Workbooks  Preview and Print a Workbook  00:10:00 00:10:00  Set Up the Page Layout  00:08:00 00:08:00  Con?gure Headers and Footers  00:07:00 00:07:00 https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/ 4/15

  5. 9/20/2018 Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management Managing Workbooks Managing Workbooks  Manage Worksheets  00:05:00 00:05:00  Manage Workbook and Worksheet Views  00:07:00 00:07:00  Manage Workbook Properties  00:05:00 00:05:00 Working with Functions Working with Functions  Work with Ranges  00:18:00 00:18:00 FREE FREE  Use Specialized Functions  00:11:00 00:11:00  Work with Logical Functions  00:23:00 00:23:00  Work with Date & Time Functions  00:08:00 00:08:00  Work with Text Functions  00:11:00 00:11:00 Working with Lists Working with Lists  Sort Data  00:10:00 00:10:00  Filter Data  00:10:00 00:10:00  Query Data with Database Functions  00:09:00 00:09:00  Outline and Subtotal Data  00:09:00 00:09:00 Analyzing Data Analyzing Data  Create and Modify Tables  00:15:00 00:15:00  Apply Intermediate Conditional Formatting  00:07:00 00:07:00 https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/ 5/15

  6. 9/20/2018 Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management  Apply Advanced Conditional Formatting  00:05:00 00:05:00 Visualizing Data with Charts Visualizing Data with Charts  Create Charts  00:13:00 00:13:00  Modify and Format Charts  00:12:00 00:12:00  Use Advanced Chart Features  00:12:00 00:12:00 Using PivotTables and PivotCharts Using PivotTables and PivotCharts  Create a PivotTable  00:13:00 00:13:00  Analyze PivotTable Data  00:12:00 00:12:00  Present Data with PivotCharts  00:07:00 00:07:00  Filter Data by Using Timelines and Slicers  00:11:00 00:11:00 Working with Multiple Worksheets and Workbooks Working with Multiple Worksheets and Workbooks  Use Links and External References  00:12:00 00:12:00 FREE FREE  Use 3-D References  00:06:00 00:06:00  Consolidate Data  00:05:00 00:05:00 Using Lookup Functions and Formula Auditing Using Lookup Functions and Formula Auditing  Use Lookup Functions  00:12:00 00:12:00  Trace Cells  00:09:00 00:09:00  Watch and Evaluate Formulas  00:08:00 00:08:00 https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/ 6/15

  7. 9/20/2018 Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management Sharing and Protecting Workbooks Sharing and Protecting Workbooks  Collaborate on a Workbook  00:19:00 00:19:00  Protect Worksheets and Workbooks  00:08:00 00:08:00 Automating Workbook Functionality Automating Workbook Functionality  Apply Data Validation  00:13:00 00:13:00  Search for Invalid Data and Formulas with Errors  00:04:00 00:04:00  Work with Macros  00:18:00 00:18:00 Creating Sparklines and Mapping Data Creating Sparklines and Mapping Data  Create Sparklines  00:07:00 00:07:00  MapData  00:07:00 00:07:00 Forecasting Data Forecasting Data  Determine Potential Outcomes Using Data Tables  00:08:00 00:08:00  Determine Potential Outcomes Using Scenarios  00:09:00 00:09:00  Use the Goal Seek Feature  00:04:00 00:04:00  Forecasting Data Trends  00:05:00 00:05:00 COURSE REVIEWS COURSE REVIEWS https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/ 7/15

  8. 9/20/2018 Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management 4.7 4.7   8 ratings 0 0 5 STARS 5 STARS 0 0 4 STARS 4 STARS 0 0 3 STARS 3 STARS 0 0 2 STARS 2 STARS 0 0 1 STARS 1 STARS NO REVIEWS FOUND FOR THIS COURSE. NO REVIEWS FOUND FOR THIS COURSE. RELATED COURSES RELATED COURSES https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/ 8/15

  9. 9/20/2018 Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management Microsoft O?ce Essential Skills £ £307.00 307.00 £ £16.00 16.00 490   https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/ 9/15

  10. 9/20/2018 Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management NLP Practitioner Diploma £ £309.00 309.00 £ £24.00 24.00 458   https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/ 10/15

  11. 9/20/2018 Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management Aromatherapy Diploma Level 3 £ £309.00 309.00 £ £16.00 16.00 605   https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/ 11/15

  12. 9/20/2018 Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management Level 3 Diploma in Alternative Medicine - Reiki £ £309.00 309.00 £ £19.00 19.00 556   https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/ 12/15

  13. 9/20/2018 Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management Website Development Training Level 3 £ £309.00 309.00 £ £19.00 19.00 517   https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/ 13/15

  14. 9/20/2018 Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management UX Design Certi?cate Level 2 £ £309.00 309.00 £ £19.00 19.00 323   505 STUDENTS ENROLLED 505 STUDENTS ENROLLED https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/ 14/15

  15. 9/20/2018 Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management COPYRIGHT © LIBM ABOUT ABOUT TERMS & CONDITIONS TERMS & CONDITIONS PRIVACY POLICY PRIVACY POLICY CONTACT CONTACT https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/ 15/15