Skip to content

XL n CAD

Excel isn’t just a tool – it's a way of Life!

  • Excel
    • Excel Functions
    • Excel Formulas
    • Excel Table
    • Macros
    • Formula Errors
    • Power Query
    • Downloads
  • Blog
    • Excel
    • Power Query
  • Shortcuts
    • 200+ Excel Shortcuts
    • Shift Key Shortcuts
    • Functions Key Shortcuts
    • Ctrl Key Shortcuts
    • Videos
  • About
  • AutoCAD
    • Macros (VBA for AutoCAD)
    • Scripting in AutoCAD
    • AutoCAD Command Alias
    • Complete List of AutoCAD Commands
    • Tips & Tricks
  • Excel Malayalam
  • Power Query
    • Power Query Editor
    • Blog Posts on Power Query
    • Videos
  • Power BI (Reports)
    • Actors Filmography (Malayalam)
    • Mohanlal Filmography
    • XL n CAD Malayalam – YouTube Channel Stats
    • Ajay Anand – YouTube Channel Stats
    • Actors Filmography (Tamil)
  • Resources

Category: MS Excel

Blog Posts on MS Excel

Ajay AnandLeave a Comment on How to create an Organizational Chart in Excel

How to create an Organizational Chart in Excel

How to create an Organizational Chart in Excel

Organizational Chart in Excel

Read More
Ajay AnandLeave a Comment on How to Shade Alternate Rows in Excel

How to Shade Alternate Rows in Excel

How to Shade Alternate Rows in Excel

Shade Alternate Rows in Excel

Read More
Ajay AnandLeave a Comment on Split data in a Cell to Multiple Rows using Power Query

Split data in a Cell to Multiple Rows using Power Query

Split data in a Cell to Multiple Rows using Power Query

Text to Multiple Rows using Power Query in Excel

Read More
Ajay AnandLeave a Comment on Extract Number and Text using Power Query in Excel

Extract Number and Text using Power Query in Excel

Extract Number and Text using Power Query in Excel

Extract Number and Text from Alphanumeric Data using Power Query in Excel

Read More
Ajay AnandLeave a Comment on How to UnPivot Data in Excel (Normalize Data)

How to UnPivot Data in Excel (Normalize Data)

How to UnPivot Data in Excel (Normalize Data)

Normalized Data using Power Query in Excel

Read More
Ajay AnandLeave a Comment on Import data from Google Maps to Excel

Import data from Google Maps to Excel

Import data from Google Maps to Excel

Places marked in Google Maps can be exported as KML files and these files can be viewed or edited in Excel or any other text editor. Let me explain the process of adding 6 Municipal Corporations of Kerala to a personalized Map in Google and exporting that data into Excel Login to google.com.mymaps Click on Create a New…

Read More
Ajay AnandLeave a Comment on Combine WorkSheets using Power Query in Excel

Combine WorkSheets using Power Query in Excel

Combine WorkSheets using Power Query in Excel

Merge worksheets using Power Query in Excel

Read More
Ajay AnandLeave a Comment on Matrix Digital Rain in Excel

Matrix Digital Rain in Excel

Matrix Digital Rain in Excel

I hope you will be familiar with this visual effect from the classic SCI-FI movie Matrix. This effect is known in different names like Matrix code rain, Matrix Digital rain, etc. What you see here is an animation created in an Excel Sheet using Conditional formatting, RANDBETWEEN function, and a simple macro. The idea was…

Read More
Ajay AnandLeave a Comment on Four different types of Actual vs Target Charts in Excel

Four different types of Actual vs Target Charts in Excel

In this article, we will see how to create different types of Actual vs Target Charts in Excel Type 1 (Stacked Columns) To create an Actual vs Target chart from the data given below Select the data Go to Insert Tab > Click on the Icon for insert Column or Bar chart Select Stacked Column…

Read More

Posts navigation

Previous 1 … 3 4

Recent Posts

  • Different Methods to select Visible Cells only in Excel
  • Copy and Paste into Visible cells in Excel
  • Different methods to Reverse a List in Excel

Archives

  • November 2020
  • October 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • February 2020
  • January 2020
  • December 2019
  • July 2019
  • June 2019
  • April 2019

Fly to

  • Excel
    • Excel Functions
    • Excel Formulas
    • Excel Table
    • Macros
    • Formula Errors
    • Power Query
    • Downloads
  • Blog
    • Excel
    • Power Query
  • Shortcuts
    • 200+ Excel Shortcuts
    • Shift Key Shortcuts
    • Functions Key Shortcuts
    • Ctrl Key Shortcuts
    • Videos
  • About
  • AutoCAD
    • Macros (VBA for AutoCAD)
    • Scripting in AutoCAD
    • AutoCAD Command Alias
    • Complete List of AutoCAD Commands
    • Tips & Tricks
  • Excel Malayalam
  • Power Query
    • Power Query Editor
    • Blog Posts on Power Query
    • Videos
  • Power BI (Reports)
    • Actors Filmography (Malayalam)
    • Mohanlal Filmography
    • XL n CAD Malayalam – YouTube Channel Stats
    • Ajay Anand – YouTube Channel Stats
    • Actors Filmography (Tamil)
  • Resources

25 Advanced Excel Shortcuts

https://youtu.be/l25Evu4ohKg

Excel Bible

Course on Scripting in AutoCAD

Excel Essentials for the Real World (Complete Excel Course)

Course on Programming in AutoCAD

Microsoft Excel A-Z – Tips to go from Excel Beginner to Pro

Join XL n CAD’s Email list to receive latest updates on Excel

Subscribe to receive Alerts every time when I publish an Article

Select List(s)*

Loading

Recent Posts

  • Different Methods to select Visible Cells only in Excel
  • Copy and Paste into Visible cells in Excel
  • Different methods to Reverse a List in Excel
  • Lesser-known Excel shortcuts
  • Connect Google Sheets to Excel

Categories

  • AutoCAD (3)
  • Conditional Formatting (1)
  • Excel Charts (2)
  • Excel Errors (1)
  • Excel Functions (1)
  • Excel Shortcuts (1)
  • Excel Table (1)
  • Excel Tips and Tricks (10)
  • Google Maps (1)
  • MS Excel (37)
  • MS Word (1)
  • Power Query (19)

© 2021 XL n CAD | WordPress Theme: Attesa by AttesaWP.com

Categories

  • AutoCAD
  • Conditional Formatting
  • Excel Charts
  • Excel Errors
  • Excel Functions
  • Excel Shortcuts
  • Excel Table
  • Excel Tips and Tricks
  • Google Maps
  • MS Excel
  • MS Word
  • Power Query