Excel shortcuts

15 Top Tips and Shortcuts for Excel 2013

1. Use the Quick Access Toolbar

The Quick Access Toolbar (QAT) is a customizable toolbar that sits above the Ribbon in Excel 2013. By default, it includes commands for the most commonly used features, such as Save, Undo, and Redo. You can also add your own commands to the QAT. To do this, click the drop-down arrow at the end of the QAT and select More Commands.

2. Use the Ribbon

The Ribbon is the strip of buttons and icons located above the worksheet area in Excel 2013. It provides quick access to the most commonly used commands in Excel. To save space, the Ribbon collapses when you're not using it. To expand the Ribbon, simply click on any of the tabs (Home, Insert, Page Layout, Formulas, Data, Review, View).

3. Use the Mini Toolbar

The Mini Toolbar is a floating toolbar that appears when you select text or an object in Excel 2013. It provides quick access to the most commonly used commands for the selected object. To display the Mini Toolbar, simply select some text or an object. The Mini Toolbar will appear near your selection.

4. Use Shortcut Keys

Shortcut keys are a great way to save time when working in Excel 2013. For example, the shortcut key for the Save command is Ctrl+S. To see a complete list of shortcut keys in Excel, press F1. Then, select Keyboard Shortcuts from the Help menu.

5. Use the AutoComplete Feature

The AutoComplete feature in Excel 2013 automatically completes cell entries based on the first few letters that you type. For example, if you type "app" in a cell, Excel will automatically complete the entry with "apple." To turn on the AutoComplete feature, go to the File tab and select Options. Then, select the Proofing tab and check the Enable AutoComplete for cell values option.

6. Use the Fill Handle

The Fill Handle is a small square located in the bottom-right corner of the active cell. It's used to copy cell contents and formulas down or across a worksheet. To use the Fill Handle, simply select the cell with the content or formula that you want to copy. Then, position the mouse over the Fill Handle and drag it down or across the worksheet.

7. Use Flash Fill

Flash Fill is a new feature in Excel 2013 that automatically completes cell entries based on the contents of other cells in the worksheet. For example, if you have a column of first names and a column of last names, you can use Flash Fill to automatically generate a third column with the full names. To use Flash Fill, simply start entering the cell values that you want to generate. Then, press the Enter key and Excel will automatically complete the remaining values.

8. Use the Quick Analysis Tool

The Quick Analysis Tool is a new feature in Excel 2013 that makes it easy to apply formatting, charts, and other features to your data. To use the Quick Analysis Tool, select the data that you want to analyze. Then, click the Quick Analysis button that appears in the bottom-right corner of the selection.

9. Use the Recommended Charts Feature

The Recommended Charts feature in Excel 2013 makes it easy to create charts based on your data. To use this feature, select the data that you want to chart. Then, click the Insert tab and click the Recommended Charts button. Excel will display a list of recommended charts. Simply click on the chart that you want to insert.

10. Use the Chart Tools

The Chart Tools are a set of tools that you can use to customize your charts in Excel 2013. To access the Chart Tools, simply click on any chart. The Chart Tools will appear in the Ribbon. They include the Design, Layout, and Format tabs.

11. Use Sparklines

Sparklines are small charts that you can insert in a single cell. They're a great way to visualize data in a small amount of space. To insert a Sparkline, select the cell where you want to insert the chart. Then, click the Insert tab and click the Sparklines button. Excel will display a list of Sparkline types. Simply click on the type of Sparkline that you want to insert.

12. Use Slicers

Slicers are a new feature in Excel 2013 that make it easy to filter data in PivotTables and PivotCharts. To insert a Slicer, select the PivotTable or PivotChart that you want to filter. Then, click the Insert tab and click the Slicers button. Excel will display a list of the fields in the PivotTable or PivotChart. Simply click on the field that you want to filter.

13. Use the Timeline Slicer

The Timeline Slicer is a new feature in Excel 2013 that makes it easy to filter data by date. To insert a Timeline Slicer, select the PivotTable or PivotChart that you want to filter. Then, click the Insert tab and click the Timeline button. Excel will display a Timeline Slicer for the date field in the PivotTable or PivotChart.

14. Use the PowerPivot Add-In

