As of my last knowledge update in January 2022, Microsoft Excel organizes its features into tabs. Each tab contains specific menus related to different functions. Here are the main tabs and their associated menus in Microsoft Excel:
1. File:
- New
- Open
- Save
- Save As
- Share
- Export
- Close
- Account
- Options
- Account
- Feedback
2. Home:
- Clipboard (Cut, Copy, Paste)
- Font (Bold, Italics, Underline, etc.)
- Alignment (Text alignment, Wrap Text, Merge & Center, etc.)
- Number (Number formatting, Currency, Percentage, etc.)
- Styles (Cell styles)
- Cells (Insert, Delete, Format)
3. Insert:
- Tables
- Illustrations (Pictures, Shapes, SmartArt)
- Charts
- Sparklines
- Filters
- Text (Header & Footer, Text Box, Object)
4. Page Layout:
- Themes
- Page Setup (Margins, Orientation, Size)
- Scale to Fit
- Sheet Options
- Arrange
Your add here
5. Formulas:
- Insert Function
- Defined Names
- Formula Auditing (Trace Precedents, Trace Dependents, Error Checking)
- Calculation (Calculation Options, Calculate Now, Calculate Sheet)
6. Data:
- Get & Transform Data (Power Query)
- Get Data (Import External Data)
- Sort & Filter
- Data Tools (Remove Duplicates, Data Validation, What-If Analysis)
- Forecast
7. Review:
- Proofing (Spelling, Research)
- Language
- Comments
- Changes
- Compare
- Workbook Views
8. View:
- Workbook Views (Normal, Page Layout, Page Break Preview)
- Show (Gridlines, Headings, Formula Bar, etc.)
- Zoom
- Window
9. Developer:
- Code (Macros, Visual Basic)
- Add-ins (Manage Excel Add-ins)
Please note that the organization and options within these menus might have changed in subsequent updates to Microsoft Excel after my last training cut-off in January 2022. Always refer to the latest version of the software for the most accurate information.
No comments:
Post a Comment