Skip to content

15 Top Tips And Shortcuts For Excel 2013

Key Takeaway:

  • Customize your Quick Access Toolbar: Organize frequently used commands in the Quick Access Toolbar for quick and easy access, saving time and increasing efficiency in Excel 2013.
  • Use keyboard shortcuts: Learn essential keyboard shortcuts for Excel 2013 and save valuable time by avoiding repetitive tasks and navigating the program more efficiently.
  • Utilize data validation: Create drop-down lists and restrict data entries to specific criteria in Excel 2013 with the data validation feature, making data entry quicker and more accurate.
  • Take advantage of chart and graph options: Create visual representations of your data with charts and graphs. Understand how to use macros, custom number formats, and financial, logical, statistical, and database functions to help in data analysis and financial planning.
  • Efficient printing options: Optimize document management and save printer ink and paper by printing only selected cells and multiple worksheets.

Have you ever needed a trick to make Excel 2013 easier to use? Whether you’re a beginner or an experienced user, this article has you covered. With these 15 top tips and shortcuts, you’ll be an Excel whizz in no time!

Quick Access Toolbar

Are you an Excel user who’s always searching the ribbon menu for commands? The Quick Access Toolbar can help you work more efficiently! In this section, I’ll show you how to customize it with your favorite commands. That way, you don’t have to waste time searching for them. Plus, I’ll give you tips on adding useful commands to the Quick Access Toolbar for Excel 2013. Ready? Let’s go!

Quick Access Toolbar-15 Top Tips and Shortcuts for Excel 2013,

Image credits: by James Jones

Customize your Quick Access Toolbar with frequently used commands

Customizing your Quick Access Toolbar in Excel 2013 makes accessing commands faster. It’s found above the Ribbon, next to the blue question mark icon. It comes with a few default commands such as Save, Undo and Redo. They’ll stay in the toolbar even when you close and reopen the program.

To customize it, click the down arrow at the end of the toolbar and select “More Commands”. Or, right-click on a command button in the Ribbon or Navigation Panel and choose “Add to Quick Access Toolbar”. You can move a command up or down with the Up/Down arrows.

You can also create groups of related commands. Click “More Commands” and then “Customize Quick Access Toolbar”. Add new groups under which relevant commands can be accessed quickly.

If some buttons are no longer needed, right-click them from your toolbar and choose “Remove from Quick Access Toolbar”.

Adding useful commands to your Quick Access Toolbar makes your experience with Excel 2013 easier and more efficient!

Add useful commands to your Quick Access Toolbar for better efficiency

Five points to add useful commands to your Quick Access Toolbar:

  • Right-click any button or command. Then, choose ‘Add to Quick Access Toolbar’.
  • Select any tab in the ribbon. Right-click a command and select ‘Add to Quick Access Toolbar’.
  • In the ‘More Commands’ dialog, pick one of those listed. Choose ‘Add’ in between an existing command on your QAT.
  • Delete items one by one. Press ‘Remove’ and then ‘OK’.
  • To restore defaults, click ‘Reset’ in the customization dialog box. This will clear your QAT.

Adding useful commands to your Quick Access Toolbar can save time and improve performance. For example, if you’re a chart expert, you can customize your toolbar with functions like Insert Chart, Switch Row/Column, and Edit Data.

Also, if you use conditional formatting a lot, you can add quick access buttons for Highlight Cells Rules and Top/Bottom Rules.

I had a workbook that required me to switch between sheet tabs a lot. Adding “Previous” and “Next” sheet navigation buttons to my Quick Access Toolbar saved me lots of clicks and improved my productivity.

Finally, it’s important to learn keyboard shortcuts. They are one of the fastest ways to navigate in Excel 2013.

Keyboard Shortcuts

Mastering Excel 2013’s keyboard shortcuts can save you loads of time! In this article, I’m sharing my tips and shortcuts. So, let’s get started and save time with ’em! Sub-sections cover all you need to know to become a shortcut master. You’ll find a breakdown of essential keyboard shortcuts and a guide to using them to streamline your workflow. Let’s get going!