The PowerPivot Add-In is a free add-in for Excel 2013 that allows you to work with large amounts of data. To install the PowerPivot Add-In, go to the File tab and select Options. Then, select the Add-Ins tab and select the COM Add-Ins option. Click the Browse button and locate the PowerPivot for Excel 2013 Add-In. Once the add-in is installed, you'll find the PowerPivot tab in the Ribbon.

15. Use the Get & Transform Data Feature

The Get & Transform Data feature in Excel 2016 makes it easy to import data from different sources. To use this feature, go to the Data tab and click the Get Data button. Then, select the source that you want to import data from. Excel will display a list of available data sources. Simply click on the source that you want to import data from.

Excel is a powerful tool that can help you manage and analyze data quickly and efficiently. However, with so many features and functions, it can be overwhelming to navigate. That's why we've compiled a list of 15 top tips and shortcuts for Excel 2013 to help you work smarter, not harder.

1. Use the Quick Access Toolbar

The Quick Access Toolbar is a customizable toolbar that allows you to access frequently used commands with just one click. To add a command to the Quick Access Toolbar, right-click on the command and select "Add to Quick Access Toolbar".

2. Use Keyboard Shortcuts

Keyboard shortcuts can save you a lot of time when working in Excel. Here are a few useful shortcuts:

  • Ctrl + C: Copy
  • Ctrl + V: Paste
  • Ctrl + Z: Undo
  • Ctrl + Y: Redo
  • Ctrl + F: Find
  • Ctrl + H: Replace

3. Use AutoFill

AutoFill is a feature that allows you to quickly fill a series of cells with a pattern or sequence. To use AutoFill, enter the first value in the series, select the cell, and drag the fill handle (the small square in the bottom right corner of the cell) to fill the rest of the series.

4. Use Flash Fill

Flash Fill is a feature that allows you to quickly fill a column of data based on a pattern. For example, if you have a column of names in the format "First Last", you can use Flash Fill to separate the first and last names into separate columns. To use Flash Fill, enter the desired output in the first cell of the column, and Excel will automatically fill in the rest of the column based on the pattern.

5. Use Conditional Formatting

Conditional Formatting allows you to highlight cells that meet certain criteria. For example, you can use Conditional Formatting to highlight all cells that contain a certain value, or all cells that are above or below a certain value. To use Conditional Formatting, select the cells you want to format, click on the "Conditional Formatting" button in the "Home" tab, and select the desired formatting option.

6. Use PivotTables

PivotTables are a powerful tool for analyzing large amounts of data. PivotTables allow you to summarize and analyze data in a variety of ways, such as by summing, averaging, or counting values. To create a PivotTable, select the data you want to analyze, click on the "Insert" tab, and select "PivotTable".

7. Use VLOOKUP

VLOOKUP is a function that allows you to search for a value in a table and return a corresponding value from a different column in the same table. To use VLOOKUP, enter the function in a cell, specify the value you want to search for, and specify the table and column you want to return the value from.

8. Use IF Statements

IF Statements allow you to perform a logical test and return one value if the test is true, and another value if the test is false. For example, you can use an IF Statement to determine if a student passed or failed a test based on their score. To use an IF Statement, enter the function in a cell, specify the logical test, and specify the values to return if the test is true and false.

9. Use Absolute References

Absolute References allow you to refer to a specific cell or range of cells in a formula, even if you copy the formula to a different location. To use Absolute References, add a "$" symbol before the column and/or row reference in the formula.

10. Use Named Ranges

Named Ranges allow you to assign a name to a specific cell or range of cells, making it easier to refer to the cell or range in formulas and functions. To create a Named Range, select the cell or range you want to name, click on the "Formulas" tab, and select "Define Name".

11. Use Data Validation

Data Validation allows you to restrict the type of data that can be entered into a cell. For example, you can use Data Validation to ensure that a cell only accepts numbers between 1 and 10. To use Data Validation, select the cell you want to validate, click on the "Data" tab, and select "Data Validation".

12. Use Goal Seek

Goal Seek allows you to find the input value needed to achieve a desired output value in a formula. For example, you can use Goal Seek to determine the sales volume needed to achieve a certain profit margin. To use Goal Seek, click on the "Data" tab, select "What-If Analysis", and select "Goal Seek".

