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) ( 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
https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/
1/15
9/20/2018
Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management
£603.00 £23.00
1 YEAR ADVANCED, BEGINNER, INTERMEDIATE COURSE BADGE COURSE CERTIFICATE
59
NUMBER OF UNITS
0
NUMBER OF QUIZZES
10 HOURS, 25 MINUTES
HOME
CURRICULUM
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! 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
9/20/2018
Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management
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: 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? 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 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
Getting Started with Microsoft O
Navigate the Excel User Interface
ce Excel 2016
00:28:00
Use Excel Commands
00:10:00
Create and Save a Basic Workbook
00:19:00
Enter Cell Data
00:12:00
Use Excel Help
00:05:00
FREE
Performing Calculations https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/
3/15
9/20/2018
Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management
Create Worksheet Formulas
00:15:00
Insert Functions
00:17:00
Reuse Formulas and Functions
00:17:00
Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows
00:10:00
Search for and Replace Data
00:09:00
Use Proo ng and Research Tools
00:07:00
Formatting a Worksheet
Apply Text Formats
00:17:00
Apply Number Format
00:08:00
Align Cell Contents
00:09:00
Apply Styles and Themes
00:12:00
Apply Basic Conditional Formatting
00:11:00
Create and Use Templates
00:07:00
Printing Workbooks
Preview and Print a Workbook
00:10:00
Set Up the Page Layout
00:08:00
Con gure Headers and Footers
00:07:00
https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/
4/15
9/20/2018
Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management
Managing Workbooks
Manage Worksheets
00:05:00
Manage Workbook and Worksheet Views
00:07:00
Manage Workbook Properties
00:05:00
00:18:00
Working with Functions
Work with Ranges
Use Specialized Functions
00:11:00
Work with Logical Functions
00:23:00
Work with Date & Time Functions
00:08:00
Work with Text Functions
00:11:00
FREE
Working with Lists
Sort Data
00:10:00
Filter Data
00:10:00
Query Data with Database Functions
00:09:00
Outline and Subtotal Data
00:09:00
Analyzing Data
Create and Modify Tables
00:15:00
Apply Intermediate Conditional Formatting
00:07:00
https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/
5/15
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
Visualizing Data with Charts
Create Charts
00:13:00
Modify and Format Charts
00:12:00
Use Advanced Chart Features
00:12:00
Using PivotTables and PivotCharts
Create a PivotTable
00:13:00
Analyze PivotTable Data
00:12:00
Present Data with PivotCharts
00:07:00
Filter Data by Using Timelines and Slicers
00:11:00
00:12:00
Working with Multiple Worksheets and Workbooks
Use Links and External References
Use 3-D References
00:06:00
Consolidate Data
00:05:00
FREE
Using Lookup Functions and Formula Auditing
Use Lookup Functions
00:12:00
Trace Cells
00:09:00
Watch and Evaluate Formulas
00:08:00
https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/
6/15
9/20/2018
Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management
Sharing and Protecting Workbooks
Collaborate on a Workbook
00:19:00
Protect Worksheets and Workbooks
00:08:00
Automating Workbook Functionality
Apply Data Validation
00:13:00
Search for Invalid Data and Formulas with Errors
00:04:00
Work with Macros
00:18:00
Creating Sparklines and Mapping Data
Create Sparklines
00:07:00
MapData
00:07:00
Forecasting Data
Determine Potential Outcomes Using Data Tables
00:08:00
Determine Potential Outcomes Using Scenarios
00:09:00
Use the Goal Seek Feature
00:04:00
Forecasting Data Trends
00:05:00
COURSE REVIEWS
https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/
7/15
9/20/2018
Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management
4.7 8 ratings
5 STARS
0
4 STARS
0
3 STARS
0
2 STARS
0
1 STARS
0
NO REVIEWS FOUND FOR THIS COURSE.
RELATED COURSES
https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/
8/15
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 £16.00
https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/
490
9/15
9/20/2018
Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management
NLP Practitioner Diploma
£309.00 £24.00
https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/
458
10/15
9/20/2018
Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management
Aromatherapy Diploma Level 3
£309.00 £16.00
https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/
605
11/15
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 £19.00
https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/
556
12/15
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 £19.00
https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/
517
13/15
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 £19.00
323
505 STUDENTS ENROLLED
https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/
14/15
9/20/2018
Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) - London Institute of Business and Management and Management
COPYRIGHT © LIBM ABOUT
TERMS & CONDITIONS
https://www.libm.co.uk/course/microsoft-excel-complete-course-beginner-intermediate-advanced/
PRIVACY POLICY
CONTACT
15/15