Free weekly calendar templates on Microsoft365.com
Use create.microsoft.com to find free weekly calendar templates for Excel. Download weekly calendars, planners, and scheduling templates for Excel.
Customize the Quick Access Toolbar - Microsoft Support
You can move the Quick Access Toolbar from one of the two possible locations, and you can add buttons that represent commands to the Quick Access Toolbar. Notes: You cannot increase the size of the buttons representing the commands by an option in Microsoft Office.
MINIFS function - Microsoft Support
The MINIFS function returns the minimum value among cells specified by a given set of conditions or criteria. Note: This feature is available on Windows or Mac if you have Office 2019, or if you have a Microsoft 365 subscription. If you are a Microsoft 365 subscriber, make sure you have the latest version of Office.
Use sparklines to show data trends - Microsoft Support
Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. Position a sparkline near its data for greatest impact. Select a blank cell at the end of a row of data. Select Insert and pick Sparkline type, like Line, or Column.
Combine multiple queries (Power Query) - Microsoft Support
Power Query provides an intuitive user interface for combining multiple queries within your Excel workbook by merging or appending them. The Merge and Append operations are performed on any Power Query with a tabular shape that is independent …
Tutorial: Import Data into Excel, and Create a Data Model
These tutorials build and refine an Excel workbook from scratch, build a data model, then create amazing interactive reports using Power View. The tutorials are designed to demonstrate Microsoft Business Intelligence features and capabilities in …
Define and solve a problem by using Solver - Microsoft Support
Solver is a Microsoft Excel add-in program you can use for what-if analysis. Use Solver to find an optimal (maximum or minimum) value for a formula in one cell — called the objective cell — subject to constraints, or limits, on the values of other formula cells on a worksheet.
Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These characters can be the asterisk (*), the question mark (?), and the tilde (~).
Automate tasks with the Macro Recorder - Microsoft Support
To automate a repetitive task, you can record a macro with the Macro Recorder in Microsoft Excel. Imagine you have dates in random formats and you want to apply a single format to all of them. A macro can do that for you. You can record a macro applying the format you want, and then replay the macro whenever needed.
Use the Analysis ToolPak to perform complex data analysis
Learn how to use the Analysis ToolPak to perform complex Excel data analysis. Explore the various data analysis functions available in Excel.
Install the Windows Fax driver or service to use Internet Fax in Office
Microsoft Office has a feature that lets you send Outlook, Word, Excel, and PowerPoint files as Internet faxes. This feature relies on having the Windows Fax Printer Driver or Fax Services installed on the computer to send the faxes. If the Windows Fax feature is not enabled for your version of Windows, you can enable it.