Keyboard Shortcuts-15 Top Tips and Shortcuts for Excel 2013,

Image credits: by Adam Jones

Master essential keyboard shortcuts for Excel 2013

Ctrl+C? Copy it! Ctrl+V? Paste it! Ctrl+Z? Undo it! Ctrl+F? Find it! Ctrl+B? Make it bold! Ctrl+U? Underline it!

Mastering keyboard shortcuts is the key to productivity. Don’t bother with the mouse – just press Ctrl+C to copy a cell or range.

But there’s more! You can use Ctrl+Shift+[End] to select cells between active and last used. Or, Ctrl+’ to copy a formula.

Get familiar with all available keyboard shortcuts! Many online resources offer detailed guides.

Did you know? Keyboards have been around since the 1980s. Some people have even created their own custom combos!

Now: Save time with Excel 2013 keyboard shortcuts!

Save valuable time with keyboard shortcuts in Excel 2013


Press “Ctrl+C” to copy a cell quickly. To paste, use “Ctrl+V”. Select a starting value and drag the fill handle to quickly fill a series of numbers or dates. To add a line break within a cell, press “Alt+Enter”. Move between sheets in a workbook with “Ctrl+Page Up” and “Ctrl+Page Down”. Select an entire column or row with “Ctrl+Spacebar” or “Shift+Spacebar” respectively. Format cells quickly with “Ctrl+Shift+$”, “Ctrl+Shift+%”, or other respective shortcuts.

These keyboard shortcuts are faster than using menus and toolbars, eliminating extra steps and leading to improved efficiency. Before these shortcuts, people used typewriters to type documents. But typing errors were common without spell-checker applications. Plus, people couldn’t easily create some symbols.

Data Validation will help ensure data accuracy in Excel spreadsheets.

Data Validation

As an Excel user, I’m always seeking ways to work better. So in this article, I’ll share my top tips for Excel 2013. Data validation is a spot where Excel is especially helpful. We’ll check out two topics: making drop-down lists for easier data entry and using Excel’s data validation feature to restrict data entry to certain criteria. By the end, you’ll understand how data validation can make your workflow smoother and your spreadsheets more accurate.

Data Validation-15 Top Tips and Shortcuts for Excel 2013,

Image credits: by Harry Arnold

Create drop-down lists for easier data entry

Create drop-down lists for faster, accurate data entry! Here’s how:

  1. Select the cells you want to add the drop-down list to.
  2. Click ‘Data Validation’ under the Data tab.
  3. In the Settings tab, choose ‘List’ under ‘Allow’, then type your list items separated by commas, or click ‘Source’ and select the cells with list values.
  4. Remember to avoid blank spaces between the items!
  5. Customize error messages with the ‘Error Alert’ tab.

Start using the drop-down list feature today and experience quick and precise data entry! Plus, Excel’s data validation function restricts entries based on user-defined criteria.

Restrict data entry to specific criteria using Excel’s data validation feature

To restrict data entry to specific criteria using Excel’s data validation feature, follow this 5-step guide:

  1. Select the cell or range for applying data validation.
  2. Go to the ‘Data’ tab on the ribbon and click ‘Data Validation’.
  3. Choose the type of validation rule, such as whole number or decimal.
  4. Input the criteria for the rule, like a min or max value.
  5. Customize any error messages or alerts that appear when someone inputs invalid data.

With data validation, you can make sure your spreadsheets have accurate and consistent info. For example, if collecting survey responses from 1-10, you can stop someone from entering “11” or “42”. Or, if tracking employee performance reviews and want to prevent values above 5, implement a max value restriction.

Data validation allows date and time restrictions too. For instance, you could require only dates after today’s in a cell.

Pro Tip: use the ‘Apply Rule To’ option to quickly extend validation rules across multiple cells.

Now try conditional formatting: another powerful tool for improving data accuracy and visualizing trends.

Conditional Formatting

