Excel video training - Microsoft Support
WEBA list of Excel training, from entry level to advanced skills, plus templates and other resources.
Download free, pre-built templates - Microsoft Support
WEBYou can download free, pre-built document templates with useful and creative themes from Office when you click File > New in your Office app. Templates can include calendars, business cards, letters, cards, brochures, newsletters, resumes, cover letters, presentations, social media and much more.
About Power Query in Excel - Microsoft Support
WEBWith Power Query (known as Get & Transform in Excel), you can import or connect to external data, and then shape that data, for example remove a column, change a data type, or merge tables, in ways that meet your needs. Then, you can load your query into Excel to create charts and reports.
Power Query for Excel Help - Microsoft Support
WEBPower Query is a technology embedded in Excel and other Microsoft products designed to help you shape your data. In Excel, select the Data tab on the ribbon to see the Get & Transform Data and Queries & Connections groups.
View or change the properties for an Office file - Microsoft Support
WEBDocument properties, also known as metadata, are details about a file that describe or identify it. They include details such as title, author name, subject, and keywords that identify the document's topic or contents. If you include the document properties for your files, you can easily organize and identify them later.
Create a relationship between tables in Excel - Microsoft Support
WEBHave you ever used VLOOKUP to bring a column from one table into another table? Now that Excel has a built-in Data Model, VLOOKUP is obsolete. You can create a relationship between two tables of data, based on matching data in each table.
Create a drop-down list - Microsoft Support
WEBYou can help people work more efficiently in worksheets by using drop-down lists in cells. Drop-downs allow people to pick an item from a list that you create. Windows macOS Web. In a new worksheet, type the entries you want to appear in your drop-down list.
Overview of Excel tables - Microsoft Support
WEBTo make managing and analyzing a group of related data easier, you can turn a range of cells into an Excel table (previously known as an Excel list). Note: Excel tables should not be confused with the data tables that are part of a suite of what-if analysis commands.
Open XML Formats and file name extensions - Microsoft Support
WEBMicrosoft Office uses the XML-based file formats, such as .docx, .xlsx, and .pptx. These formats and file name extensions apply to Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.
Basic tasks in Excel - Microsoft Support
WEBGet started with basic tasks in Excel such as opening a workbook, entering and formatting data, calculating data, and trying some quick analysis features..
Import data from data sources (Power Query) - Microsoft Support
WEBPower Query for Excel Help. Import data from database using native database query. Use multiple tables to create a PivotTable. Import data from a database in Excel for Mac. Getting data. Need more help?