Overview of the Excel User Interface
The Application Window or User Interface is on the outside, while the Workbook Window is on the inside.
HOT TOPICS: | |
---|---|
Shortcuts | Formulas |
FAQ | Excel Hacks |
Downloads | Troubleshooting |
Testimonials | More Courses.. |
The Application Window or User Interface is on the outside, while the Workbook Window is on the inside.
We will learn how to open a Excel file through different methods and in different scenario.
Microsoft Excel Fundamental concepts Introduction-Microsoft Excel is the industry’s most popular spreadsheet tool, with millions of users worldwide. Excel is excellent for data manipulation, analysis, and visualization. It allows you to sort, filter, format, and...
Beginners: | |
---|---|
Introduction | Basic Excel |
Excel interface | Data entry |
cells & Rows | More... |
Intermediate: | |
---|---|
Worksheets & Workbooks | Array |
Ranges & References | Index-Match |
Built-in Functions | More... |
Advanced: | |
---|---|
Macros | VBA |
Pivot tables | Data Mining |
Forecasting & prediction | More... |
Data Analytics: | |
---|---|
Power Query | Charts & graphs |
Data validation | Conditional formatting |
Data Visualization | More... |
Formulas: | |
---|---|
V/H/X-Lookup | Index/Match |
Operators | Date & time |
IF/IFS/IFERROR | More... |
More