Conditional formatting is one of my favs in Excel 2013! It helps me quickly highlight data in a worksheet and make it pop. In this section, I’ll show two of my fave sub-sections. Firstly, how to use the built-in formatting options to highlight important data. Next, advanced features for formatting data. These tips and shortcuts will make your worksheet look more pro and make life easier!

Conditional Formatting-15 Top Tips and Shortcuts for Excel 2013,

Image credits: by Yuval Washington

Highlight important data in a worksheet quickly

Go wild with conditional formatting rules! You can highlight cells that contain specific or duplicate values. Differentiate between high, medium, and low values with color scales. Represent data through icons or bars. Use formulas to determine which cells to highlight, based on conditions. Set up rules for highlighting data based on dates or text strings. Customize the formatting options for each rule.

Combine various rules together for more complex formatting options. For example, create a rule to highlight cells greater than a value or within a specific range.

By using these techniques, you’ll save time and make data clearer. Instead of searching through rows and columns for the highest or lowest value, the colored cells will be easy to spot!

I once used conditional formatting to track personal expenses in Excel. I assigned colors to categories like rent, groceries, and entertainment, so I could track where my money was going each month.

Now you know how to use conditional formatting rules to format data effectively in Excel 2013!

Use conditional formatting rules to format data in Excel 2013


Select the cells you want to format. Click on the Home tab, then Conditional Formatting drop-down menu. Choose a rule type, such as highlighting cells greater than a certain value or applying a color scale.

Conditional formatting makes it easier to analyze and interpret data. Create custom rules based on criteria, like a unique icon set or data bar. Excel 2013 brought new enhancements, such as more options for data bars and color scales.

It first appeared in 1997 with Excel 97, for simple Boolean checks. Microsoft has improved it, based on user feedback and demand.

To analyze large sets of data, use Pivot Tables.

Pivot Tables

Let’s explore the world of Pivot Tables in Excel 2013! They make analyzing data a snap. But there are so many features that it can get confusing. In this segment, I’m going to give you top tips and shortcuts. So, you can create accurate reports and analyze data easily.

We’ll have two parts. First, creating pivot tables to analyze data. After that, efficient ways to use the PivotTable Field List in Excel 2013. Fasten your seatbelts and let’s go!

Pivot Tables-15 Top Tips and Shortcuts for Excel 2013,

Image credits: by Yuval Arnold

Create pivot tables to analyze data

Make sure your data is organised with clear headers and consistent formatting. This will save time when creating your pivot table and ensure accurate analysis.

When picking a layout, you can choose between ‘Tabular‘ or ‘Compact‘. Group dates into months or years for easier trends and pattern recognition.

Filter data easily with filters to focus on specified subsets. Use slicers instead of filters for even faster selection. You can drill down into details directly from the pivot table with a double-click.

Copy an existing pivot table and modify it to save time when creating multiple ones. Finally, apply conditional formatting to highlight important info at a glance.

Don’t miss out on these tips for creating and analysing data with pivot tables. Enhance your analysis capabilities with the PivotTable Field List.

Efficiently use the PivotTable Field List for data analysis in Excel 2013

To use the PivotTable Field List for data analysis in Excel 2013, start by creating a new PivotTable. Select the Insert tab and click on the PivotTable button. In the Create PivotTable dialog box, choose the range of data and decide whether to place it in a new worksheet or an existing one.

Once the PivotTable is created, click inside it to activate the Analyze and Design tabs. To add fields to the PivotTable, drag them from the field list (on the right side of the worksheet) to one of four areas: Filters, Columns, Rows, or Values.

Using this feature helps make complex data sets easier to understand and present insights quickly. Drag “Country” into the Row area and “Sales Amount” into the Value area to compare sales figures between different countries. To filter data, drag fields into the Filter area and check off which ones you want to include.

I’ve found that this feature significantly increases efficiency when processing large sets of raw data. It is incredibly helpful when presenting findings at meetings or reports.

Charts and Graphs

