Excel 2016 Essential Training

Navigate the Excel interface by mastering the title bar, Quick Access Toolbar, Ribbon, name area, and Formula Bar, then manage sheets, scrolling, and zoom controls.

Explore the Excel 2016 menu and ribbon system. Learn the backstage view for saving and opening files, and master ribbon display options and default commands versus addons.

Learn to customize the Excel quick access toolbar by adding commands like underline and sort, removing items, and using more commands to adjust its position.

A workbook is a collection of worksheets you can add with the plus icon, rename, and color the tabs. Navigate with shortcuts and know the limits: 1,048,576 rows, 16,384 columns.

Explore Excel 2016's formula bar, learn how it shows cell addresses and contents, and identify values versus formulas across worksheets like sales data, safety data, and insurance data.

Explore the Excel 2016 status bar, showing macro status and quick stats—average, count, and sum for highlighted data—and customize options while switching views with zoom.

Learn to navigate Excel 2016 with mouse or keyboard arrows, understand cursor changes for selecting, copying, and resizing cells, and switch sheets via tabs or Ctrl+Page Up/Down.

Learn to use the shortcut menu and mini toolbar to insert and delete rows, columns, and worksheets in Excel 2016, plus quick formatting through the mini toolbar.

Create a new workbook in Excel 2016 using the control + end shortcut or the file menu, then choose a blank workbook or training templates to start.

Learn how Excel 2016 help guides you through the ribbon with hover descriptions and shortcuts, and how the Tell Me and light bulb help work.

Master data entry and editing in Excel by distinguishing left-justified text from right-justified numbers, and edit entries using the formula bar or by double-clicking, while applying basic formatting.

Learn to autofill data in Excel 2016 by dragging the fill handle to auto-complete months, weekdays, and quarters horizontally or vertically, or type the first three letters.

Explore undo and redo in Excel 2016 to revert edits, restore deleted data, and manage up to 100 levels of history, with limits on sheet deletions and saving.

Learn to add and remove comments in Excel 2016 by right-clicking a cell and inserting a comment, then typing notes and using review tools to navigate, next/previous, hide, or delete.

Learn to save and save as in Excel 2016, including naming files, choosing save locations, selecting compatibility formats (Excel 2003), and using Ctrl+S for quick saving.

Learn to create formulas and simple functions in Excel 2016 to compute profit as income minus expenses, and use sum and average to total and average monthly data.

Learn to copy formulas to adjacent cells in Excel, maintaining the same relationships as you drag the formula right or down, and apply sums and averages across the range.

Calculate year-to-date totals in Excel by building a dynamic YTD formula that sums current and prior months' profits, with relative references to auto-update as expenses change across columns.

Master how to compute monthly percentage growth in excel 2016 by building a correct formula with parentheses, understanding operator precedence, and handling scenarios where expenses exceed income.

Examine relative and absolute cell referencing in Excel, learn how formulas copy down and change, and how to fix values with dollar signs using F4 for accurate calculations.

Learn to use the sum and average functions in Excel 2016, including typing =sum(...), using autosum, and calculating average, max, and min across rows and columns.

Explore common Excel 2016 functions such as rank, count, and large. Apply them to a salary dataset to find rankings, the second largest value, and the median.

Explore font styles and effects in Excel 2016, including bold, italics, underline, color fills, and font type. Adjust size, apply superscript or subscript, and align text left, right, or justify.

Adjust row heights and column widths by selecting the range, dragging between headers, or using best fit. Insert and merge cells, resize selected rows, and view width in pixels.

Learn how to align and wrap text in Excel 2016, apply left, right, and center justification, merge headings, and rotate text for clearer data presentation.

Learn how to apply and customize borders in Excel 2016, including outside borders, line color, thickness, and border styles. Master drawing, erasing, and removing borders across cells to highlight data.

Explore formatting numbers and dates in Excel 2016, applying currency and accounting formats, adjusting decimals, using custom formats, and handling regional date representations and simple date arithmetic.

Explore conditional formatting in Excel 2016 to highlight salaries greater than 2500, apply color scales and data bars, and manage rules for confidentiality.

Discover how to create and format a table in Excel 2016, convert data to a table, and use slicers and design options to filter and organize data.

Learn to implement data validation in Excel 2016 by restricting entries to whole numbers, text length, and dates, using dropdown lists, and customizing input and error messages for specific ranges.

Learn to split a single Excel 2016 column into two with text to columns, using delimited and fixed-width options, separating by space or ampersand and setting the destination.

Learn to use Excel's pmt function to calculate monthly loan installments, based on rate per period, total payments, and loan amount, shown with a 50 lakh loan over 10 years.

Learn to build a data table in Excel to display EMI for various loan amounts and years at 11 percent, using the EMI calculation and the data table feature.

Learn to use Excel 2016's scenario manager to create and compare multiple input scenarios, such as loan amount, period, and interest rate, with a summary sheet showing EMI outcomes.

Explore how to use Excel 2016's goal seek to find the loan amount that yields a target emi, and how changing the interest rate affects the result via what-if analysis.

Explore autofill series in excel 2016 to quickly generate number sequences, such as 1 to 10 or 1 to 100, by typing the first value and dragging the fill handle.

Master flash fill in Excel 2016 to split names, construct emails, and join names. Use it to convert text to proper case and extract parts from data, such as dates.

Learn to use vlookup exact match in Excel 2016 to fetch prices from a table. Define the lookup column and apply results with data validation and named ranges.

Use HLOOKUP in Excel 2016 to retrieve a price from horizontally arranged data, selecting the table, and enforcing an exact match with 0.

learn to use vlookup with the approximate match option to assign discounts based on billing amount, then construct formulas to compute the discount and the adjusted total.

Sort data in Excel 2016 to order numbers from smallest to largest or largest to smallest, including multi-level sorts by color, dates, and multiple columns such as country and age.

Learn how to apply Excel 2016 subtotals to group data by year and quarter, summarize revenue with grand totals, and manage subtotal visibility.

Learn to apply, clear, and copy filtered data in Excel 2016, using the data tab to filter by date, text, and numeric values.

Learn to build a branch-wise pivot table from data in Excel 2016, placing branch names in rows, account types in columns, and summing amounts to gain insights.

Learn to create a branch-wise pivot table in Excel 2016 that shows branch names, account types, and customer type filters (new or existing) to summarize open accounts.

Learn to create a date-wise pivot in Excel 2016 to compare branch performance on selected dates. Use dates as filters, branches as columns, and sums as values to inform decisions.

Learn to create a pivot table in Excel 2016 to count account types by branch, placing branch names in rows, account types in columns, and counts in the values.

Learn to build buckets in a pivot table by grouping amounts into ranges, count accounts per bucket, and add a calculated field to show percentage of run total.

Create a pivot table in an existing worksheet, add data fields to count and show percentages, then apply conditional formatting to color-code higher values.

Create graphs from pivot data by inserting a pivot table, setting branch names as the axis, and account types as values and legend, then switch to a column chart.

Learn to merge Excel data into a Word document using mail merge, including selecting recipients, configuring the greeting line, and generating a merge output for printing or emailing.