Excel TutorialContents Introduction to Excel Excel Interface and Navigation Excel Entering and Editing Data Excel Formatting Cells Excel Working with Rows and Columns Excel Worksheets and Workbooks Excel Keyboard Shortcuts Excel AutoFill and Flash Fill Excel Print and Page Setup Formulas and Functions Excel Basic Formulas Excel Basic Functions Excel Cell References Excel Named Ranges Excel IF Function Excel Logical Functions Excel Text Functions Excel Date and Time Functions Excel SUMIF, COUNTIF, and AVERAGEIF Excel Array Formulas Excel Math Functions Excel Statistical Functions Excel Error Handling in Formulas Excel Dynamic Arrays Excel Paste Special Data Lookup and Reference Excel VLOOKUP and HLOOKUP Excel INDEX and MATCH Excel XLOOKUP Excel INDIRECT and OFFSET Data Management Excel Sorting and Filtering Data Excel Conditional Formatting Excel Data Validation Excel Tables Excel Remove Duplicates and Data Cleanup Excel Data Import and Export Excel Protecting Workbooks and Sheets Excel Conditional Formatting Advanced Data Analysis Excel Pivot Tables Excel Pivot Charts Excel What-If Analysis Excel Goal Seek and Solver Excel Power Pivot Charts and Advanced Features Excel Charts and Graphs Excel Dashboard Creation Excel Sparklines Excel Power Query Excel Macros and VBA Introduction