13. Use Solver

Solver is a powerful tool that allows you to find the optimal solution to a complex problem. Solver can be used to optimize a variety of scenarios, such as production schedules, investment portfolios, and transportation routes. To use Solver, click on the "Data" tab, select "What-If Analysis", and select "Solver".

14. Use Macros

Macros allow you to automate repetitive tasks in Excel. Macros are created using Visual Basic for Applications (VBA), a programming language built into Excel. To create a macro, click on the "Developer" tab, select "Visual Basic", and create a new macro.

15. Use the Help Function

The Help function in Excel can provide valuable information and guidance on how to use Excel's features and functions. To access the Help function, click on the "Help" button in the top right corner of the Excel window, or press the F1 key on your keyboard.

By using these tips and shortcuts, you can become a more efficient and effective Excel user, and save yourself time and frustration in the process.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.

15 Top Tips and Shortcuts for Excel 2013

Microsoft Excel 2013 is a powerful tool that can be used to organize, analyze, and present data. Whether you're a seasoned Excel veteran or a beginner just starting out, there are always new tips and tricks to learn that can make your work more efficient. In this guide, we will explore 15 top tips and shortcuts that can help you get the most out of Excel 2013.

1. Master the Ribbon

The Ribbon is the toolbar at the top of the Excel window. It contains all the commands you'll need to perform tasks in Excel. By , you can save time and effort in your work.

One way to do this is by customizing the Ribbon to suit your needs. You can add or remove tabs, and even create your own custom tabs with the commands you use most frequently. This can make your work much more efficient.

2. Learn Keyboard Shortcuts

Keyboard shortcuts can save you a lot of time when working in Excel. Instead of reaching for the mouse every time you need to perform a command, you can simply press a combination of keys on your keyboard.

For example, you can press Ctrl+C to copy a cell, and then Ctrl+V to paste it elsewhere. Or, you can press Ctrl+Z to undo your last action. There are many more keyboard shortcuts in Excel, and learning them can greatly speed up your work.

3. Use the Fill Handle

The Fill Handle is a small square in the bottom-right corner of a selected cell or range of cells. You can use it to quickly copy the contents of a cell to adjacent cells, or to fill a range of cells with a series or pattern.

For example, if you have a cell with the value "1" and you want to fill a range of cells with a series of numbers, you can simply select the cell, drag the Fill Handle over the range of cells, and Excel will automatically fill them with the series "1, 2, 3, and so on.

4. Use Conditional Formatting

Conditional formatting is a powerful feature in Excel that allows you to change the formatting of cells based on their contents. For example, you can use conditional formatting to highlight cells that contain values above a certain threshold, or to color-code cells based on their values.

This can be very useful for analyzing data and identifying trends or outliers. To use conditional formatting, select the cells you want to format, then go to the Home tab on the Ribbon and click the Conditional Formatting button.

5. Use PivotTables

PivotTables are one of the most powerful features in Excel. They allow you to summarize and analyze large amounts of data quickly and easily. With a PivotTable, you can group data, calculate totals, averages, or other statistics, and create interactive reports.

Creating a PivotTable is easy. Simply select the data you want to analyze, go to the Insert tab on the Ribbon, and click the PivotTable button. Then, drag and drop fields to the Rows, Columns, and Values areas to create your PivotTable.

6. Use Excel's Built-In Functions

Excel has hundreds of built-in functions that you can use to perform calculations, analyze data, and more. These functions can save you a lot of time and effort, especially when working with large amounts of data.

For example, you can use the SUM function to quickly add up a range of cells, or the AVERAGE function to calculate the average of a range of cells. To use a function, simply type its name in a cell, followed by a pair of parentheses. Inside the parentheses, you can specify the cells or range of cells you want the function to operate on.

7. Use Data Validation

Data validation is a feature in Excel that allows you to control what kind of data can be entered into a cell. For example, you can use data validation to ensure that only numbers are entered into a cell, or that a date is within a certain range.

This can be very useful for preventing errors and maintaining the integrity of your data. To use data validation, select the cells you want to validate, go to the Data tab on the Ribbon, and click the Data Validation button.

8. Use the Quick Access Toolbar

