Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Basic tasks in Excel - Microsoft Support
Learn how to use Excel for simple calculations and tracking information with cells, formulas, tables, charts, and more. Follow the steps to create a new workbook, enter and format data, apply number formats, and use Quick Analysis features.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016
Excel help & learning
Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.
Analyze Data in Excel - Microsoft Support
Analyze Data in Excel empowers you to understand your data through high-level visual summaries, trends, and patterns. Simply click a cell in a data range, and then click the Analyze Data button on the Home tab. Analyze Data in Excel will analyze your data, and return interesting visuals about it in a task pane.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web
Basic tasks in Excel for the web - Microsoft Support
With Excel for the web you use your web browser to create, view, and edit workbooks you store on OneDrive or Dropbox. If your organization or college has a Microsoft 365 plan or SharePoint site, start using Excel for the web by creating or storing workbooks in libraries on your site.
Applies To: Excel for the web
Using IF with AND, OR, and NOT functions in Excel
Description. =A2>B2. If A2 is greater than B2, format the cell, otherwise do nothing. =AND (A3>B2,A3<C2) If A3 is greater than B2 AND A3 is less than C2, format the cell, otherwise do nothing. =OR (A4>B2,A4<B2+60) If A4 is greater than B2 OR A4 is less than B2 plus 60 (days), then format the cell, otherwise do nothing.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel Web App, Excel for Windows Phone 10