Tag: Excel
How to Convert a PDF to Excel Using Get Data
The Portable Document Format, known best by its acronym and file type “PDF”, was developed by Adobe Systems in 1993 and has remained the standard for consumer printing, publishing and electronic sharing ever since. It is no wonder, then, that every now and then the need to convert information stored in a PDF into an Excel worksheet comes up. Powerful tools are destined to collaborate.
Create a Drop-Down List in Excel
Your event planning company is preparing for a large company meeting. Managers from each department have been tasked with gathering and reporting meal orders, chosen from six meal options, into a shared event spreadsheet. This is the form you sent and the list of meal options offered:
Excel’s Newest Features That You’ll Want to Know About!
If you use Excel through an Office 365 subscription, you know that new features appear regularly throughout the year. Because of this ‘trickle’ you might easily miss something new and useful, especially if your updates take place automatically in the background.
4 Paste Special Tips and Tricks You’ll Wish You’d Known Sooner
There’s a moment in everyone’s experience with Excel when you are both fairly comfortable using the tool and at the same time recognize just how much more there is to learn! This is often at the point where you want to take on a new task and realize that tools you need aren’t already in your toolbox.
Top Excel Interview Questions to Prepare For
Microsoft Excel is the most popular spreadsheet tool in use today, so it is likely that you will answer at least some questions about this important program during interviews. This is true whether you are looking for work as a senior manager or an intern.
How to Freeze a Row in Excel
Why is this mentioned in a post about Freezing Rows? Imagine trying to read a sheet with the headers 1000 rows above the data you are looking at.
5 Excel Data Entry Tips and Tricks You’ll Wish You’d Learned Earlier
When you start learning Excel, you begin by using the simplest methods for entering data and creating calculations. It is a credit to the software that so many tasks are able to be performed by the most inexperienced of users right from the beginning of their training.
How to Lock Cells in Excel to Protect Your Work from Changes
We’ve all done it. Mis-clicked. Mis-typed. Hit enter when we meant to hit tab. And while it’s frustrating to make mistakes in a spreadsheet of our own data, when managing important company assets those mistakes can have expensive consequences.
How to Password Protect an Excel File
Information in today’s corporate environment is as important as raw materials are to a manufacturer or labor is to the service industry. Organizations collect data from consumers, vendors, employees and even competitors every day.