1 hour excel for absolute beginners

Learn how to use Excel in this one-hour course designed for complete beginners, covering how to display data, create charts, and budget both money and time.

Launch into Excel with a one-hour starter series course that delivers one-to-five minute tutorials in small chunks, designed for complete beginners and usable on most devices.

Open a new workbook from the file menu, choose a template or a blank workbook, and explore the top tabs; adjust zoom with the control key and mouse wheel.

Learn how to build a basic dataset in a spreadsheet by using columns and rows, highlight data, format and align text, delete cells, and move rows for organization.

Format Excel cells as currency or percent, adjust decimal places, and learn why percentages are decimals with practical data-entry tips.

Learn to change decimal formats in excel using the format cells dialog, switch between number types such as currency and percentage, adjust decimal places, and apply thousand separators.

Learn to total values in Excel with the sum function, using equals and brackets, and extend the result across cells by copy-paste or the bottom fill box.

Learn how to format the color of a table in Excel for beginners by applying headings, cell styles like heading one and heading two, adjust accent, and test color contrasts.

Format the worksheet with a different style to improve readability, then use the auto sum button to total values, drag the fill handle, and explore related functions like averages.

Learn to delete rows and columns, copy and paste data, and apply five major functions in Excel: auto sum, average, count, max, and min.

Create a new Excel file from scratch, select cells, and apply borders such as a box border or bottom border, while learning to add or remove borders without replacing them.

Start a new Excel project by building a monthly budget from scratch, with categories like rent, car, food, and miscellaneous, and use auto sum, currency formatting, and a labeled chart.