Excel Junction
  • Home
  • Testimonials
  • WhatsApp
  • Forum
  • Support
  •  
17
Feb

Get the LIST of all FILES in a FOLDER – EJ File Manager

Categories: Advanced Excel, Macros & VBA, Videos
Comments: No
GET THE LIST OF FILES IN A FOLDER AND SUBFOLDERS

Most people wonder why there is no direct way to get the list of all files in a folder or directory in Excel. Internet search results in lengthy and complicated Read more

02
Dec

How to MERGE FIRST WORKSHEET of Multiple Excel Workbooks

Categories: Advanced Excel, Macros & VBA, Microsoft Excel
Comments: No
MERGE FIRST WORKSHEET of Multiple Excel Workbooks

23
Nov

PRINT a TITLE ROW at the Top of Every Page

Categories: Formatting, Microsoft Excel
Comments: No
PRINT a TITLE ROW at the Top of Every Page

In a worksheet that needs more than one page to print, you might want a title row (or rows) to print at the top of every page of your data Read more

07
Nov

200+ MS Excel Shortcuts on One Page

Categories: Microsoft Excel, Shortcuts
Comments: No
200 MS Excel Shorcuts on 1 Page

Most professionals use Microsoft Excel every day. It may be to do calculations, create charts, analyse data, or prepare reports for various stakeholders. Excel is used for all sorts of Read more

03
Nov

MACRO SECURITY – Password Protect a VBA Project

Categories: Advanced Excel, Macros & VBA, Microsoft Excel
Comments: No
Macro Security

Creating a Macro in Microsoft Excel helps you automate tasks in a spreadsheet. Once these codes are present in the worksheet they can be changed intentionally or accidently by anyone Read more

14
Jun

7 Excel Tips to Impress your BOSS

Categories: Advanced Excel, Basic Formulae, Formatting, Macros & VBA, Microsoft Excel, Shortcuts, Videos, Working with Data
Comments: 1
7 Excel Tips to Impress Your Boss

7 Excel Tips to Impress your BOSS Excel is a standout amongst the most prevalent software programs for organizations. It’s used extensively by representatives and managers in a variety of Read more

26
May

LOCK and PROTECT Cells Containing FORMULAS in an Excel sheet

Categories: Macros & VBA, Microsoft Excel, Videos
Comments: 1
LOCK and PROTECT Cells Containing FORMULAS in an Excel sheet

When you work on a spreadsheet, many a times you need to use some formulas. An Excel formula is easy to create and edit and I am sure all of Read more

15
May

How to visualize your project schedule using a GANTT STYLE CHART

Categories: Advanced Excel, Microsoft Excel, Working with Data
Comments: No
VISUALIZE PROJECT SCHEDULE USING GANTT STYLE CHART

You can easily visualize your project schedule using a Gantt Style Chart which can be a great project management tool to help you keep your projects on track. Excel doesn’t come with Read more

29
Apr

10 Cool Microsoft Word Tips and Tricks

Categories: Microsoft Word, Tips & Tricks
Comments: No
10 Cool Microsoft Word Tips and Tricks

Microsoft Office is one of the most popular office suites out there. It’s used by businesses both large and small. Despite many programs, Microsoft Word remains one of the most Read more

15
Apr

How to COMBINE Multiple Excel WORKBOOKS into One Workbook

Categories: Advanced Excel, Macros & VBA, Videos
Comments: 9
MERGE FIRST WORKSHEET of Multiple Excel Workbooks

Combine multiple excel workbooks into one workbook We might need to combine multiple excel workbooks into one workbook in order to analyse or present the information better. Though this can Read more

Older Entries
Join 1.5 mn readers worldwide
Latest Tweets
  • How to get a LIST of all FILES in a FOLDER? https://t.co/v7rwKD6h3E
    about 16 hours ago
  • How to DELETE BLANK ROWS in between 2 rows? https://t.co/2LDuK0KBiR https://t.co/DdAVKsHIwk
    78 days ago
  • How can TEXT and FORMULA be added in the same cell? https://t.co/3E9NPDFH5N https://t.co/IFfIJi84xW
    78 days ago
  • MERGE FIRST WORKSHEET of Multiple Excel Workbooks | https://t.co/wnCYD9XAZW: https://t.co/vxOTTuLLaX via @YouTube
    83 days ago
  • How to change DATE FORMAT in Excel? https://t.co/p6K6ZBJ4v2 https://t.co/j3lAN6Xwdk
    85 days ago

Follow @excel_jx

Join us on Facebook
Recent Posts
  • Get the LIST of all FILES in a FOLDER – EJ File Manager
  • How to MERGE FIRST WORKSHEET of Multiple Excel Workbooks
  • PRINT a TITLE ROW at the Top of Every Page
  • 200+ MS Excel Shortcuts on One Page
  • MACRO SECURITY – Password Protect a VBA Project
Recent Comments
  • jean ngom on How to COMBINE Multiple Excel WORKBOOKS into One Workbook
  • Wayne Taylor on How to COMBINE Multiple Excel WORKBOOKS into One Workbook
  • Eunice Young 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
Archives
  • 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 Word
  • Shortcuts
  • Tips & Tricks
  • Videos
  • Working with Data
 
Connect @ Facebook
Connect @ Twitter
  • How to get a LIST of all FILES in a FOLDER? https://t.co/v7rwKD6h3E
    about 16 hours ago
  • How to DELETE BLANK ROWS in between 2 rows? https://t.co/2LDuK0KBiR https://t.co/DdAVKsHIwk
    78 days ago

Follow @excel_jx