Excel Junction
  • Home
  • Testimonials
  • WhatsApp
  • Telegram
  • Forum
  • Support
15
Feb

Create a simple MACRO by using VBA

Categories: Macros & VBA, Microsoft Excel, Videos
Tags: Excel, Macro, VBA
Comments: No
CREATE A SIMPLE MACRO BY USING VBA

18
Dec

DYNAMIC Named Range in Excel

Categories: Microsoft Excel, Videos, Working with Data
Comments: No
DYNAMIC Named Range in Excel

We know what a Named Range is and how it works. Now we’ll see what is a DYNAMIC named range in Excel. A dynamic named range expands automatically when you Read more

19
Sep

Copy & Paste VISIBLE CELLS ONLY

Categories: Microsoft Excel, Shortcuts, Videos, Working with Data
Tags: Alt+;, Copy, Paste, Visible Cells Only
Comments: No
COPY & PASTE VISIBLE CELLS ONLY

If some cells, rows, or columns on your worksheet are not displayed, you have the option of copying all cells or only the visible cells. By default, Excel copies hidden Read more

05
Sep

Cell References in Excel – RELATIVE & ABSOLUTE

Categories: Basic Formulae, Microsoft Excel, Videos
Tags: Absolute Cell Reference, Cell Reference, Dollar Sign, F4, Formulae Construction, Relative Cell Reference
Comments: No
CELL REFERENCES IN EXCEL - RELATIVE & ABSOLUTE

A key building block in formula writing is the ability to use absolute and relative cell references. Though the term Absolute cell reference sounds too complex and goes over the Read more

23
Aug

20+ keyboard SHORTCUTS to speed up Excel FORMATTING

Categories: Formatting, Microsoft Excel, Shortcuts, Videos
Tags: Efficiency, Excel, Formatting, Shortcuts, Speed
Comments: 1
KEYBOARD SHORTCUTS TO SPEED UP EXCEL FORMATTING

Newer Entries

200+ MS Excel Shortcuts on One Page

FREE DOWNLOAD

Send download link to:

Latest Tweets

An error has occured.

Join us on Facebook
Recent Posts
  • Print from Excel to PDF in 1 Click
  • TABLE OF CONTENTS in Excel – 1 Click to Create & Update
  • CHANGE TEXT CASE in Excel in 1 Click
  • Add Uniqueness to Your Documents with NEW FONTS
  • Get the LIST of all FILES in a FOLDER – EJ File Manager
Recent Comments
  • Excel Junction on How to COMBINE Multiple Excel WORKBOOKS into One Workbook
  • Julie Walles on How to COMBINE Multiple Excel WORKBOOKS into One Workbook
  • Excel Junction on How to COMBINE Multiple Excel WORKBOOKS into One Workbook
  • Excel Junction on How to COMBINE Multiple Excel WORKBOOKS into One Workbook
  • Abena Berko Sakyi on How to COMBINE Multiple Excel WORKBOOKS into One Workbook
Archives
  • May 2021
  • April 2021
  • April 2020
  • February 2019
  • December 2018
  • November 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • January 2018
  • November 2017
  • April 2017
  • March 2017
  • February 2017
  • December 2016
  • September 2016
  • August 2016
Categories
  • Advanced Excel
  • Basic Formulae
  • Formatting
  • Macros & VBA
  • Microsoft Excel
  • Microsoft Outlook
  • Microsoft PowerPoint
  • Microsoft Word
  • Shortcuts
  • Tips & Tricks
  • Videos
  • Working with Data
 
Connect @ Facebook
Connect @ Twitter

An error has occured.