FLOOR Function in Excel: Round Down to a Multiple (Classic)
FLOOR rounds down to a multiple — full boxes you can ship, 15-minute billing blocks.
Read article →FLOOR rounds down to a multiple — full boxes you can ship, 15-minute billing blocks.
Read article →Machine learning starts with a straight line. Fit a regression in Excel with SLOPE, INTERCEPT, RSQ, LINEST and FORECAST.LINEAR, and learn how to read the numbers.
Read article →Control how pages look: margins and paper size, page breaks instead of repeated Enter, section breaks for a landscape page in a portrait document, headers, footers and page numbers that start where you want.
Read article →Use heading levels to structure a document, jump and reorganise sections with the Navigation Pane, insert an automatic table of contents, update it, and customise which levels it shows.
Read article →Stop formatting text by hand. Use Word styles for headings and body text, modify a style once to change the whole document, clear manual formatting, and build a consistent look in minutes.
Read article →CEILING rounds up to the nearest multiple — prices ending in 5 or 9, pack sizes. CEILING.MATH is the newer version that handles negatives more simply.
Read article →DateLevel: BeginnerAvailable in: Excel 2007+MINUTE returns 0–59 from a time.Syntax=MINUTE(serial_number)ArgumentWhat it.
Read article →Code linear regression with gradient descent in plain NumPy, watch the model learn slope and intercept, then check it against NumPy and scikit-learn. The foundation of all machine learning.
Read article →Build and train a two-layer neural network in plain NumPy to solve XOR — forward pass, backpropagation and gradient descent explained line by line.
Read article →Put the course together: build a half-year sales report from shop.db with total sales, GST, top customer, best month, cancellation rate and a region × category grid, then connect it to Excel.
Read article →Save a query as a view: build an order_lines view joining orders, customers and products, query it like a table, use views for reports and for hiding complexity, and know their limits.
Read article →Change data without disasters: INSERT rows, UPDATE with a WHERE you have tested, DELETE carefully, transactions with BEGIN/ROLLBACK/COMMIT, and habits that prevent “I updated every row”.
Read article →