Excel Junction
  • Home
  • Testimonials
  • WhatsApp
  • Telegram
  • Forum
  • Support
04
Apr

Change Text Case in Excel in 1 Click

Categories: Uncategorized
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

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

Older Entries
Join 2 mn+ members worldwide
Latest Tweets
  • Change Text Case in Excel in 1 Click https://t.co/NqZGfzy1mg https://t.co/ucy5cFFxs4
    10 days ago
  • Getting Started with Mirosoft Excel - EXCEL BASICS https://t.co/kA3UXcBh7c
    285 days ago
  • Add Uniqueness to Your Documents with NEW FONTS https://t.co/dOvglmLhBl
    374 days ago
  • How to get a LIST of all FILES in a FOLDER? https://t.co/v7rwKD6h3E
    782 days ago
  • How to DELETE BLANK ROWS in between 2 rows? https://t.co/2LDuK0KBiR https://t.co/DdAVKsHIwk
    859 days ago

Follow @excel_jx

Join us on Facebook
Recent Posts
  • 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
  • How to MERGE FIRST WORKSHEET of Multiple Excel Workbooks
  • PRINT a TITLE ROW at the Top of Every Page
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
  • 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
  • Uncategorized
  • Videos
  • Working with Data
 
Connect @ Facebook
Connect @ Twitter
  • Change Text Case in Excel in 1 Click https://t.co/NqZGfzy1mg https://t.co/ucy5cFFxs4
    10 days ago
  • Getting Started with Mirosoft Excel - EXCEL BASICS https://t.co/kA3UXcBh7c
    285 days ago

Follow @excel_jx