Data lovers, I’m sure you know the value of transforming your data into visual forms. Enter Excel 2013! It makes creating charts and graphs so simple. We’ll talk about line graphs, pie charts, and more. Plus, learn how easy it is to switch between chart types with Excel 2013. So, let’s get going and turn those data tables into eye-catching visuals!

Here are some tips and tricks for charts and graphs in Excel 2013:

Charts and Graphs-15 Top Tips and Shortcuts for Excel 2013,

Image credits: by Joel Duncun

Create visual representations of your data with charts and graphs


Choose the right chart for your data. There are multiple types, like line, column, pie, bar and scatter plot.

Label the x-axis and y-axis clearly.

Highlight important values with colors.

Minimize graphic noise to make interpretation easier.

Focus on data points and their relation to understand the story.

Try multiple combinations of chart type and design to find the right one.

Easily change chart types to suit your needs in Excel 2013

Select the chart you want to modify. Then, click the Chart Elements button above it. A drop-down menu appears with options such as Line, Bar, Column, Pie, and Scatter.

Select one and watch Excel automatically update your chart. Further customize by adjusting colors, font sizes, labels, and more.

Other ways to fine-tune charts include adding additional data series or categories simply by clicking the plus sign. This allows you to experiment with different visualization techniques to best communicate your data story. Pie charts are best for showing proportions or categorical breakdowns, while bar graphs compare values across different categories.

Earlier versions of Excel required manual changes, but today’s version has streamlined features that save time and effort when presenting quantitative information. Macros can help automate repetitive tasks in Excel 2013.


Macros are super useful in Excel 2013! A survey revealed that 52% of biz pros use them. In this part of our Excel tips series, we’ll explore macros and how they can make your work more efficient. We’ll cover: recording macros to automate tasks and assigning macros to a button for easy access. Let’s see how much time you can save with this awesome Excel feature!

Macros-15 Top Tips and Shortcuts for Excel 2013,

Image credits: by James Arnold

Record macros to automate repetitive tasks

Record macros to automate tasks in Excel! Click the ‘Record Macro’ button on the Developer tab of the Ribbon. Assign a shortcut key to run your macro with just a few keystrokes.

By recording macros, you can save time on repetitive tasks. Format tables or charts with one macro. Keep your code simple – focus on one specific task per macro.

Assigning macros to buttons makes them easier to access within Excel 2013.

Assign macros to a button for easier access in Excel 2013

  1. Click the “Developer” tab on the ribbon.
  2. In the “Controls” section, select a button from the “Insert” dropdown menu.
  3. Draw the button on the worksheet.
  4. In the “Assign Macro” dialog box, pick the macro from the list.
  5. Click “OK” to close the dialog box.

Once you assign a macro to a button, click it to run the macro. This is useful as it saves time and effort instead of navigating menus and submenus. Plus, it’s helpful if you share your workbook with others who may not be familiar with Excel.

Did you know? “Macro” comes from Greek, meaning “large” or “long. They are designed to automate repetitive tasks.”

In the next section, we’ll explore custom number formats, another powerful Excel 2013 feature.

Custom Number Formats

Are you ready to level-up your Excel skills? Check out custom number formats! This technique lets you customize numerical data display, making it easy to read and interpret.

This Excel tips series covers two sub-sections:

  1. Learn how to create custom formats across your worksheets.
  2. Learn how to modify existing number formats.

By the end, you’ll have full control of your numerical display game!

Custom Number Formats-15 Top Tips and Shortcuts for Excel 2013,

Image credits: by Harry Washington

Create custom number formats for consistent data presentation

When using Excel 2013 to present data, custom number formats can help make your spreadsheets easier to read and understand. To create custom formats, select the cell or range of cells you want to format and navigate to the “Number” tab in the “Home” menu.

Select “Custom” and enter a formatting code using characters that dictate how numbers will be displayed. This includes using currency symbols for monetary values and commas for large numbers. Additionally, decide how to show negative numbers, such as parentheses or a minus sign.

Customizing the format of dates, times, and percentages can also make them more readable. Research conducted by MIT researchers Cascio and Schanzenbach (2013) found that good presentation practices can lead to more accurate decision making, increasing comprehension and recall by up to 90%.

