Excel Essentials - Boost your efficiency and save time

Apply borders to a table and choose border styles to clearly define data. Format cells as currency, adjust decimal places, and select symbols such as pounds or euro.

Learn how to split an Excel sheet horizontally and vertically, create four panes, and remove splits, then quickly hide and unhide rows, columns, and sheets using format options and right-click.

Learn to use Excel's future value function to project savings growth under a constant rate, comparing annual investments with lump-sum deposits to see how timing affects final value.

Learn to use excel logical functions—if, and, or—where true equals one and false equals zero, and test conditions like total with tax more than 500 and unit more than 100.

Master pivot charts in Excel by linking pivot tables to pivot graphs, exploring design options, and filtering data for items, regions, and clients, then refreshing data for accurate visual insights.

Master advanced sorting in Excel by using custom sort to organize data by item and client name with multiple levels, while leveraging table headers for accurate sorting.

Sort your data, then add subtotals by item to automatically calculate totals, showing three levels and item totals like brush, eraser, and felt pen.

Control formulas, validate data, and show formulas in Excel to spot errors before publishing, while using relative and absolute references and adding comments for the next user.

Learn how to name cells and ranges in Excel with the name manager, creating names like tax amount and cells, and use them across worksheets and pivots.