The Quick Access Toolbar is a customizable toolbar that contains a set of commands that are independent of the tab on the Ribbon that is currently displayed. You can add commands to the Quick Access Toolbar that you use often and want to be able to access quickly.

For example, you can add the Save, Undo, and Redo commands to the Quick Access Toolbar so that you can quickly save your work or undo or redo your last action, regardless of which tab on the Ribbon you're currently on.

9. Use Excel's Charting Features

Excel's charting features allow you to create a variety of charts and graphs to visualize your data. You can create bar charts, pie charts, line charts, scatter plots, and more.

Creating a chart in Excel is easy. Simply select the data you want to chart, go to the Insert tab on the Ribbon, and click the chart type you want to create. Then, customize your chart as desired using the Chart Tools tabs on the Ribbon.

10. Use the Format Painter

The Format Painter is a tool in Excel that allows you to quickly copy the formatting from one cell and apply it to another. This can save you a lot of time and effort when you want to apply the same formatting to multiple cells.

To use the Format Painter, select the cell with the formatting you want to copy, click the Format Painter button on the Home tab on the Ribbon, and then click the cell you want to apply the formatting to.

11. Use the AutoSum Button

The AutoSum button is a quick and easy way to add up a range of cells. Simply select the cell where you want the total to appear, click the AutoSum button on the Home tab on the Ribbon, and Excel will automatically insert a SUM formula that adds up the adjacent cells.

You can also use the AutoSum button to quickly calculate the average, count, max, or min of a range of cells. Simply click the drop-down arrow next to the AutoSum button and select the function you want to use.

12. Use the Flash Fill Feature

Flash Fill is a feature in Excel 2013 that automatically fills in values in a column based on a pattern recognized in the data. For example, if you have a column of full names and you start typing first names in the adjacent column, Excel will recognize the pattern and automatically fill in the rest of the first names for you.

This can save you a lot of time and effort when you need to split or combine data in a column. To use Flash Fill, simply start typing in the adjacent column and Excel will suggest the rest of the values. If the suggestion is correct, press Enter to accept it.

13. Use the Quick Analysis Tool

The Quick Analysis tool is a feature in Excel 2013 that provides quick access to common analytical tasks, such as adding totals or averages, applying conditional formatting, or creating a chart.

To use the Quick Analysis tool, select the data you want to analyze, click the Quick Analysis button that appears at the bottom-right corner of the selection, and then choose the task you want to perform.

14. Use the Freeze Panes Feature

The Freeze Panes feature allows you to keep a portion of your worksheet visible while you scroll to another area of the worksheet. This can be very useful when you're working with large worksheets and you want to keep the row or column headers in view.

To use the Freeze Panes feature, go to the View tab on the Ribbon, click the Freeze Panes button, and then choose whether you want to freeze the top row, the first column, or a specific number of rows and columns.

15. Use the Text to Columns Feature

The Text to Columns feature allows you to split the contents of a cell into multiple cells based on a delimiter, such as a comma or a space. This can be very useful when you have data in a single cell that you want to split into separate cells.

To use the Text to Columns feature, select the cell or range of cells you want to split, go to the Data tab on the Ribbon, and click the Text to Columns button. Then, follow the steps in the wizard to specify how you want to split the data.

In conclusion, Excel 2013 is a powerful tool with many features and shortcuts that can help you work more efficiently. By mastering these tips and shortcuts, you can save time, improve your productivity, and get the most out of Excel 2013.

Discover a New Way to Work with Data

If you've enjoyed mastering Excel 2013, you'll love exploring Causal—an innovative alternative designed specifically for number crunching and data analysis. With Causal, you can effortlessly perform complex calculations, create stunning visualizations, and present your data in interactive dashboards. It's the perfect tool for modelling, forecasting, and scenario planning. Best of all, getting started is quick, simple, and free. Ready to take your data skills to the next level? Sign up today and experience the future of data analysis with Causal.

PERSONAL FINANCE
Buy vs Rent
Should you buy a house or rent?
Startur
B2B SaaS Revenue
Forecast your inbound and outbound leads to determine revenue, and understand what kind of sales funnel you need to hit your revenue targets.
FINANCE
Detailed Headcount Model
Understand the breakdown of your headcount and payroll costs by Department (Sales, Engineering, etc.) and plan your future hires.