Final Exam: Business Analyst
Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level
Overview/Description
Final Exam: Business Analyst will test your knowledge and application of the topics presented throughout the Business Analyst track of the Skillsoft Aspire Business Analyst to Data Analyst Journey.
Expected Duration (hours)
0.0
Lesson Objectives Final Exam: Business Analyst
analyze data use the Subtotal feature from the Data menu
and create pivot tables by attempting to link multiple such tables
apply custom formatting to first and last points
apply workbook-level protection options such as open in read-only mode, encrypting with the password, add a digital signature, and marking as final
Auto-detect relationships between different relations use the PivotTable feature
bin data by category, by bin width, or by specifying a fixed number of bins
combine multiple visualizations into a single chart using the combo chart type
combine the Print and Page Layout menu features to precisely control how workbooks are printed
configuring AutoSave and AutoRecover behavior and the default save location
construct at-a-glance visualizations use Sparklines to construct lightweight charts without axes or units contained within individual cells
contrast Comments and Notes in Excel
Copy-paste data and use the Format Cells right-click menu option to customize
Correctly utilize absolute and relative cell references in worksheet formulae
create links to external workbooks use the Paste Link option from the Paste menu
create new formatting rules and varying both conditions governed by the rule as well as precise formatting aspects
customize headers and footers
customize that ribbon by creating a new ribbon tab
customize the quick-access toolbar
edit external links use the Data menu
Efficiently and quickly perform simple statistical analysis of two-dimensional data
enable Analysis ToolPak
enable Analysis ToolPak and use it to compute correlation as well as covariance matrices
enable the powerful Solver add-in
export workbooks to formats such as PDF/XPS
generate random numbers drawn from various distributions use Analysis ToolPak
identify the capabilities and limitations of the Auto Outline feature
implement ANOVA (Analysis of Variance) use Analysis ToolPak to analyze variances
implement ANOVA (Analysis of Variance) use Analysis ToolPak to analyze variances within groups and between groups
implement common data-cleaning operations such as the elimination of duplicates via the Data menu
implement hypothesis testing
Insert and delete rows and columns
insert charts and customize Chart Elements such as the axes, title, data labels, data callouts, and gridlines
introduce Excel Data Tables and understand the #SPILL! Error
introduce the use of worksheet formulas and the semantics of copy-pasting formulas with relative cell references
Launch Microsoft Excel, explore available templates, and customize the quick-access toolbar
open comma- and tab-delimited text files use the Data Import menu item
perform conditional analysis use the worksheet IF() function
perform univariate EDA (exploratory data analysis) use box-and-whisker plots
recognize different charts
recognize the pitfalls of create such pivot tables without accurately capturing relationships between relations
recognize the role of PowerPivot in analytical Big Data processing
specify Data Validation constraints to prevent typos and reduce the need for data cleaning
understand the pitfalls of create such pivot tables without accurately capturing relationships between relations
understand the role of PowerPivot in making Excel a powerful tool for analytical Big Data processing
use built-in templates and saving a commonly-used workbook as an Excel Template (.xltx) file
use conditional aggregate functions such as COUNTIF() and COUNTIFS() to perform aggregate operations based on specific conditions
use Excel's powerful functionality for filling in blank/missing values use the Find & Select menu option and the Go To Special feature
use Goal Seek for solving
use keyboard shortcuts to insert line breaks inside a cell
use scatter plots to examine relationships between two numeric data column
use the Chart Design item from the toolbar ribbon to quickly change chart layout and color
use the Conditional Formatting menu item to highlight cells based on rules
use the Filter feature from the Data menu to focus on specific subsets of data
use the INDEX() and MATCH() functions to perform two-dimensional lookups
use the logical OR function to construct a boolean predicate that can be used to highlight weekends in a range of dates
use the Protect Sheet feature from the Review menu to control how a sheet can be edited
use the ROW() function to alter highlighting based on cell location
utilize the powerful and popular VLOOKUP() and HLOOKUP() functions for one-dimensional lookups that join ranges of data based on a common column
utilize the What-If Analysis feature in Excel
visualize foreign-key relationships use entity-relationship diagrams in PowerPivot
Course Number: it_febada_01_enus
Expertise Level
Beginner