Excel Blog by Excel Champs
- Add and Delete a Worksheet in Excel
- Add and Remove Hyperlinks in Excel
- Add Watermark in Excel
- Apply Accounting Number Format in Excel
- Apply Background Color to a Cell or the Entire Sheet in Excel
- Delete Hidden Rows in Excel
- Deselect Cells in Excel
- Draw a Line in Excel
- Excel Fill Justify to Merge Text from Multiple Cells to One Cell
- Formula Bar in Excel
- Gridlines in Excel (Remove, Shortcut, Print, & Change Color)
- Add a Button in Excel
- Add a Column in Excel
- Add a Header and Footer in Excel
- Add Page Number in Excel
- Apply Comma Style in Excel
- Apply Strikethrough in Excel [Shortcut + Command]
- Convert Negative Number into Positive in Excel
- Group Worksheets in the Excel
- Highlight Blank Cells in Excel
- Insert a Timestamp in Excel [Formula + VBA + Shortcut]
- Insert Bullet Points in Excel
- Make Negative Numbers Red in Excel
- Merge – Unmerge Cells in Excel
- Rename Sheet in Excel
- Select Non-Contiguous Cells in Excel
- Show Ruler in Excel
- Spell Check in Excel
- Fill Handle in Excel
- Format Painter in Excel
- View Two Sheets Side by Side in Excel
- Increase and Decrease Indent in Excel
- Insert an Arrow in a Cell in Excel
- Quick Access Toolbar in Excel
- Remove Page Break in Excel
- Rotate Text in Excel (Text Orientation)
- Row Vs Column (Difference)
- How to Automatically Add Serial Numbers in Excel
- How to Insert Delta Symbol Δ in Excel in a Cell
- How to Insert/Type DEGREE Symbol in Excel
- Top 10 Benefits of Microsoft Excel – Why YOU Should Learn it in 2020
- Status Bar in Excel
- Make Paragraph in a Cell
- Absolute Reference
- Add Column
- Add New Sheet
- Insert Row(s)
- Apply-Remove Filter
- AutoSum
- Clear Contents
- Delete Row(s)
- Drag Down
- Find & Replace
- Merge-Unmerge Cells
- Open Format Cells Options
- Print Preview
- Save As
- Show Formulas
- Strikethrough
- Subscript
- Superscript
- Undo – Redo
- Wrap Text
- Zoom in - Zoom Out
- Unhide Columns
- Switch Tabs (Worksheets)
- Select Row
- Copy and Paste
- Cut and Paste
- Freeze Pane
- Format Painter
- Paste Values
- Edit Cell
- Check Mark
- Auto Fit
- Add Comments
- Add Indent
- Align Center
- Apply Border
- Delete Sheet
- Full Screen
- Group
- Hyperlink
- Transpose
- Add Month to a Date
- Add Years to Date
- Add-Subtract Week from a Date
- Calculate Age using Date of Birth
- Compare Two Dates
- Convert Date to Number
- Convert Text to Date
- Count Years Between Two Dates
- Create a Date Range
- Custom Date Formats
- DATEDIF Function in Excel
- Get Day Name from a Date in Excel
- Get Day Number of Year
- Get End of the Month Date in Excel
- Get First Day (Beginning) of the Month
- Get Month from a Date
- Get Quarter from a Date [Fiscal + Calendar]
- Get Total Days in Month in Excel
- Get Years of Service
- Highlight Dates Between Two Dates
- Months Between Two Dates
- Quickly Concatenate Two Dates
- Random Date Generator (Excel Formula)
- Add Hours into Time
- Add Minutes to Time
- Calculate Time Difference Between Two Times in Excel
- Change Time Format
- Military Time (Get and Subtract)
- Separate Date and Time in Excel
- Count Between Two Numbers (COUNTIFS)
- Count Blank (Empty) Cells using COUNTIF
- Count Cells Less than a Particular Value (COUNTIF)
- Count Cells Not Equal To (COUNTIF)
- Count Cells That Are Not Blank
- Count Cells with Text in Excel
- Count Greater Than 0 (COUNTIF)
- Count Specific Characters
- Count Total Number of Cells from a Range
- Count Unique Values in Excel [Formulas + VBA]
- Count Words in Excel
- OR Logic in COUNTIF/COUNIFS in Excel
- Sum an Entire Column or a Row
- Sum Greater Than Values using SUMIF
- Sum Not Equal Values (SUMIFS)
- Sum Only Visible Cells
- Sum Random Cells
- SUMIF / SUMIFS with an OR Logic in Excel
- SUMIF with Wildcard Characters in Excel
- SUMIFS Date Range (Sum Values Between Two Dates Array)
- Add Leading Zeros in Excel
- Capitalize First Letter
- Change Column to Row
- Change to Sentence Case in Excel [Formula]
- Concatenate (Combine) Cells with a Comma
- CONCATENATE a RANGE of Cells [Combine] in Excel
- Concatenate with a Line Break in Excel
- Create a Horizontal Filter
- Create a Star Rating Template in Excel
- Get File Name
- Get Sheet Name
- How to Remove First Character from a Cell in Excel
- Quickly Generate Random Letters in Excel
- Randomize a List (Random Sort)
- Remove Extra Spaces
- Separate Names in Excel – (First & Last Name)
- Check IF 0 (Zero) Then Blank
- Check IF a Value Exists in a Range
- Combine IF and AND Functions in Excel
- Combine IF and OR Functions in Excel
- Conditional Ranking [RANKIF]
- IF Cell is Blank (Empty) using IF + ISBLANK
- IF Negative Then Zero (0)
- SUMPRODUCT IF
- IFERROR with VLOOKUP in Excel to Replace #N/A
- Perform Two Way Lookup in Excel
- Reverse VLOOKUP in Excel with Index-Match (Right to Left)
- VLOOKUP MATCH Combination in Excel
- VLOOKUP with Multiple Criteria in Excel
- Wildcards with VLOOKUP in Excel
- Average TOP 5 Values in Excel
- Calculate Compound Interest in Excel
- Calculate Cube Root
- Calculate Percentage Variance
- Calculate Simple Interest
- Calculate SQUARE ROOT in Excel + Insert Symbol
- Calculate Weighted Average in Excel
- Coefficient of Variation (CV)
- Does Not Equal Operator
- MAX IF
- Quickly Calculate Ratio
- Round a Number to Nearest 1000, 100, and 10
- Round to Nearest .5, 5. 50 (Down-Up)
- Fixing #Value Error
- Excel 3D Reference
- Excel Wildcard Characters – What are they and How to use them.
- Hide Formula in Excel
- R1C1 Reference Style in Excel
- #DIV/0 Error
- COUNT Vs. COUNTA
- Compare Two Cells
- Ignore All the Errors
- Add a New Line in a Cell
Advanced Excel
- Consolidate Data From Multiple Worksheets
- Excel Camera Tool
- Excel Quick Analysis Tool
- Data Entry Form in Excel
- Data Validation with Date Range
- Dependent Drop-Down List in Excel
- Dynamic Drop Down List
- Corrupt Excel File
- Highlight Top-Bottom N Values
- Checkbox in Excel
- Multiply using Paste Special
- Sort Horizontally in Excel
- Formulas in Conditional Formatting in Excel
- How to use Goal Seek in Excel
- Auto Format
- Watch Window
- Recover Unsaved Excel Files When Excel Crashed
- Excel for Accountants
- Barcode In Excel (font)
- Add or Remove Grand Total
- Add Running Total
- Automatically Update a Pivot Table
- Calculated Field and Item (Formulas in a Pivot Table)
- Change Data Source for Pivot Table
- Count Unique Values in a Pivot Table
- Delete a Pivot Table
- Filter a Pivot Table
- Add Ranks in Pivot Table
- Apply Conditional Formatting to a Pivot Table
- Pivot Table using Multiple Files in Excel
- Group Dates
- Link/Connect a Single Slicer with Multiple Pivot Tables
- Move a Pivot Table
- Pivot Table Formatting
- Pivot Table Keyboard Shortcuts
- Pivot Table Timeline
- Refresh a Pivot Table
- Refresh All Pivot Tables at Once in Excel
- Sort a Pivot Table
- How to Create a Pivot Table from Multiple Worksheets
- How to Create PIVOT CHART in Excel
- Create WAFFLE CHART in Excel [A Step by Step Guide]
- Excel Copy Chart Format and Paste to Another Charts
- Excel Funnel Chart (Template + Steps to Create)
- Excel Gantt Chart Template
- How to Add a Horizontal Line in a Chart in Excel
- How to Add a Vertical Line in a Chart in Excel
- How to Create a Bullet Chart in Excel
- How to Create a Dynamic Chart Range in Excel
- How to Create a Dynamic Chart Title in Excel
- How to Create a HEAT MAP in Excel (Simple Steps) + Template
- How to Create a Milestone Chart in Excel
- How to Create a Population Pyramid Chart in Excel
- How to Create a Step Chart in Excel
- How to Create a Tornado Chart in Excel
- How to Create Interactive Charts in Excel
- How to Insert a People Graph in Excel
- Top 10 ADVANCED Excel Charts and Graphs (Free Templates Download)
- How to Add Secondary Axis in Excel Charts
- How to Create a HISTOGRAM in Excel – Step by Step
- How to Create a Pictograph in Excel using 5 Simple Steps
- How to Create a SPEEDOMETER Chart [Gauge] in Excel
- How to Create a Thermometer Chart in Excel
- Top 100 Useful Excel Macro [VBA] Codes Examples
- How to Create a User Defined Function [UDF] in Excel using VBA
- VBA Interview Questions
- How to Add a Comment in a VBA Code (Macro)
- How to Add a Line Break in a VBA Code (Single Line into Several Lines)
- How to Add a New Line (Carriage Return) in a String in VBA
- How to Run a Macro in Excel (Run a VBA Code)
- Personal Macro Workbook (personal.xlsb)
- Record a Macro in Excel
- VBA Exit Sub Statement
- VBA Immediate Window (Debug.Print)
- VBA Module | Insert, Remove, Restore, and BackUp
- VBA MSGBOX – A Complete Guide to Message Box Function + Examples
- VBA Objects
- VBA With Statement (With – End With)
- Excel Visual Basic Editor (Windows + MAC) – The Ultimate Guide
- How to Add Developer Tab on Excel Ribbon | Windows + Mac
- Count Rows using VBA in Excel
- Excel VBA Font (Color, Size, Type, and Bold)
- Excel VBA Hide and Unhide a Column or a Row
- Excel VBA Range – Working with Range and Cells in VBA
- How to Apply Borders on a Cell using VBA in Excel
- How to Find Last Row, Column, and Cell using VBA in Excel
- How to Insert a Row using VBA in Excel
- How to Merge Cells in Excel using a VBA Code
- How to Select a Range/Cell using VBA in Excel
- How to SELECT ALL the Cells in a Worksheet using a VBA Code
- How to use ActiveCell in VBA in Excel
- How to use Special Cells Method in VBA in Excel
- How to use UsedRange Property in VBA in Excel
- VBA AutoFit (Rows, Column, or the Entire Worksheet)
- VBA ClearContents (from a Cell, Range, or Entire Worksheet)
- VBA Copy Range to Another Sheet + Workbook
- VBA Enter Value in a Cell (Set, Get and Change)
- VBA Insert Column (Single and Multiple)
- VBA Named Range | (Static + from Selection + Dynamic)
- VBA Range Offset
- VBA Sort Range | (Descending, Multiple Columns, Sort Orientation
- VBA Wrap Text (Cell, Range, and Entire Worksheet)
- How to Highlight Duplicate Values in Excel using VBA Codes
- How to Extract Hyperlink Address (URL) in Excel Using VBA UDF
- How to CLEAR an Entire Sheet using VBA in Excel
- How to Copy and Move a Sheet in Excel using VBA
- How to COUNT Sheets using VBA in Excel
- How to DELETE a SHEET using VBA in Excel
- How to Hide & Unhide a Sheet using VBA in Excel
- How to PROTECT and UNPROTECT a Sheet using VBA in Excel
- How to RENAME a Sheet using VBA in Excel
- How to Write a VBA Code to Create a New Sheet in Excel (Macro)
- VBA Worksheet Object -Working with Excel Worksheet in VBA
- How to Activate a Sheet using VBA
- How to Copy an Excel File (Workbook) using VBA – Macro Code
- VBA Activate Workbook (Excel File)
- VBA Close Workbook (Excel File)
- VBA Combine Workbooks (Excel Files)
- VBA Create New Workbook (Excel File)
- VBA Delete Workbook (Excel File)
- VBA Open Workbook (Excel File)
- VBA Protect/Unprotect Workbook (Excel File)
- VBA Rename Workbook (Excel File)
- VBA Save Workbook (Excel File)
- VBA ThisWorkbook (Current Excel File)
- VBA Workbook – A Guide to Work with Workbooks in VBA
- Declare Global Variable (Public) in VBA
- How to use a Range or a Cell as a Variable in VBA
- How to use Option Explicit Statement in VBA
- Variable in a Message Box
- VBA Constants
- VBA Dim Statement
- VBA Variables (Declare, Data Types, and Scope)
- VBA Add New Value to the Array
- VBA Array
- VBA Array Length (Size)
- VBA Array with Strings
- VBA Clear Array (Erase)
- VBA Dynamic Array
- VBA Loop Through an Array
- VBA Multi-Dimensional Array
- VBA Range to an Array
- VBA Search for a Value in an Array
- VBA Sort Array
- How to Average Values in Excel using VBA
- How to Get Today’s Date and Current Time using VBA
- How to Sum Values in Excel using VBA
- How to use Match Function in VBA
- How to use MOD in VBA
- Random Number
- VBA Calculate (Cell, Range, Row, & Workbook)
- VBA Concatenate
- VBA Worksheet Function (Use Excel Functions in a Macro)
- How to Check IF a Sheet Exists using VBA in Excel
- VBA Check IF a Cell is Empty + Multiple Cells
- VBA Check IF a Workbook Exists in a Folder (Excel File)
- VBA Check IF a Workbook is Open (Excel File)
- VBA Exit IF
- VBA IF – IF Then Else Statement
- VBA IF And (Test Multiple Conditions)
- VBA IF Not
- VBA IF OR (Test Multiple Conditions)
- VBA Nested IF
- VBA SELECT CASE Statement (Test Multiple Conditions)
- VBA Automation Error (Error 440)
- VBA Error 400
- VBA ERROR Handling
- VBA Invalid Procedure Call Or Argument Error (Error 5)
- VBA Object Doesn’t Support this Property or Method Error (Error 438)
- VBA Object Required Error (Error 424)
- VBA Out of Memory Error (Error 7)
- VBA Overflow Error (Error 6)
- VBA Runtime Error (Error 1004)
- VBA Subscript Out of Range Runtime Error (Error 9)
- VBA Type Mismatch Error (Error 13)
- Excel VBA Do While Loop and (Do Loop While) – A Guide
- How to Loop Through All the Sheets using VBA in Excel
- Loop Through a Range using VBA (Columns, Row, and UsedRange)
- VBA FOR LOOP (For Next, For Each) – The Guide + Examples
- VBA GoTo Statement
- VBA Loops (Beginner to Advanced) – A Guide
- How to use Input Box in VBA
- VBA Create and Write to a Text File
- VBA ScreenUpdating | How to Turn it ON and OFF
- VBA Status Bar (Hide, Show, and Progress)
- VBA Wait and Sleep Commands to Pause and Delay
- A Step By Step Guide to Create a Pivot Table in Excel using VBA – MACRO CODE
- Top VBA Functions
- VBA ABS Function (Get Absolute Value)
- VBA ARRAY Function
- VBA ATN Function (Syntax + Example)
- VBA CBOOL Function (Syntax + Example)
- VBA CBYTE Function (Syntax + Example)
- VBA CCUR Function (Syntax + Example)
- VBA CDATE Function (Syntax + Example)
- VBA CDBL Function (Syntax + Example)
- VBA CDEC Function (Syntax + Example)
- VBA CHR Function (Syntax + Example)
- VBA CINT Function (Syntax + Example)
- VBA CLNG Function (Syntax + Example)
- VBA COS Function (Syntax + Example)
- VBA CSNG Function (Syntax + Example)
- VBA CSTR Function (Syntax + Example)
- VBA CVAR Function (Syntax + Example)
- VBA CVERR Function (Syntax + Example)
- VBA DATE Function (Syntax + Example)
- VBA DATEADD Function (Syntax + Example)
- VBA DATEPART Function (Syntax + Example)
- VBA DATESERIAL Function (Syntax + Example)
- VBA DATEVALUE Function (Syntax + Example)
- VBA DAY Function (Syntax + Example)
- VBA DDB Function (Syntax + Example)
- VBA EXP Function (Syntax + Example)
- VBA FileDateTime Function
- VBA FILTER Function (Syntax + Example)
- VBA FIX Function (Syntax + Example)
- VBA FORMAT Function (Syntax + Example)
- VBA FORMATCURRENCY Function (Syntax + Example)
- VBA FORMATDATETIME Function (Syntax + Example)
- VBA FORMATNUMBER Function (Syntax + Example)
- VBA FORMATPERCENT Function (Syntax + Example)
- VBA FV Function (Syntax + Example)
- VBA HEX Function (Syntax + Example)
- VBA HOUR Function (Syntax + Example)
- VBA IIF Function (Syntax + Example)
- VBA INSTR Function (Syntax + Example)
- VBA INSTRREV Function (Syntax + Example)
- VBA INT Function (Syntax + Example)
- VBA IPMT Function (Syntax + Example)
- VBA IRR Function (Syntax + Example)
- VBA ISARRAY Function (Syntax + Example)
- VBA ISDATE Function (Syntax + Example)
- VBA ISEMPTY Function (Syntax + Example)
- VBA ISERROR Function (Syntax + Example)
- VBA ISMISSING Function (Syntax + Example)
- VBA ISNULL Function (Syntax + Example)
- VBA ISNUMERIC Function (Syntax + Example)
- VBA ISOBJECT Function (Syntax + Example)
- VBA JOIN Function (Syntax + Example)
- VBA LBOUND Function (Syntax + Example)
- VBA LCASE Function (Syntax + Example)
- VBA LEFT Function (Syntax + Example)
- VBA LEN Function (Syntax + Example)
- VBA LOG Function (Syntax + Example)
- VBA LTRIM Function (Syntax + Example)
- VBA MID Function (Syntax + Example)
- VBA MINUTE Function (Syntax + Example)
- VBA MIRR Function (Syntax + Example)
- VBA MONTH Function (Syntax + Example)
- VBA MONTHNAME Function (Syntax + Example)
- VBA NOW Function (Syntax + Example)
- VBA NPER Function (Syntax + Example)
- VBA NPV Function (Syntax + Example)
- VBA OCT Function (Syntax + Example)
- VBA PMT Function (Syntax + Example)
- VBA PPMT Function (Syntax + Example)
- VBA PV Function (Syntax + Example)
- VBA RATE Function (Syntax + Example)
- VBA REPLACE Function (Syntax + Example)
- VBA RIGHT Function (Syntax + Example)
- VBA RND Function (Syntax + Example)
- VBA ROUND Function (Syntax + Example)
- VBA RTRIM Function (Syntax + Example)
- VBA SECOND Function (Syntax + Example)
- VBA SGN Function (Syntax + Example)
- VBA SIN Function (Syntax + Example)
- VBA SLN Function (Syntax + Example)
- VBA SPACE Function (Syntax + Example)
- VBA SPLIT Function (Syntax + Example)
- VBA SQR Function (Syntax + Example)
- VBA STR Function (Syntax + Example)
- VBA STRCOMP Function (Syntax + Example)
- VBA STRCONV Function (Syntax + Example)
- VBA STRING Function (Syntax + Example)
- VBA STRREVERSE Function (Syntax + Example)
- VBA SYD Function (Syntax + Example)
- VBA TAN Function (Syntax + Example)
- VBA TIME Function (Syntax + Example)
- VBA TIMER Function (Syntax + Example)
- VBA TIMESERIAL Function (Syntax + Example)
- VBA TIMEVALUE Function (Syntax + Example)
- VBA TRIM Function (Syntax + Example)
- VBA UBOUND Function (Syntax + Example)
- VBA UCASE Function (Syntax + Example)
- VBA VAL Function (Syntax + Example)
- VBA WEEKDAY Function (Syntax + Example)
- VBA WEEKDAYNAME Function (Syntax + Example)
- VBA YEAR Function (Syntax + Example)