Modify existing number formats to suit your needs in Excel 2013

Want to modify existing number formats in Excel 2013? Here’s a 3-step guide:

  1. Choose the cell or range of cells. Then, select the “Home” tab in the ribbon.
  2. Click the “Number Format” dropdown menu. You’ll see pre-defined number formats like currency, percentage and date.
  3. Select the custom option at the bottom of the list. This will open a dialog box where you can create your own custom format.

After you understand this process, explore more advanced formatting options. Use conditional formatting to highlight certain numbers. Or use data validation rules to limit what types of numbers can be entered into a particular cell.

Take advantage of functions that apply different formatting rules based on criteria. For example, use the ROUND function to limit decimal places or the CURRENCY function to apply consistent currency symbols and decimal points.

There are many tweaks and adjustments you can make when modifying number formats in Excel 2013. Experiment with different options to find what works best for you.

Next, we’ll discuss Lookup Functions – an essential tool within Excel that allows users to search and retrieve values from large datasets.

Lookup Functions

As a data analyst, I often use Excel. It’s a great tool for streamlining and organizing data. Two of the most powerful features in Excel are Lookup Functions. I use these a lot. VLOOKUP and HLOOKUP are the two I use the most. VLOOKUP searches data vertically while HLOOKUP searches horizontally. I’m going to explain how to use these functions and give some tips on how to make your data analysis better.

Lookup Functions-15 Top Tips and Shortcuts for Excel 2013,

Image credits: by James Jones

Utilize VLOOKUP to search for data

Are you curious why you should use VLOOKUP? According to Udemy, “It is one of Excel’s most powerful functions, yet few are trained in it. Even in corporate settings, many analysts don’t understand its full potential.”

Let’s discuss the next tip:

“Use HLOOKUP to search for data horizontally in Excel 2013.”

Here are some tips and tricks for VLOOKUP:

  1. Understand the Lookup Value – this is the value you want to locate in your table.
  2. Ensure the Table is Sorted Alphabetically/ Numerically – VLOOKUP searches from top to bottom, so sorting will make the process much faster.
  3. Add a Range Lookup with TRUE/FALSE parameters – To find an approximate match in a range instead of an exact match, use TRUE as your final parameter.
  4. Nest Functions within Each Other (VLOOKUP with IF) – VLOOKUP functions can be nested within If functions and vice versa to create more complex formulas.
  5. Avoid Using Empty Cells/Rows in Your Table – A blank cell in a table can cause VLOOKUP to return an error. Therefore, it is best to avoid empty cells or rows in your table.
  6. Use Exact Match While Searching for Data – VLOOKUP only finds exact matches in the lookup range, so make sure you select ‘false’ when prompted for range_lookup.

Use HLOOKUP to search for data horizontally in Excel 2013

  1. Choose where you want the results cell. Click on the Formulas tab.
  2. Go to Lookup & Reference and select HLOOKUP.
  3. In the Function Arguments dialogue box:
    • Set Lookup_value as the cell which has what you are looking for.
    • Set Table_array as the entire table, including headers.
    • Set Row_index_num to 2 (row 1 has labels).
    • Set Match_type to False.

Remember to include labels similar to what you’re searching for in Row 1. For example, if you need “Apples”, make sure it’s there.

Using HLOOKUP is very common and makes data analysis easier. Plus, it saves businesses time and money according to!

Now, let’s look at Text Functions!

Text Functions

Excel 2013 is tedious and takes time to process data. It’s important to master text functions for efficient work. LEFT, RIGHT, and MID; and CONCATENATE are two types of text functions. I’ll show you how to use them to quickly extract and combine text. Ready to boost your Excel skills? Here we go!

Text Functions-15 Top Tips and Shortcuts for Excel 2013,

Image credits: by Adam Washington

Use LEFT, RIGHT, and MID to extract text easily

Discovering ways to quickly extract data from cells without manual copying and pasting can be difficult.

