Welcome to the sitemap of Excel Unlocked. Here, you will find all the articles on our website listed under their respective categories.
Posts by category
- Category: Charts
- How to Create a Pivot Table Timeline in Excel?
- How to Change the Default Layout of a Pivot Table in Excel
- Making Calculated Field in Pivot Table in Excel
- Text and Number Filter in Pivot Table in Excel
- Link Multiple Pivot Tables to One Slicer in Excel
- Slicers with Pivot Table – Multiple Slicers
- How to Sort Pivot Table Manually?
- Sort Data in Pivot Table – Fields, Rows, and Sub Totals
- Group Data in Pivot Table – Dates, Numbers, Text
- Making Pivot Table from Scratch – Blank Pivot Table
- Pivot Table in Excel – Making Pivot Tables
- Bell Curve in Excel – Usage, Making, Formatting
- Venn Diagram in Excel – Usage, Working, Formatting
- Trendlines in Excel – Types and Usage
- Custom Error Bars in Excel – Adding and Deleting
- Interactive Pictograph Chart in Excel – Usage, Making
- Error Bars in Excel – Types and Examples
- Stream Chart in Excel – Making, Usage, Formatting
- Pictograph Chart in Excel – Usage, Making, Formatting
- Waterfall Chart in Excel – Usage, Making, Formatting
- Population Pyramid in Excel – Usage, Making, Formatting
- Bullet Chart in Excel – Usage, Making, Formatting
- Tornado Chart using Conditional Formatting
- Tornado Chart in Excel – Usage, Making, Formatting
- Stacked Bar Chart in Excel – Usage, Insert, Format
- Bar Chart in Excel – Types, Insertion, Formatting
- Interactive Waffle Chart in Excel – Making, Formatting, Usage
- Waffle Chart in Excel – Making, Usage, Formatting
- Milestone Chart in Excel – Usage, Inserting, Formatting
- Step Chart in Excel – Step vs Line, Insert, Working
- Treemap Chart in Excel – Usage, Examples, Formatting
- Sunburst Chart in Excel – Usage, Insertion, Formatting
- Radar Chart in Excel – Components, Insertion, Formatting
- Histogram Chart in Excel – Insert, Format, Bins
- Gauge Chart in Excel – Creating in Excel
- Doughnut Chart in Excel – Single, Double, Format
- Thermometer Chart in Excel – Making, Usage, Formatting
- 3D Column Chart in Excel – Usage, Insertion, Format
- Gantt Chart in Excel – Usage, Insertion, Formatting
- Pareto Chart in Excel – Usage, Insertion, Formatting
- Wireframe 3D Surface Chart in Excel – Insert, Working, Format
- Contour Chart in Excel – Inserting, Usage, Format
- 3D Surface Chart in Excel – Insert, Working, Formatting Legends
- Volume High Low Close Stock Chart in Excel – Insert, Format, Reading
- Open High Low Close Stock Chart – Insert, Format, Up/Down bars
- High Low Close – Stock Chart in Excel
- Scatter Charts in Excel – Straight and Smooth Lines with Markers
- Bubble Chart in Excel – Insertion, Working, Bubble Format
- XY Scatter Chart in Excel – Usage, Types, Inserting Scatter Chart
- A Complete Guide on Sparklines in Excel
- Sparklines in Excel – Types, Usage, Insertion
- 100% Stacked Area Chart in Excel – Insertion, Reading, Formatting
- Change the Order of Data Series – Stacked Line, Stacked Area, Column Chart
- Stacked Area Chart Excel – Usage, Insertion, Area vs Line, Negative Values
- Area Chart in Excel – Types, Inserting, Line vs Area, Correcting Chart
- Pie of Pie Chart in Excel – Inserting, Customizing, Formatting
- Pie Chart in Excel – Inserting, Formatting, Filters, Data Labels
- 100% Stacked Column Chart in Excel – Inserting, Usage, Reading
- Stacked Column Chart in Excel – Usage, Examples, Format, Special Gridlines
- 100% Stacked Line Chart in Excel – Inserting, Analyzing
- Column Chart in Excel – Types, Insert, Format, Clickable Chart
- Format Chart Axis in Excel – Axis Options: Effects
- Make Your Own Chart Template in Excel
- Format Chart Axis in Excel – Axis Options
- Format Chart Axis in Excel Charts – Axis Options – Fill and Line
- Stacked Line Chart in Excel – Inserting, Reading, Formatting
- Line Chart in Excel – Inserting, Formatting, #REF! resolving
- All About Chart Elements of a Chart in Microsoft Excel
- Introduction to Charts in Microsoft Excel
- Category: Tips and Tricks
- How to Lock the Cells containing Formulas in Excel?
- Hide or Unhide Cell Content in Excel
- Make a Calendar using the SEQUENCE Function
- Column Headings from Numbers to Letters
- How to Delete Blank Rows in Excel Spreadsheet?
- Data Bars Excel – Min Max Value, Formula Based Bars
- Data Bars in Excel – Add and Customize
- Manage Conditional Formatting Rule – Edit, Delete, Reorder and Copy
- Multiple Conditional Formatting Rules
- What is Excel Conditional Formatting?
- Conditional Formatting using Color Scales
- How to Count Duration in Hours Between Two Dates?
- How to Convert Time into Decimal Number, Hours, Minutes or Seconds
- How to Round Off Time in Excel – Using MROUND Function
- What is Date and Time Format in Excel?
- 19 Everyday Use Excel VBA Codes
- 8 Errors in Formula in Excel and How to Resolve
- “Arrow Keys Not Working in Excel” – Solved
- Learn Excel Keyboard Shortcut in Infographic
- Multiple Ways to Reduce Excel File Size
- ExcelUnlocked – Mouse and Keyboard Combo Tricks
- ExcelUnlocked – Mouse Double Clicks Tricks in Excel
- How to Lookup on Picture in Excel
- Insert or Lock Image or Picture In Cell in Excel
- How to Insert Picture or Image in Excel Comment
- Printing Comments in Excel – Quick Guide
- How to Print All or Multiple Worksheets in Excel
- How to Send Email From Excel Automatically
- Change And Convert Number To Text in Excel
- Multiple Ways to Hide Zero Value in Excel
- Convert Decimal To Fraction in Excel
- Count Number of Characters in Cell or Range of Cells
- Multiple Ways to Insert Degree Symbol in Excel
- Insert Tick Mark or Cross Mark in Excel
- Find and Replace Cell Color in Excel
- Advanced Search Using Wildcard Characters in Excel
- How to Split Cell Diagonally in Excel
- Four Ways to Run A Macro in Excel
- Add Macro to Quick Access Toolbar and Ribbon
- Insert Line Break in Excel – Add More Line in Cell
- Start Automation – Record A Macro in Excel
- Convert Date To Quarter in Excel
- Remove Spaces Between Words and Numbers in Excel
- Watch Window in Excel – An Unrecognized Feature
- How to Make A Table In Excel – A Hidden Functionality
- How to Get Name from Email Address in Excel
- Quickly Select Columns with Blank Cells in Between
- Show Negative Numbers in Bracket and in Red Color
- How to Enter Text in Blank Cells in Excel
- Stack Data from One Column into Multiple Columns
- How to Add and Delete a Comment in Excel
- Extract Values in Multiple Lines in Cell in Excel
- Increase Font Size of Formula in Formula Bar in Excel
- How to Sum Values in Same Cell of Multiple Worksheets
- How to Find Unique Values from Dataset In Excel
- Three Ways to Find Formula Cells in Excel
- How to Sum Values Based on Criteria
- How to Highlight Row that Contains Blank Cells
- Add Same Cells in Multiple Worksheets at One Go
- How to Delete Multiple Worksheets at One Go in Excel
- How to Insert Date and Timestamp in Excel
- How to Change Tab Color in Excel
- How to Create a Dependent Drop-Down list in Excel
- How to Sort by Last Name in Excel
- How to Separate First and Last Name from Full Name
- How to Save All Charts in Excel into Separate Images
- How to Add Zero in Front of Number in Excel
- How to Remove the First Character from cells in Excel
- How to Highlight Every Alternate Row in Excel
- How to Remove Middle Name from Full Name in Excel
- How to Select Cells Containing Data Validation
- How to Create a Dynamic Drop Down List in Excel
- How to Remove Leading Spaces in Excel
- Category: VBA and Macro
- Hide / Unhide Gridlines in Excel – VBA
- Application.ActiveWindow Property in VBA
- Clear in VBA – Content, Comment, Outline
- How to Indent in Excel ? (VBA)
- Hide / Unhide Rows and Columns using VBA
- Font Properties in VBA – Color, Size, Style
- PasteSpecial VBA – Other Examples
- Wrap Text Using VBA – Examples
- Paste Special Method in VBA
- Selection Property VBA – Usage With Examples
- Copy Worksheet using VBA – Examples
- Cells in VBA – Usage With Examples
- Workbooks Collection in VBA – Workbook Object
- Optional Arguments in VBA – Usage with Examples
- Object Browser in VBA
- Active Cell VBA – Properties and Methods
- Personal Macro Workbook VBA- Create and Use
- Change Cell Alignment Using VBA
- Lock Cells using VBA
- How to Import, Export and Copy Module in VBA?
- Change the Background Color of Cells using VBA
- Employee Joining User Form – VBA Project Excel
- Insert Columns using VBA in Excel
- Insert Rows using VBA, Copy Formatting
- Do Until Loop in VBA – Usage with Examples
- Change Row Height, Column Width VBA (Autofit)
- UsedRange Property in VBA – Examples
- Apply Border to Cells using VBA in Excel
- How to Use Active Cell in VBA
- VBA Class Modules – Create Objects
- Do While Loop in VBA – Usage with Examples
- Array of User Defined Type in VBA
- User Defined Data Type – Type VBA
- Dynamic Arrays in VBA – ReDim and Preserve
- Multidimensional Arrays in VBA – Excel
- For Loop in VBA – Excel
- Arrays in VBA – Excel
- For Each Loop VBA – Excel
- Clear Cell Content and Formatting using VBA
- Empty Cells VBA – Check, Count, and Highlight
- Merge and Unmerge Cells using VBA in Excel
- Working with Worksheets in VBA Excel
- ThisWorkbook in VBA – Examples
- Sort Range using VBA – Table Header
- Worksheet Events in VBA Excel
- Read and Write Cell Value using VBA
- InputBox function VBA – Syntax and Examples
- Message Box in VBA – MsgBox Function
- Objects, Properties and Methods – VBA
- Search Item in Collection – VBA
- Collections in VBA – Create, Add, Remove Items
- Passing Arguments by Value – VBA
- Private and Public Procedures in VBA
- Passing Procedure Arguments by Reference – VBA
- Constants in VBA – Declaration, Types. Scope
- Strings in VBA – Fixed and Variable Length
- Variant Data Type in VBA Excel
- Data Types of Variables in VBA
- Variables in VBA – Declare, Initialize, Examples
- When to Use Static Variables in VBA?
- How to Automatically Run a Macro when Workbook is Opened?
- What is VBA Module? Types, Insert, Remove
- User Defined Functions in VBA – Define, Call, Example
- Complete Tutorial – Sub Procedure in VBA
- How to Copy and Paste Cells using VBA in Excel
- Select Cells and Ranges using VBA in Excel
- Where to Put VBA code?
- Edit Macro – Rename, Shortcut key, Copy
- Write a Macro using VBA Editor – Command Button
- Relative Referencing in Excel Macro
- Assign Macro to Image and CheckBox
- How to Delete Macro from Excel Workbook?
- Tutorial – Record and Run a Macro – Real Life Example
- Category: Functions
- How to Use R1C1 Reference Style in Excel?
- Dynamic Named Range using the INDEX function
- Dynamic Named Range – OFFSET and COUNTA
- SEC Function in Excel – Usage with Examples
- TAN Function in Excel – A Trigonometric Ratio
- COS Function in Excel – Usage with Examples
- SIN Function in Excel – Mathematical Function
- CHISQ.INV Function in Excel – Inverse Chi Square Distribution
- CHISQ.DIST.RT Function in Excel – Statistical Formula
- CHISQ.DIST Function in Excel – Chi-Square Distribution
- COVARIANCE.P Function in Excel – Population Covariance
- COVARIANCE.S Function in Excel – Sample Covariance
- BINOM.INV Function in Excel – Inverse Cumulative Distribution
- BINOM.DIST.RANGE Function in Excel
- BINOM.DIST function in Excel – Probability of N Successes
- BETA.DIST Function in Excel – A Statistical Function
- CORREL Function in Excel – Statistical Function
- FIXED Function in Excel – Usage and Examples
- ARABIC Function in Excel – Usage and Examples
- ROMAN Function in Excel – Usage and Examples
- TYPE Function in Excel – Get Data Type
- AREAS Function in Excel – Areas of Reference
- SUBSTITUTE Function in Excel – A Text Function
- Applications of FIND Function in Excel
- TRIMMEAN Function in Excel – Truncated Mean
- GEOMEAN Function in Excel – Geometric Mean
- HARMEAN Function in Excel – Get Harmonic Mean
- REPLACE Function in Excel – Replace Text String
- VLOOKUP Function with Drop Down List
- VLOOKUP Function Returning Multiple Values
- BASE Function in Excel – Change the Radix
- MODE.MULT Function in Excel – Multiple Modes
- MODE.SNGL Function in Excel – Single Mode
- PERCENTILE.INC Function in Excel – Inclusive Function
- PERCENTILE.EXC Function Excel – Usage and Example
- VAR.S Function in Excel – Variance of Sample
- VAR.P Function in Excel – A Statistical Function
- STDEV.S Function in Excel – Sample Standard Deviation
- AVEDEV Function in Excel – Definition and Examples
- CODE Function in Excel – Usage with Examples
- MINVERSE Function in Excel – Matrix Inverse
- N Function in Excel – Usage and Examples
- MMULT Function in Excel – Matrix Multiplication
- ERROR.TYPE Function in Excel – Error Codes,Examples
- LCM Function in Excel – Usage, Errors Resolving
- GCD Function in Excel – Usage with Examples
- Applications of SQRT Function in Excel
- SQRT Function in Excel – Usage with Examples
- MEDIAN Function in Excel – A Statistical Parameter
- FREQUENCY Function in Excel – Statistical Function
- CEILING.MATH Function in Excel – Usage with Examples
- ISEVEN Function in Excel – Usage with Examples
- ISODD Function in Excel – Conditional Formatting
- MODE Function in Excel – A Statistical Function
- HYPERLINK Function in Excel – Create Links
- RANK.AVG Function in Excel – Usage, Error Handeling
- RANK Function in Excel – Usage with Examples
- Named Range Excel – Updating, Data Validation
- Named Ranges in Excel – Define, Usage, and Types
- XOR Function in Excel – Usage with Examples
- T Function in Excel – Usage with Examples
- Applications – SUMPRODUCT Function in Excel
- SUMPRODUCT Function in Excel – Usage with Examples
- How to INDEX MATCH in Excel? – Lookup Formula
- Applications – FILTER Function in Excel
- FILTER Function in Excel – Dynamic Filtered Range
- Applications of UNIQUE Function in Excel
- UNIQUE Function in Excel – Usage with Examples
- SORT Function in Excel – Usage with Examples
- Dynamic Array Formulas in Excel – Usage, Example, #SPILL
- NORM.DIST Function in Excel – Get PDF and CDF
- Mixed Referencing in Excel – Usage, Types and Examples
- Absolute Referencing in Excel – Usage with Examples
- Relative Referencing in Excel – Types of References
- STDEV.P Function in Excel – Uses, and Examples
- ISPMT Function of Excel – Interest Amount Keeping the Principal Constant
- NPER Function in Excel – Calculating Number of Periods
- MIRR Function in Excel – Modified Internal Rate of Return
- XIRR Function in Excel – IRR for Irregular Cash flows
- IRR Function in Excel – Internal Rate of Return
- PMT PPMT IPMT Functions of Excel – Usage
- FV Function of Excel – Find Future Value of Investment
- AMORLINC Function of Excel – Finding the Depreciation of as Asset
- CHOOSE Function in Excel – Choosing Value according to Index
- AMORDEGRC Function of Excel – Linear Depreciation of an Asset
- ACCRINTM Function of Excel – Calculating Accrued Interest
- WEEKNUM Function of Excel – Finding Week Number
- TIME Function in Excel – Returning The Time Format
- ISREF Function in Excel – Checking for Cell Reference
- ISNUMBER Function of Excel – Checking If Cell Contains a Number
- ISNONTEXT Function of Excel – Check Non Text Cell in Excel
- ISBLANK Function of Excel – Check if Cell is Blank
- ISTEXT Function in Excel – Checking if Cell Contains Text
- ISNA Function in Excel – Checking for #N/A Errors
- ISERROR Function in Excel – Checking for Errors
- ISERR Function in Excel – Checking If The Cell Contains An Error
- ISLOGICAL Function in Excel – Checking for Boolean TRUE/FALSE
- TIMEVALUE Function in Excel – Returning Serial Number of Time
- EOMONTH Function in Excel – Getting Last Day of Month
- EDATE Function in Excel – Adding Months to a Specific Date
- MONTH Function in Excel – Finding Month From Date
- DAYS360 Function In Excel- Counting Number of Days
- DAYS Function In Excel – Number of Days Between Two Dates
- Excel DATEDIF Function – Find Difference Between Dates
- Excel AVERAGEIFS Function – Multiple Criteria Average
- SLN Function in Excel – Calculate SLM Depreciation
- Excel DDB Function – Compute Depreciation Using Formula
- Excel DB Function – Formula to Calculate Depreciation
- Excel COUNTIFS Function – Counting Cells with Specified Conditions
- MINIFS Function in Excel – Finding Minimum Value Based on Conditions
- COUNTIF Function In Excel – Counting Cells With Condition
- AVERAGEIF Function In Excel – Finding Average With Condition
- AVERAGEA Function in Excel – Finding Average Value From All
- Excel TRANSPOSE Function – Rotate Columns to Rows
- Excel RATE Function – Calculating Interest Rate for Specified Period
- AVERAGE Function in Excel – Finding Mean or Average Value in Excel
- MAXIFS Function in Excel- Finding Maximum Value Based On Criteria(s)
- MAXA Function in Excel – Finding Maximum Value from Range
- MINA Function – Finding Minimum Value
- SMALL Function in Excel – Finding nth Smallest Number
- LARGE Function in Excel – Finding nth Largest Number
- MAX Function in Excel – Finding Largest Number
- MIN Function in Excel – Returning Minimum Value
- Excel COUNTBLANK Function – Counting Number of Empty Cells
- Excel COUNTA Function – Count Cells Containing Values
- Excel COUNT Function – Count Cell Containing Numbers
- Excel PV Function – Calculate Present Value PV in Excel
- Excel XNPV Function – NPV With Irregular Cash Flows
- NPV Function – How to Calculate NPV in Excel
- ADDRESS Function in Excel – Get Excel Cell Address
- CHAR Function in Excel – Return Character By Code
- CELL Function in Excel – Get Information About Cell
- Excel TEXT Function – Convert Number In Text Format
- Excel VALUE Function – Convert Text To Value
- TRIM Function in Excel – Remove Extra Spaces
- Excel REPT Function – Repeat Text Multiple Times in Cell
- Excel UPPER Function – Convert Letters In Upper Case
- Excel PROPER Function – Convert Into Sentence Case
- Excel LOWER Function – Convert Letters In Lower Case
- LEN Function in Excel – Find Number of Characters
- MID Function in Excel – Extract Text From Middle
- Excel RIGHT Function – Extract Text from Right Side
- Excel LEFT Function – Extract Text from Left Side
- SEARCH Function in Excel – Search String in Excel
- Excel FIND Function – Get Position of Text in String
- EXACT Function in Excel – Match Two Values
- Excel TEXTJOIN Function – Join Text with Delimiter
- Excel CONCAT Function – Join Values in Cell Range
- Excel CONCATENATE Function – Combine Columns in Cells
- SUMIFS Function in Excel – Multiple Condition Sum
- SUMIF Function in Excel – Total Based On Condition
- SUM Function in Excel – Add All Numbers in Cells
- Excel SUBTOTAL Function – Get Total of Filtered Cells
- SEQUENCE Function in Excel – Generate Number Series
- ROUND Function in Excel – Normal Rounding in Excel
- ROUNDUP Function in Excel – Rounding Upwards
- Excel ROUNDDOWN Function – Rounding Down
- RANDARRAY Function in Excel
- RANDBETWEEN Function in Excel
- RAND Function in Excel – Generate Random Numbers
- QUOTIENT Function in Excel – Find Quotient by Division
- PRODUCT Function in Excel – Multiply Numbers
- POWER Function in Excel – Find Raised to Power
- ODD and EVEN Function in Excel
- MROUND Function in Excel – Rounding in Excel
- MOD Function in Excel – Find Remainder after Division
- ABS Function in Excel – Convert Negative to Positive
- INT Function in Excel – Get Integer from Number
- XLOOKUP Function in Excel – Advanced Lookup
- HLOOKUP Function in Excel – Match Value in Row
- VLOOKUP Function in Excel – Lookup Formula
- MATCH Function in Excel – Find Cell Position in Array
- INDEX Function in Excel – Get Intersection Point
- INDIRECT Function in Excel – Get Values from Reference
- OFFSET Function in Excel – Jump Rows and Columns
- ROWS Function in Excel – Get Number of Rows
- ROW Function in Excel – Get Cell Row Number
- COLUMNS Function in Excel – Get Number of Columns
- COLUMN Function in Excel – Get Cell Column Number
- IFERROR Function in Excel – Remove Excel Error
- NOT Function in Excel – Gives Wrong Logical Value
- IFS Function in Excel – Check Multiple Conditions
- IF Function in Excel – Check Logical Condition
- TRUE and FALSE Function in Excel
- OR Function in Excel – Check One Condition
- AND Function in Excel – Check Multiple Conditions
- TODAY Function in Excel – Get Today’s Date in Excel Cell
- NOW Function in Excel – Get Current Date And Time
- WORKDAY.INTL Function in Excel
- WORKDAY Function in Excel – Find Date After Date
- NETWORKDAYS.INTL Function in Excel
- WEEKDAY Function in Excel – Get Week Day Number
- NETWORKDAYS Function – Count Days in Excel
- SECOND Function in Excel – Extract Second from Time
- MINUTE Function in Excel – Extract Minute from Time
- HOUR Function in Excel – Extract Hour from Time
- DAY Function in Excel – Get Day Value From Date
- DATEVALUE function in Excel – Get Date Serial Number
- DATE Function in Excel – Get Date Using Excel Formula
- LAMBDA Function – Create Custom Formulas in Excel
- How to Add and Use Index Column in Power Query
- Custom Columns in Table in Excel Power Query
- How to Add Conditional Column in Excel Power Query
- Group and Summarize Data in Excel Power Query
- Transpose Data in Excel Using Excel Power Query
- Using Fill Down or Fill Up in Excel Power Query
- How to Replace Values in Excel Power Query
- All About Microsoft Forms in Office 365
- How to Filter and Sort Data in Excel Power Query
- Split Cells or Columns in Excel Using Power Query
- Merge Data in Excel from Different Tables – Power Query
- Merging or Combining Multiple Excel Files without VBA
- How to Convert CSV File To Excel Using Power Query
- How to Convert JSON to Excel Using Power Query
- How to Unpivot Data in Excel Using Power Query
- Convert Table from PDF to Excel Using Power Query
- Combine or Merge All Text Files in Folder in Excel
- How to Import Data from Text File or Notepad to Excel
- What are Data Types in Excel Power Query
- 4 Ways to Refresh Power Query in Excel
- Import Data from Web To Excel Using Power Query
- How To Get All Filenames in Folder in Excel
- Install Power Query in Excel 2010 [Step by Step Guide]
- Overview of Power Query in Excel
- Free ExcelUnlocked Pivot Table Excel Feature Course
- Apply Conditional Formatting to Excel Pivot Table
- Replace Blank Cells with Zeros in Excel Pivot Table
- How to Refresh Pivot Table in Excel
- How to Delete the Pivot Table in Excel
- Pivot Table – Group Numbers and Create Range
- Pivot Table – Group Dates by Years, Months, etc.
- Excel Pivot Table Grand Total and Subtotal
- How to Create and Use Pivot Table Feature in Excel
- Quick Overview On Pivot Table in Excel
- Excel Header and Footer – Add, Change, Customize
- Advanced Filter in Excel – A Rarely Used Filter Feature
- Filter in Excel – Add, Apply, Copy, Clear, and Many More
- Track Changes in Excel – Enable, Use, and Disable
- Group and Ungroup Worksheets in Excel
- An Object in Excel – Create, Insert, Edit and Link
- All About Find and Replace in Excel
- All About Excel Date Format
- All About Custom Excel Number Format
- Format Cell Content – Excel ‘Number’ Format
- Formatting – Format Cells Feature in Excel
- Amazing Feature in Excel – Custom List in Excel
- Exploring AutoCorrect Feature in Excel
- Sparkline in Excel – Insert, Edit and Delete
- Multiple Ways to Merge Columns in Excel
- Insert Symbols and Special Characters in Excel
- Insert and Remove Hyperlink in Excel
- Merge Your Data – Using Consolidate Feature in Excel
- All About Paste Special Feature in Excel
- Unlocking SUBTOTAL Feature in Excel
- Group and Ungroup Rows in Excel
- VLOOKUP and HLOOKUP in Excel
- How to Hide Formula in Locked Cells in Excel
- How to Lock and Protect the Cells in Excel
- What-If Analysis – Data Table in Excel
- What-If Analysis – Scenario Manager in Excel
- What-If Analysis – Goal Seek in Excel
- Data Validation in Excel – Control Data Input
- Using Flash Fill Functionality in Excel
- Excel Gridlines
- Using the Text To Column Functionality of Excel
- Bonus Trick on Excel Comment Feature
- All About “Comments” in Excel
- Using Camera Tool in Excel – An Amazing Tool
- Using Format Painter Feature in Excel
- AutoFit Column Width and Row Height in Excel
- Using =IF() Function For Partial Match in Excel
- All About Circular Reference in Excel
- 2 Ways to Use Transpose Function in Excel
- Sort Rows in Excel – Sort from Left to Right
- How to Sort a Table or Data in Excel
- How to Create a Drop-Down List in Excel
- How to Wrap Text in Excel Cell
- How to Move Row or Column in Excel
- Using =VLOOKUP() Function for Partial Match in Excel
- How to use Excel Fill Handle Tool
- How to Hide or Unhide Row or Column in Excel