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
  • 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
  • Resources

Category: MS Excel

Blog Posts on MS Excel

Ajay Anand

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 … 10 11

Recent Posts

  • Python Program to Edit Excel Files
  • Python Program to Read Excel Files
  • VLOOKUP from Two or more Tables

Archives

  • March 2023
  • May 2022
  • April 2022
  • March 2022
  • November 2021
  • May 2021
  • April 2021
  • February 2021
  • November 2020
  • October 2020
  • September 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
  • 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
  • Resources

Top 25 MS Word Tips & Tricks

https://youtu.be/l25Evu4ohKg

Course on Scripting in AutoCAD

Excel Bible

Recent Posts

  • Python Program to Edit Excel Files
  • Python Program to Read Excel Files
  • VLOOKUP from Two or more Tables
  • TEXTSPLIT and 13 New Functions in Excel
  • How to find the Most Repeated Text or Number in Excel

Categories

  • Advanced Excel (3)
  • AutoCAD (3)
  • Conditional Formatting (2)
  • Data Validation (2)
  • Excel Charts (3)
  • Excel Errors (1)
  • Excel Formula (28)
  • Excel Functions (14)
  • Excel Macro (4)
  • Excel Shortcuts (2)
  • Excel Table (2)
  • Excel Tips and Tricks (41)
  • Excel Tutorial (3)
  • Google Maps (1)
  • GoogleSheets (1)
  • MS Excel (84)
  • MS Word (4)
  • Pivot Table (4)
  • Power Query (30)
  • PowerPoint (1)
  • Python (2)
  • Uncategorized (4)

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

Categories

  • Advanced Excel
  • AutoCAD
  • Conditional Formatting
  • Data Validation
  • Excel Charts
  • Excel Errors
  • Excel Formula
  • Excel Functions
  • Excel Macro
  • Excel Shortcuts
  • Excel Table
  • Excel Tips and Tricks
  • Excel Tutorial
  • Google Maps
  • GoogleSheets
  • MS Excel
  • MS Word
  • Pivot Table
  • Power Query
  • PowerPoint
  • Python
  • Uncategorized