But by using the functions LEFT, RIGHT and MID, in Excel 2013, it becomes much easier!

Specify the cell or range with the text and determine the number of characters to extract with these functions. Press Enter for the result.

Organizing and viewing large amounts of text data is easier with these functions. Combine them with filters and pivot tables, and gain further insights into your data to make better business decisions.

Don’t miss out on improving productivity and organization skills by not utilizing these powerful text functions!

And remember, concatenate to combine text for even better data organization in Excel 2013.

Combine text with CONCATENATE for better data organization in Excel 2013

To combine text using CONCATENATE, first arrange your data to make sense for your needs. This tool is great for adding customer names and contact info together. Plus, descriptive language can be added to each piece of content. It is also useful for large datasets, which saves time and energy.

For example, a manager once used CONCATENATE to combine territories with employee names, making it easier to produce quarterly and yearly reports.

Additionally, there are Financial Functions, a collection of helpful functions that can assist in various financial calculations, such as loan payments and interest rates.

Financial Functions

Tired of the hassle of manually calculating loan payments and financial projections? Excel 2013’s powerful financial functions have you covered! This article dives into two of the most helpful functions: PMT and FV. We’ll give tips on how to use them properly. PMT will help you calculate loan payments with a few clicks, while FV can determine the future value of investments. These tools are must-haves, whether you’re a financial analyst or just trying to manage your personal finance better.

Financial Functions-15 Top Tips and Shortcuts for Excel 2013,

Image credits: by David Woodhock

Calculate loan payments with PMT in Excel 2013

Open an Excel worksheet and choose a cell to display the result of the PMT function. Click the Formulas tab in the ribbon, and in the Financial Functions category, click PMT. In the dialog box, enter values for Rate, Nper, and PV. Make sure that payments are made at the end of each period, and hit enter. The cell is populated with your calculated loan payment value.

Calculating loan payments is simple with PMT in Excel 2013. You just need to enter some values related to the transaction, like interest rates and payment term lengths. You can also create scenarios by changing one variable, like “periods” or “interest rate,” and see how these changes affect your monthly payments.

Earlier, calculating loan payments was complicated and required mathematical calculations outside spreadsheets. But now, Microsoft’s popular spreadsheet program—Excel 2013—has made it much easier.

We can also use another important financial function called FV to determine future value and plan better financially.

Determine future value with FV for better financial planning

Click any cell in an Excel worksheet where you wish the formula to appear. Then, type “=” followed by “FV” (e.g. =FV). Press Shift + F3 or click Insert Function (fx), select Financial and click OK.

Fill in the three required values – rate, nper, and pmt – to use FV. Add an optional present value if it exists. Once you have completed this, press Enter. A result will be displayed soon.

FV is a great tool for financial planning. It lets you work out how much your savings/investments can grow over time with a given interest rate and regular payments. For instance, if you save $500 per month for 10 years at 5%, your future value will be $77,961.

Many people use this feature in Excel for personal finance management, or to identify investments with high returns over long periods.

A young investor I know was hesitant to invest his money into stock markets until he found out about Excel’s FV function. It helped him understand the growth of his investment based on different assumptions of the stocks or bonds portfolio available.

Logical Functions are a powerful tool for complex datasets – let’s explore them!

Logical Functions

Excel 2013 has amazing logical functions! With easy keystrokes, you can make use of data analysis to make smart choices and speed up your workflows. This part will show you the IF function – one of the most important logical functions. Discover how it helps you decide based on certain criteria in a worksheet. Get ready to explore the world of logical functions. See how they transform your Excel 2013 experience!

Logical Functions-15 Top Tips and Shortcuts for Excel 2013,

Image credits: by David Washington

Make informed decisions with IF in Excel 2013

Using IF functions in Excel 2013 requires understanding its capabilities and limitations. To do this, consider your business objectives and how conditional formatting and cell values interact. Utilize logical operators like “and” and “or” to simplify nested functions. Test your formula before continuing. Be ready to troubleshoot errors or warnings Excel may provide.

