For more info visit:

Microsoft 77-728 Exam Reference

Topics of 77-728 Exam

These are the following Microsoft 77-728 Dumps topics for Microsoft 77-728 exam:

• Create advanced charts and tables (25-30%) Create sophisticated charts: Include trend lines in charts, produce dual-axis charts, keep the chart as a design template. Develop and manage pivot tables. Develop pivot tables, change field selections and alternatives, create slicers, group pivot table data, recommendation information in the pivot table using the GETPIVOTDATA function, include calculated fields, layout data Create and manage pivot charts. Produce pivot charts, manipulate options in existing pivot charts, use pivot chart styles, explore information in pivot charts.

• Apply custom information styles and even layouts (20-25%) Apply custom information styles and recognition. Develop custom number styles, inhabit cells using innovative fill series alternatives, configure data recognition Apply formatting and progressive conditional filter. Develop custom conditional formatting rules, produce conditional formatting rules using solutions, manage conditional formatting rules. Develop and edit custom workbook items. Develop custom hatch styles, produce and customize cell styles, develop and edit custom templates, create and edit simple macros, insert and set type controls. Prepare a workbook for internationalization. Present information in many global layouts, apply global currency styles, manage multiple options for characters + Body and + Heading.

• Take care of workbook options and settings (10-15%) Manage workbooks: Maintain a workbook as a design template, duplicate macros between workbooks, reference data in another workbook, reference information using organized references, allow macros in a workbook, display multi-function hidden bar tabs Manage a workbook testimonial. Restrict editing, protect a worksheet, set formula calculation options, protect workbook structure, manage workbook versions, password protect workbook.

• Develop innovative formulas (35-40%) Apply functions in solutions. Perform rational operations using the AND, OR, and NOT functions; perform logical operations using nested functionality; perform analytical operations using SUMIFS, AVERAGEIFS, and COUNTIFS works Finding information using functions. Find data using the VLOOKUP function, find information using the HORIZ LOOK function, find information using the NEXT function, find information using the INDEX function Apply advanced day and time functions. Check the day and time using the NOW and TODAY functions, serialize the numbers using the date and time functions. Perform in-depth analysis and knowledge analysis. Recommend the day and time using the NOW and TODAY functions; import, edit, combine, view, and even link to data; configure the data; perform a what-if assessment using Objective Look for and Circumstance Manager; use cube jobs to extract information from the Excel version of information; determine information using financial functions Solve problems with formulas. Track priority and dependency, monitor cells and solutions using the main monitoring window, verify formulas using error monitoring rules, evaluate formulas Define ranges and called objects. Naming cells, naming information tables, naming tables, taking care of call ranges, and the like.

Reference: https://docs.microsoft.com/en-us/learn/certifications/exams/77-728?wt.mc_id=learningredirect_certs-web-wwl