Overview

Here are some important Excel topics that are essential for proficiency, whether you're using Excel for basic tasks, data analysis, or advanced functions:Practice test 1:59 questions 1 hour 50% correct required to pass* Cell Referencing (Relative, Absolute, Mixed)* Basic Formulas and Functions (SUM, AVERAGE, MIN, MAX, COUNT, etc.)* Data Entry and Editing* Formatting Cells (Number, Text, Date, Currency, etc.)* Conditional Formatting* Sorting and Filtering Data* Text Functions (LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN)* Date and Time Functions (TODAY, NOW, DATE, DATEDIF, NETWORKDAYS)* Logical Functions (IF, AND, OR, NOT)* Lookup and Reference Functions (VLOOKUP, HLOOKUP, INDEX, MATCH)* Mathematical Functions (ROUND, SUMIF, SUMIFS, COUNTIF, COUNTIFS)* Data ValidationPractice test 2:50 questions 1 hour 50% correct required to passPivot Tables and Pivot ChartsData Tables (One-variable and Two-variable data tables)What-If Analysis (Goal Seek, Scenario Manager)Advanced FilterSlicers and TimelinesPower Query (Get & Transform Data)Array Formulas (Dynamic Array Formulas, SEQUENCE, FILTER, UNIQUE)Advanced Lookup Functions (XLOOKUP, XMATCH)Statistical Functions (AVERAGEIFS, MEDIAN, MODE, STDEV.P, STDEV.S)Financial Functions (NPV, IRR, PMT, FV)Text to Columns and Flash FillPractice test 3:50 questions 1 hour 50% correct required to passCreating and Customizing Charts (Bar, Line, Pie, Scatter, etc.)SparklinesCreating DashboardsConditional Formatting for VisualizationsCombo Charts (Mixed Chart Types)Recording MacrosRunning and Editing MacrosBasic VBA Programming (Creating Functions, Loops, Conditional Statements)Automating Tasks with VBAPractice test 4:46 questions 1 hour 50% correct required to passData Import and Export (CSV, Text Files, Databases)Excel Tables (Structured References)Protecting and Sharing WorkbooksTrack Changes and CommentsCollaboration Features in Excel (Excel Online, Co-Authoring)Power Pivot (Data Models, Measures, Relationships)Power BI IntegrationAdvanced Power Query TechniquesUsing DAX in Excel

Skills

Reviews