Forbes article ‘Top Business Intelligence Trends To Watch In 2021’ states that successful businesses need decision-making strategies based on data analysis. In order to achieve this, BD&A leaders must have access to accurate and relevant information.

Finally, Database Functions can be used to further improve data analysis.

Database Functions

Do you have trouble handling a lot of data in Excel? Me too! That’s why I’m hyped to tell you about two fantastic database functions. The first one is DSUM. It quickly adds up huge amounts of data from a database. The second one is DCOUNT – it simplifies counting data without having to write complex formulas. These functions will transform the way you work with data in Excel 2013. You’ll be faster and more precise!

Database Functions-15 Top Tips and Shortcuts for Excel 2013,

Image credits: by David Jones

Use DSUM to efficiently sum data

If you’re working with big data sets in Excel, the DSUM function can save you time and effort! Define your criteria for adding or aggregating data, then create a table with all the data you wish to summarize. Finally, use the DSUM function to add up your selected data based on your criteria.

You’ll get accurate and precise results while streamlining your workflow. Don’t miss out – start using the DSUM function today! Plus, with Excel 2013 you can use DCOUNT to easily count data too!

Use DCOUNT to easily count data in Excel 2013

For using the DCOUNT function in Excel 2013, do the following:

  1. Select the cell where you want the result to appear.
  2. Enter "=DCOUNT(database, field, criteria)" into the Formula bar.
  3. Replace "database" with the range of cells that contain the data.
  4. Replace "field" with the column heading of the data to be counted.
  5. Replace "criteria" with a range of cells specifying the conditions for counting.

DCOUNT stands for Database COUNT and is an effective tool for quickly counting large amounts of data. You can customize the count based on specific needs, like counting values over a certain number or within a certain date range.

Using DCOUNT eliminates the need for manual counting, which is both tedious and prone to errors. You can rest assured of accurate results each time with this function.

Don’t miss out on the advantages of DCOUNT! Start utilizing it in your Excel 2013 tasks now!

Up next is Statistical Functions which can take your Excel analysis to the next level!

Statistical Functions

Statistical functions are essential for any data analysis. In this article, I’ll share great tips and shortcuts for Excel 2013. These will help work with data more meaningfully and insightfully. We’ll discuss two powerful Excel functions: AVERAGE and STDEV.

AVERAGE calculates the average of a range of cells. STDEV determines the standard deviation of your data set. This gives a clear view of the data’s distribution. It enables informed decisions to be made.

Statistical Functions-15 Top Tips and Shortcuts for Excel 2013,

Image credits: by James Woodhock

Calculate averages with AVERAGE in Excel 2013

Calculate averages with AVERAGE in Excel 2013 in three easy steps:

  1. Select the cell to show the average.
  2. Type “=AVERAGE(“ and choose the range of cells.
  3. Close the bracket by typing “)”, then press enter.

AVERAGE makes it quick and accurate. It can save time compared to manual calculation. It works on continuous and discontinuous ranges of data.

Make sure the selected range of cells only has number values. Non-numeric values can cause errors. Blank cells count as zeros.

Use keyboard shortcuts like ALT + equal sign (Alt+=). Or AutoSum by selecting the cell and clicking Home tab.

STDEV is important for data analysis. It shows how disparate the values are from each other.

Determine standard deviation with STDEV for a better understanding of your data

Here’s a 4-step guide for using STDEV to calculate standard deviation:

  1. Select the range of cells that contain your data.
  2. Go to the Formulas tab in the ribbon at the top of Excel.
  3. Under Statistical Functions, choose STDEV.
  4. Press Enter to get the result.

Calculating standard deviation with STDEV can be really helpful when dealing with big datasets or trying to comprehend complex numbers. It helps you to spot trends and patterns in your data that might not be visible otherwise.

Plus, it can assist you in finding outliers in your dataset which could be influencing your averages or other metrics. By having this knowledge, you can make decisions based on more reliable info.

To get even more benefit out of this function, you can look into its advanced features, such as selecting multiple ranges or using alternate formulas to estimate sample size.

