Microsoft Excel | 📘 Study Guides

🧩 37 Practice Tests & Quizzes 📘 49 Study Guides

---

📄 Microsoft Excel: What-If-Analysis - Scenario Manager, Creating and Comparing Multiple Scenarios

📄 Microsoft Excel: What-If-Analysis - Goal Seek, Finding Input to Achieve Desired Result

📄 Microsoft Excel: What-If-Analysis - Data Tables, One-Variable and Two-Variable Sensitivity Analysis

📄 Microsoft Excel: Templates - Using and Creating Templates, Calendars, Invoices, Budgets

📄 Microsoft Excel: Tables - Sorting Data, Ascending, Descending, Custom Sort by Multiple Columns

📄 Microsoft Excel: Tables - Filtering Data, AutoFilter, Filter by Color, Text, Number, Date

📄 Microsoft Excel: Tables - Excel Tables, Creating, Formatting, Structured References

📄 Microsoft Excel: Tables - Advanced Filter, Criteria Range, Extracting Unique Records

📄 Microsoft Excel: Printing - Page Layout, Margins, Orientation, Size, Print Area, Print Titles

📄 Microsoft Excel: Printing - Headers and Footers, Page Numbers, File Name, Date, Image

📄 Microsoft Excel: Power-Query - Power Query Basics, Importing, Transforming, Loading Data

📄 Microsoft Excel: Power-Query - Merging and Appending Queries, Combining Data from Multiple Sources

📄 Microsoft Excel: Power-Pivot - Relationships Between Tables, Creating Star Schemas

📄 Microsoft Excel: Power-Pivot - Power Pivot, Data Models, DAX Formulas Basics

📄 Microsoft Excel: PivotTables - PivotTable Layout, Report Filter, Slicers, Timelines, Calculated Fields

📄 Microsoft Excel: PivotTables - PivotTable Basics, Row Labels, Column Labels, Values, Summarising Data

📄 Microsoft Excel: PivotTables - PivotCharts, Creating Interactive Charts from PivotTables

📄 Microsoft Excel: Macros-VBA - Security, Macro Settings, Digital Signatures

📄 Microsoft Excel: Macros-VBA - Recording Macros, Automating Repetitive Tasks

📄 Microsoft Excel: Macros-VBA - Editing Macros, Visual Basic for Applications, VBA Editor Basics

📄 Microsoft Excel: Formulas - Text Functions, CONCATENATE, LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER

📄 Microsoft Excel: Formulas - Relative vs Absolute References, A1, $A$1, A$1/$A1, Mixed References

📄 Microsoft Excel: Formulas - Math and Statistical Functions, ROUND, ROUNDUP, ROUNDDOWN, SUMIF, COUNTIF, AVERAGEIF

📄 Microsoft Excel: Formulas - Lookup Functions, VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH

📄 Microsoft Excel: Formulas - Logical Functions, IF, AND, OR, NOT, IFERROR

📄 Microsoft Excel: Formulas - Formula Basics, Operators, Cell References, A1, B2

📄 Microsoft Excel: Formulas - Date and Time Functions, TODAY, NOW, DATE, DATEDIF, NETWORKDAYS

📄 Microsoft Excel: Formulas - Common Functions, SUM, AVERAGE, COUNT, COUNTA, MAX, MIN

📄 Microsoft Excel: Formatting - Number Formatting, Currency, Percentage, Decimal Places, Date Formats

📄 Microsoft Excel: Formatting - Conditional Formatting, Highlight Cell Rules, Top/Bottom, Color Scales

📄 Microsoft Excel: Formatting - Basic Formatting, Font Size, Bold, Italic, Borders, Fill Color

📄 Microsoft Excel: Data-Tools - Text to Columns, Splitting Data by Delimiters or Fixed Width

📄 Microsoft Excel: Data-Tools - Remove Duplicates, Finding and Deleting Duplicate Rows

📄 Microsoft Excel: Data-Tools - Flash Fill, Automatically Extracting or Combining Data

📄 Microsoft Excel: Data-Tools - Data Validation, Dropdown Lists, Whole Numbers, Dates, Custom Formulas

📄 Microsoft Excel: Data-Entry - Selecting Cells, Rows, Columns, Click, Shift, Ctrl, Name Box

📄 Microsoft Excel: Data-Entry - Entering and Editing Data, Text, Numbers, Dates, Autofill Handle

📄 Microsoft Excel: Collaboration - Sharing Workbooks, Coauthoring, Comments, Track Changes

📄 Microsoft Excel: Collaboration - Protecting Worksheets and Workbooks, Passwords, Cell Locking

📄 Microsoft Excel: Charts - Formatting Charts, Titles, Legends, Data Labels, Axis Colors

📄 Microsoft Excel: Charts - Creating Charts, Column, Bar, Line, Pie, Area, Scatter

📄 Microsoft Excel: Charts - Advanced Chart Types, Combo, Waterfall, Funnel, Treemap, Sunburst

📄 Microsoft Excel: Basics - Workbooks and Worksheets, Creating, Saving, Opening, Navigating

📄 Microsoft Excel: Basics - Excel Interface, Ribbon, Quick Access Toolbar, Formula Bar, Status Bar

📄 Top 200+ Excel Shortcuts (By Category)

📄 All The Useful Microsoft Excel Interview Questions & Answers - 2

📄 All The Useful Microsoft Excel Interview Questions and Answers

📄 Introduction to Microsoft Excel

📄 Some Useful Excel Formulas Interview Questions & Answers