Final Exam: Business Analyst
1 Video | 30m 32s
- Includes Assessment
- Earns a Badge
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.
WHAT YOU WILL LEARN
analyze data use the Subtotal feature from the Data menuand create pivot tables by attempting to link multiple such tablesapply custom formatting to first and last pointsapply workbook-level protection options such as open in read-only mode, encrypting with the password, add a digital signature, and marking as finalAuto-detect relationships between different relations use the PivotTable featurebin data by category, by bin width, or by specifying a fixed number of binscombine multiple visualizations into a single chart using the combo chart typecombine the Print and Page Layout menu features to precisely control how workbooks are printedconfiguring AutoSave and AutoRecover behavior and the default save locationconstruct at-a-glance visualizations use Sparklines to construct lightweight charts without axes or units contained within individual cellscontrast Comments and Notes in ExcelCopy-paste data and use the Format Cells right-click menu option to customizeCorrectly utilize absolute and relative cell references in worksheet formulaecreate links to external workbooks use the Paste Link option from the Paste menucreate new formatting rules and varying both conditions governed by the rule as well as precise formatting aspectscustomize headers and footerscustomize that ribbon by creating a new ribbon tabcustomize the quick-access toolbaredit external links use the Data menuEfficiently and quickly perform simple statistical analysis of two-dimensional dataenable Analysis ToolPakenable Analysis ToolPak and use it to compute correlation as well as covariance matricesenable the powerful Solver add-inexport workbooks to formats such as PDF/XPSgenerate random numbers drawn from various distributions use Analysis ToolPakidentify the capabilities and limitations of the Auto Outline featureimplement ANOVA (Analysis of Variance) use Analysis ToolPak to analyze variancesimplement ANOVA (Analysis of Variance) use Analysis ToolPak to analyze variances within groups and between groupsimplement common data-cleaning operations such as the elimination of duplicates via the Data menuimplement hypothesis testing
Insert and delete rows and columnsinsert charts and customize Chart Elements such as the axes, title, data labels, data callouts, and gridlinesintroduce Excel Data Tables and understand the #SPILL! Errorintroduce the use of worksheet formulas and the semantics of copy-pasting formulas with relative cell referencesLaunch Microsoft Excel, explore available templates, and customize the quick-access toolbaropen comma- and tab-delimited text files use the Data Import menu itemperform conditional analysis use the worksheet IF() functionperform univariate EDA (exploratory data analysis) use box-and-whisker plotsrecognize different chartsrecognize the pitfalls of create such pivot tables without accurately capturing relationships between relationsrecognize the role of PowerPivot in analytical Big Data processingspecify Data Validation constraints to prevent typos and reduce the need for data cleaningunderstand the pitfalls of create such pivot tables without accurately capturing relationships between relationsunderstand the role of PowerPivot in making Excel a powerful tool for analytical Big Data processinguse built-in templates and saving a commonly-used workbook as an Excel Template (.xltx) fileuse conditional aggregate functions such as COUNTIF() and COUNTIFS() to perform aggregate operations based on specific conditionsuse Excel's powerful functionality for filling in blank/missing values use the Find & Select menu option and the Go To Special featureuse Goal Seek for solvinguse keyboard shortcuts to insert line breaks inside a celluse scatter plots to examine relationships between two numeric data columnuse the Chart Design item from the toolbar ribbon to quickly change chart layout and coloruse the Conditional Formatting menu item to highlight cells based on rulesuse the Filter feature from the Data menu to focus on specific subsets of datause the INDEX() and MATCH() functions to perform two-dimensional lookupsuse the logical OR function to construct a boolean predicate that can be used to highlight weekends in a range of datesuse the Protect Sheet feature from the Review menu to control how a sheet can be editeduse the ROW() function to alter highlighting based on cell locationutilize the powerful and popular VLOOKUP() and HLOOKUP() functions for one-dimensional lookups that join ranges of data based on a common columnutilize the What-If Analysis feature in Excelvisualize foreign-key relationships use entity-relationship diagrams in PowerPivot
IN THIS COURSE
1.Business Analyst33sUP NEXT
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platformDigital badges are yours to keep, forever.