Excel in Accounting

Master the fill handle in excel to auto-fill months and numbers by dragging, explore copying and pasting, and practice calculating percentages using whole numbers and percentage formats.

Learn copy and paste techniques in Excel, using ctrl-c and ctrl-v to perform multiplication and copy formulas across cells, and explore paste special options.

Master paste special to paste only values, not formulas, and paste link to preserve original cell references.

Learn to insert and delete rows, and to hide or unhide columns in Excel. Apply summation function and use control semicolon and control shift semicolon to insert date and time.

Name cells and ranges, define the suggested name, apply a net value multiplied by 1.2 for 20% vat, and use drag to fill down and shortcuts to format and copy.

Construct a three-week costing spreadsheet by recording weekly hours per role, applying locked rate formulas, and formatting totals, currency, and borders while updating for laptops and rate changes.

Learn how to compute commissions in Excel for sales staff by using a 2% rate, calculating commission from sales, and determining total earnings with sum and salary plus commission.

Explore variance analysis by comparing actual sales to budgeted targets, calculating the percentage difference, and creating formulas to quantify variances in sales performance.

Explore how the if function evaluates conditions using greater-than tests to award bonuses or discounts, with absolute references in practical discount scenarios.

Learn to use the Excel if function to classify scores as pass or fail, applying text criteria and cell locking, and see how a new pass mark updates results.

Learn to use count, counta, and countif to tally non-empty cells and threshold-based items, then build a nested if for discounts between 500 and 1000 with example data.

Explore conditional formatting in excel by applying rules to exam results, highlighting values below 50% with red backgrounds and white text, and using top 3 rules with green fills.

Master the Excel rank function to rank numbers by a reference, choosing 0 for descending order, and identify the top values in a data range.

Create and customize charts and graphs from sales and net price data, using pie, 3d pie, column, bar, and line charts, with chart titles, axis labels, and legend.

Explore data manipulation in Excel: adjust column width, wrap text, and align cells; sort with a custom sort (largest to smallest) on column F and use IF to flag reorder.

Learn how to print Excel workbooks with print preview, set print area and margins, fit to one page, customize headers, footers, and page numbers, and print charts, formulas, and comments.

Explore three types of cell contents (value, formula, text), edit with F2, fill series with drag, show formulas, and use sum and IF syntax for calculations.

Explore data security in Excel by protecting sheets and cells, encrypting workbooks, and managing backups and passwords to control sharing and recover data.

Learn to apply data validation in a spreadsheet, setting input messages and warnings for ranges such as eight to twenty and up to sixty hours, with practical examples.

Explore how to apply Excel's subtotal function to calculate average, maximum, minimum, and sum across a data range, with practical steps and examples.

Use the filter to locate specific supplier inventory data, selecting A, B, and C, then refine to only B and C to view targeted results.

Use find and replace in spreadsheets to locate items with ctrl+f and replace them with new text, then use replace all to update multiple occurrences such as a supplier name.

Create and customize a pivot table in Excel to analyze sales by customer and source, then convert it to a pivot chart to visualize total sales and items sold.

Master a three dimensional multihued spreadsheet to consolidate income statements and balance sheets, link worksheets across branches, and copy formulas for efficient multi-sheet analysis.

Format data as a table by selecting a range and applying a table style with a header. Use table design to name the table, filter, and remove duplicates.

Learn how to use vertical and horizontal lookup tables to retrieve prices and VAT from a range, using vlookup with exact matches and column indexes.

Explore what-if analysis in excel using a two-variable data table to assess mortgage payments under varying interest rates and terms, with the pmt function and formatting.

Explore scenario techniques in Excel for accounting by using the scenario manager to adjust original cost, technician costs, and rates, and review the scenario summary for quick insights.

Use goal seek in Excel to find how many years it takes to repay a mortgage when paying 300 per month, by adjusting the changing cell.

Learn to create combination charts in Excel by pairing a column chart of precious metal price with a line chart of average price, using a secondary axis for clearer presentation.

Identify and fix circular references in payroll spreadsheets by using formula auditing tools to detect errors, remove loops, and correctly compute total pay from base salary and bonus.

Learn to trace precedents and dependents in Excel, visualize how data flows into totals through formulas, and remove the arrows to manage dependencies.

Examine rounding errors in petty cash calculations and learn to apply round, round up, and round down to specify two decimal places and nearest pound in spreadsheets.

Identify common Excel errors such as hash errors and division by zero, and learn to audit and evaluate formulas, fix invalid references, and ensure valid numbers in accounting worksheets.

Master common Excel concepts for accounting by testing your knowledge on saving workbooks, validation, multisheet and 3D references, filtering, trend lines, dependent variables, median, histogram, and division-by-zero errors.