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 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

IN THIS COURSE

  • Playable
    1. 
    Business Analyst
    33s
    UP 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 platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 0 Likes 0  
Likes 0 Likes 0  
Likes 0 Likes 0