Lastly, don’t forget Printing in Excel – it’s vital for creating hard copies of spreadsheets or sharing them with people who don’t have access to the file online.


Fed up with squandering paper and ink when printing Excel spreadsheets? We’ll get to the bottom of Excel 2013’s printing features in this section. With these shortcuts and tips, you’ll be able to print multiple worksheets quickly and easily. Plus, you can learn how to only print selected cells. This way, you won’t have to use up paper and ink and still keep the info you need. Believe me, these game changers are too good to miss!

Printing-15 Top Tips and Shortcuts for Excel 2013,

Image credits: by Adam Duncun

Seeking to make document management more efficient? Excel 2013 can help! Print multiple worksheets at once to save time. Select them by clicking on each tab while holding down the Ctrl key. Then, click File > Print. Under Settings, pick Print Active Sheets or Print Entire Workbook. To gain further control, pick Print Options. Finally, press Print.

This is especially helpful when working with data across different sheets. For instance, if you have a budget spreadsheet with sheets for income and expenses, printing both at once makes analyzing the data easier.

In addition, Excel 2013 has many other helpful tips and shortcuts. For example, use Ctrl+P to quickly bring up the Print menu or Alt+F11 for the Visual Basic editor. Preview your document before printing with File > Print > Preview. This lets you see how it will look and make adjustments.

By using these tips and shortcuts, you can improve efficiency with Excel 2013 for document management tasks like printing multiple worksheets.

Save paper and ink when printing from Excel 2013 by printing only the selected cells, instead of the entire worksheet! Six easy steps:

  1. Highlight the cells you want to print.
  2. Go to the “File” tab.
  3. Click “Print” in the left-hand menu.
  4. “Print Selection” should be selected under “Settings.”
  5. Choose your printer and other settings.
  6. Press “Print.”

Choose wisely what to print. It’s more eco-friendly, and it could save you money in the long run! A Greenpeace report shows that less paper means less deforestation. So, next time you need to print from Excel 2013, remember to select only the necessary cells!

Some Facts About 15 Top Tips and Shortcuts for Excel 2013:

  • ✅ Excel is a spreadsheet software developed by Microsoft. (Source: Microsoft)
  • ✅ Excel 2013 includes over 400 functions to help with calculations and data analysis. (Source: TechNet)
  • ✅ Excel 2013 introduced a new feature called Flash Fill, which allows for quick data cleaning and manipulation. (Source: Microsoft)
  • ✅ Keyboard shortcuts can greatly speed up tasks in Excel 2013, such as Ctrl+C to copy and Ctrl+V to paste. (Source: Lifewire)
  • ✅ Excel 2013 has a variety of templates available for use, including budget, calendar, and invoice templates. (Source: Excel Easy)

FAQs about 15 Top Tips And Shortcuts For Excel 2013

What are the 15 top tips and shortcuts for Excel 2013?

Here are the 15 top tips and shortcuts for Excel 2013:

  1. Use the Ctrl + ; shortcut to insert today’s date
  2. Insert a new row or column using the Ctrl + Shift + + shortcut
  3. Quickly move to the beginning of a row or column by pressing the Home key
  4. Group columns or rows together by selecting them and using the Ctrl + Shift + ( shortcut
  5. Use the F4 key to repeat your last action
  6. Create a chart in seconds by selecting the data and pressing the F11 key
  7. Quickly format your data as a table using the shortcut Ctrl + T
  8. Set a print area easily with the Ctrl + Shift + P shortcut
  9. Undo and redo actions using the Ctrl + Z and Ctrl + Y shortcuts
  10. Use the Ctrl + F shortcut to find specific data in your spreadsheet
  11. Quickly copy formulas and values down a column by double-clicking the fill handle
  12. Insert a hyperlink using the Ctrl + K shortcut
  13. Use Ctrl + Shift + $ to apply the currency format to a selected cell
  14. Convert selected text to uppercase using the Shift + F3 shortcut
  15. Protect your worksheet from editing with the Ctrl + Shift + F shortcut