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

Print from Excel to PDF in 1 Click

Categories: Advanced Excel, Macros & VBA, Microsoft Excel, Videos
Comments: No
Print from Excel to PDF

We bring to you the fastest way to print PDF’s from Excel, just with one click through the tool that we have developed (FREE Download below). Whatever be the requirement, Read more

17
Apr

TABLE OF CONTENTS in Excel – 1 Click to Create & Update

Categories: Macros & VBA, Microsoft Excel, Videos, Working with Data
Comments: No

Excel doesn’t have an option for creating a Table of Contents in workbooks. When you’re dealing with large Excel workbooks you’ll find it really efficient to navigate through a table Read more

04
Apr

CHANGE TEXT CASE in Excel in 1 Click

Categories: Formatting, Macros & VBA, Microsoft Excel, Videos
Comments: No
Change Text Case in Excel in 1 Click

Excel doesn’t have an option for changing text case in worksheets, unlike Word and Powerpoint. In this video, we have presented the fastest way to change the text case, with Read more

02
Apr

Add Uniqueness to Your Documents with NEW FONTS

Categories: Microsoft Excel, Microsoft Outlook, Microsoft PowerPoint, Microsoft Word
Comments: No
Add Uniqueness to Your Documents with NEW FONTS

Although Microsoft Office packages come with a lot of fonts, at times you may still need to add new styles to add uniqueness to your documents (or presentation) with new Read more

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

Older 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.