Latest Blog Posts

How to Undo a Save in Excel (4 Quick Methods)

If you are finding ways how to undo a save in Excel, this is the right place for you. Sometimes, we save work and then need to undo that in the ...

How to Save Excel as PDF Fit to Page (5 Easy Ways)

The sample dataset contains information on 21 employees in the range of cells B4:H25. Saving this dataset as a PDF will break the table over two ...

The Scroll Bar is Not Working in Excel – 5 Solutions

The following dataset represents best-sellers and their prices. Solution 1 - Unfreeze Panes If the Freeze Panes feature is enabled, no ...

How to Insert Scroll Bar in Excel (2 Suitable Methods)

Here is an overview of how to insert a scroll bar in the Excel worksheet using the Developer tab. 2 Ways to Insert Scroll Bar in Excel ...

How to See Where Excel Autosave Files Are Stored (5 Easy Ways)

We will use a workbook that contains some information about the projects of a company. Using the workbook, we will try to see where Excel AutoSave ...

How to Send Email Automatically When Condition Met in Excel

Method 1 - Use VBA Macro to Send Email Automatically Based on a Cell Value We have the following dataset of some customer details of a super shop. ...

How to Save Excel as PDF (6 Useful Ways)

Just converting an Excel to a PDF isn’t something troublesome, but making it a neat, presentable & printable PDF document is a bit tricky. I'll ...

How to Resize a Slicer in Excel (With Quick Steps)

The Slicer provides buttons to filter Excel tables or pivot tables. The visual properties of the slicer such as the size, style, and position of the ...

Horizontal Scroll Not Working in Excel (6 Possible Solutions)

Solution 1 - Change the Page View Go to the View tab and switch between Normal and Page Break View. Switch back to Normal. Remember ...

How to Save Macros in Excel Permanently (2 Suitable Ways)

Excel We sometimes need to perform the same thing or use the same formula in our Excel workbooks. In this regard, we can automate our work by ...

How to Calculate Standard Error of Proportion in Excel (with Easy Steps)

The article will show you the proper steps to calculate the Standard Error of Proportion by using Microsoft Excel. It’s an important parameter in the ...

How to Calculate Sharpe Ratio in Excel (2 Common Cases)

In this article, we will explain how to calculate the Sharpe Ratio in Excel. Basics of the Sharpe Ratio The Sharpe Ratio, also known as the ...

The Bottom Scroll Bar is Missing in Excel – 7 Solutions

Solution 1 - Modify Excel Options Steps The bottom scroll bar is missing: Click File. Click Options. In Excel Options, ...

Connect Slicer to Multiple Pivot Tables from Different Data Source

We'll link a slicer between two data sets in the sections below. The first data set is for the sales data in the Sales worksheet, and the second data ...

Excel VBA: Check If a Sheet Exists (2 Simple Methods)

One of the many things that we can accomplish using VBA in Excel is that we can check if a particular sheet exists in a workbook or not. In this ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo