Learn Data Insights

Core Data Analysis With Excel (77-727)

This content is part of the LDI Data Analyst Role Path and is organised around the syllabus of the Microsoft 77-727 Exam. On completion of the MOS 77-727 Excel 2016 Core exam candidates will have a fundamental understanding of Excel 2016 and the ability to complete tasks independently. This includes the ability to create and edit a workbook with multiple sheets and representing data visually. Workbook examples that you should be able to produce after this include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

Quizzes

Quiz - Create and manage worksheets and workbooks 5 Questions

Quiz - Create and manage worksheets and workbooks 5 Questions
This 5 Question Excel quiz, drawn from 53 questions in total, focuses on the module 'Create and manage worksheets and workbooks' (30-35% of the exam). Topics include format, customize Worksheets and Workbooks. Customize options and views.

5 Tokens

Quiz - Create and manage worksheets and workbooks 10 Questions

Quiz - Create and manage worksheets and workbooks 10 Questions
This 10 question Excel quiz, drawn from 53 questions in total, focuses on the module 'Create and manage worksheets and workbooks' (30-35% of the exam). Topics include format, customize Worksheets and Workbooks. Customize options and views.

10 Tokens

Courses

No courses to display.

E-Books

No E-Books to display.

Resources

No resources to display.

No resources to display.

No resources to display.

No resources to display.

No resources to display.

No resources to display.

No resources to display.

No resources to display.

Quizzes

Quiz - Manage data cells and ranges 5 questions

Quiz - Manage data cells and ranges 5 questions
This 5 question Excel quiz, drawn from 75 questions in total, focuses on the module ' Manage data cells and ranges' (15-20% of the exam). Topics include managing cells and ranges, and organising data.

5 Tokens

Quiz - Manage data cells and ranges 10 questions

Quiz - Manage data cells and ranges 10 questions
This 10 question Excel quiz, drawn from 75 questions in total, focuses on the module ' Manage data cells and ranges' (15-20% of the exam). Topics include managing cells and ranges, and organising data.

10 Tokens

Courses

Excel 77-727 Module 2.1 Course: Insert Data in Cells and Ranges

Excel 77-727 Module 2.1 Course: Insert Data in Cells and Ranges

5 Tokens

Excel 77-727 Module 2.3

Excel 77-727 Module 2.3
This is test description for Excel 77-727 Module 2.3 Course: Summarise and Organise Data.

5 Tokens

E-Books

No E-Books to display.

Resources

No resources to display.

No resources to display.

No resources to display.

No resources to display.

No resources to display.

No resources to display.

No resources to display.

No resources to display.

Quizzes

No quizzes to display.

Courses

No courses to display.

E-Books

No E-Books to display.

Resources

No resources to display.

No resources to display.

No resources to display.

No resources to display.

No resources to display.

No resources to display.

No resources to display.

No resources to display.

Quizzes

Quiz - Perform operations with formulas and functions 5 questions

Quiz - Perform operations with formulas and functions 5 questions
This 5 Question Excel quiz, drawn from 47 questions in total, focuses on the module ‘Perform operations with formulas and functions’ (10-15% of the exam). Topics include using functions, perform conditional operation and format and identify text.

5 Tokens

Quiz - Perform operations with formulas and functions 10 questions

Quiz - Perform operations with formulas and functions 10 questions
This 10 Question Excel quiz, drawn from 47 questions in total, focuses on the module ‘Perform operations with formulas and functions’ (10-15% of the exam). Topics include using functions, perform conditional operation and format and identify text.

10 Tokens

Courses

No courses to display.

E-Books

No E-Books to display.

Resources

No resources to display.

No resources to display.

No resources to display.

No resources to display.

No resources to display.

No resources to display.

No resources to display.

Quizzes

No quizzes to display.

Courses

No courses to display.

E-Books

No E-Books to display.

Resources

No resources to display.

No resources to display.

No resources to display.

No resources to display.

No resources to display.

No resources to display.

No resources to display.

No resources to display.