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

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

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

## 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

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