Final Exam: Business Analyst
Excel Office 365 | Beginner
- 1 video | 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
apply workbook-level protection options such as open in read-only mode, encrypting with the password, add a digital signature, and marking as finalvisualize foreign-key relationships use entity-relationship diagrams in PowerPivotinsert charts and customize Chart Elements such as the axes, title, data labels, data callouts, and gridlinesuse scatter plots to examine relationships between two numeric data columnCorrectly utilize absolute and relative cell references in worksheet formulaebin data by category, by bin width, or by specifying a fixed number of binsconfiguring AutoSave and AutoRecover behavior and the default save locationuse the ROW() function to alter highlighting based on cell locationcreate new formatting rules and varying both conditions governed by the rule as well as precise formatting aspectsenable the powerful Solver add-inimplement common data-cleaning operations such as the elimination of duplicates via the Data menuenable Analysis ToolPakutilize the What-If Analysis feature in Excelspecify Data Validation constraints to prevent typos and reduce the need for data cleaninguse conditional aggregate functions such as COUNTIF() and COUNTIFS() to perform aggregate operations based on specific conditionsuse the INDEX() and MATCH() functions to perform two-dimensional lookupsgenerate random numbers drawn from various distributions use Analysis ToolPakutilize the powerful and popular VLOOKUP() and HLOOKUP() functions for one-dimensional lookups that join ranges of data based on a common columnintroduce the use of worksheet formulas and the semantics of copy-pasting formulas with relative cell referencesenable Analysis ToolPak and use it to compute correlation as well as covariance matricesconstruct at-a-glance visualizations use Sparklines to construct lightweight charts without axes or units contained within individual cellsopen comma- and tab-delimited text files use the Data Import menu itemuse the Chart Design item from the toolbar ribbon to quickly change chart layout and coloredit external links use the Data menuuse the Conditional Formatting menu item to highlight cells based on rulesunderstand the role of PowerPivot in making Excel a powerful tool for analytical Big Data processingapply custom formatting to first and last pointsperform conditional analysis use the worksheet IF() functionuse the Protect Sheet feature from the Review menu to control how a sheet can be editedintroduce Excel Data Tables and understand the #SPILL! Error
Launch Microsoft Excel, explore available templates, and customize the quick-access toolbarcreate links to external workbooks use the Paste Link option from the Paste menucombine multiple visualizations into a single chart using the combo chart typecustomize headers and footersEfficiently and quickly perform simple statistical analysis of two-dimensional dataimplement hypothesis testingcustomize the quick-access toolbarrecognize different chartscombine the Print and Page Layout menu features to precisely control how workbooks are printedimplement ANOVA (Analysis of Variance) use Analysis ToolPak to analyze variancescustomize that ribbon by creating a new ribbon tabexport workbooks to formats such as PDF/XPSuse the Filter feature from the Data menu to focus on specific subsets of datacontrast Comments and Notes in Excelrecognize the pitfalls of create such pivot tables without accurately capturing relationships between relationsrecognize the role of PowerPivot in analytical Big Data processinguse Excel's powerful functionality for filling in blank/missing values use the Find & Select menu option and the Go To Special featureand create pivot tables by attempting to link multiple such tablesperform univariate EDA (exploratory data analysis) use box-and-whisker plotsInsert and delete rows and columnsimplement ANOVA (Analysis of Variance) use Analysis ToolPak to analyze variances within groups and between groupsunderstand the pitfalls of create such pivot tables without accurately capturing relationships between relationsuse keyboard shortcuts to insert line breaks inside a cellidentify the capabilities and limitations of the Auto Outline featureCopy-paste data and use the Format Cells right-click menu option to customizeAuto-detect relationships between different relations use the PivotTable featureuse built-in templates and saving a commonly-used workbook as an Excel Template (.xltx) fileanalyze data use the Subtotal feature from the Data menuuse the logical OR function to construct a boolean predicate that can be used to highlight weekends in a range of datesuse Goal Seek for solving
IN THIS COURSE
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.Digital badges are yours to keep, forever.
YOU MIGHT ALSO LIKE
Course Final Exam: Security Analyst
Course Final Exam: Data Analyst
PEOPLE WHO VIEWED THIS ALSO VIEWED THESE