Excel 2013 Level 1

Excel 2013 – 1.11.5 – Printing Selected Cells

So the boss only wants a certain range from your Excel data to be printed? Discover the steps to print Selected Cells in this short video.

DETAIL

Excel 2013 – 1.11.4 – Check Spelling

Just about ready to present your data? It’s worth your while carrying out a Spell Check. Take a moment to watch this video and learn how.

DETAIL

Excel 2013 – 1.11.3 – Insert and Delete Page Breaks

Ever wondered how to manage the way your Excel data prints over a number of Pages? In this video we show you how the Page Break Preview feature helps you to do just that.

DETAIL

Excel 2013 – 1.11.2 – Print Titles Across Pages

Got a large amount of data to print? Discover in this video how to ensure that the column headings on the first page will also appear on all subsequent pages to be printed.

DETAIL

Excel 2013 – 1.10.7 – Specific Formats for Pie Charts

So you’ve created a Pie Chart and now wish to work on its presentation? Take a look at this video as we demonstrate how to focus on a particular slice of the Pie and how to explode the Pie for visual effect.

DETAIL

Excel 2013 – 1.10.6 – Create a Pie Chart

Pie Charts – a simple visual method to display information. Watch this video to learn how to create Pie Charts. We also show you how to vary the data being displayed on a Pie Chart.

DETAIL

Excel 2013 – 1.10.5 – The Special Printing Feature of Charts

Learn how – by simply selecting it – you can print a Chart independently of the source data.

DETAIL

Excel 2013 – 1.10.4 – Format a Chart Using the Chart Tabs

An alternative to using commands contained in the Design Tab is to use the Chart Tabs that appear on the Right Hand Side of a selected Chart. Of particular value here is the Chart Filters Tab.

DETAIL

Excel 2013 – 1.10.3 – Format a Chart Using the Format Tab

If you want to take the presentation of your Chart that bit further take a moment to look at the features that are available in the Format Tab.

DETAIL

Excel 2013 – 1.10.2 – Format a Chart Using the Design Tab

Once your chart is created and you then select it – or click on it – three contextual Tabs are enabled on the Ribbon. In this video we demonstrate how – using the Design Tab – you can change the type, style and appearance of your Chart.

DETAIL

Excel 2013 – 1.9.4 – Scale Multiple Pages of Data to Fit Onto One Page

In this video we show you some tips to organise your data on to one page for printing – as a means of viewing or checking the appearance of your Excel information.

DETAIL

Excel 2013 – 1.9.3 – Show the Same Worksheet on the Screen Twice

An alternative to applying a Split Screen is to display your worksheet twice – or side by side – on the same screen. Watch this video and find out how.

DETAIL

Excel 2013 – 1.9.2 – How to Split a Screen

This is a very useful feature when working with large amounts of data. Splitting a screen allows you to work with data in one part of a large Table whilst viewing the consequences of your changes in a different part.

DETAIL

Excel 2013 – 1.9.1 – Freeze Panes

Learn in this video how to effectively use the Freeze Panes feature to view information in a large list of data.

DETAIL

Excel 2013 – 1.11.1 – Using Find & Replace

Just about ready to present your data but discover you’ve made a typo, or a name has changed? Learn in this video how to Find and Replace multiple occurrences of text in Excel.

DETAIL

Excel 2013 – 1.10.1 – Create a Column Chart

So now you have your figures together, it may be useful to present this information in Chart format? First learn some basic steps to correctly select your data and then discover different techniques to quickly create a Column or Comparison Chart.

DETAIL

Excel 2013 – 1.8.7 – Conditional Formatting Using Dates

Here’s another useful feature associated with Conditional Formatting. Learn in this video how to highlight a date – or range of dates – that satisfy certain criteria based on today’s date.

DETAIL

Excel 2013 – 1.8.6 – Conditional Formatting Using Text

Have you ever needed to highlight particular cells in which the Text – or Labels – are the same? Watch this video and learn how to set this up.

DETAIL

Excel 2013 – 1.8.5 – Conditional Formatting to Show Top 40%

Take a look at this video and learn how to apply formats to cell values that fall with a certain range – such as the Top 40% of values.

DETAIL

Excel 2013 – 1.8.4 – Create Multiple Conditions

Have you ever needed to highlight data that meets more than one condition? We show you here the steps to take to create up to 64 conditions upon which you can apply a format.

DETAIL

Excel 2013 – 1.8.3 – Conditional Formatting using Icon Sets

In this video we take you through the steps to graphically display and distinguish your numerical data with icons. We also demonstrate how you can specify the values which trigger a particular icon.

DETAIL

Excel 2013 – 1.8.2 – Conditional Formatting using Color Scales

This short video takes you through the steps needed to apply gradient colour scales to a list of values.

DETAIL

Excel 2013 – 1.8.1 – Conditional Formatting using Data Bars

Ever wondered how to graphically display and distinguish your data – particularly numbers? In this video we introduce you to the world of Conditional Formatting.

DETAIL

Excel 2013 – 1.7.9 – Using Wrap Text and Line Breaks

A very useful tip here. In this video we show you how to Wrap Text in a cell but … we also show you how you can control the number of lines your text appears on by using Line Breaks.

DETAIL

Excel 2013 – 1.7.8 – Using Merge & Center

Watch this video and learn how to present headings for your data using the Merge and Center feature. We also demonstrate how this feature can go wrong.

DETAIL

Excel 2013 – 1.7.7 – Remove Borders, Shading and Font Colour

Now that you’ve applied some formats to your Excel data – how do you remove them? Watch this short video and learn how.

DETAIL

Excel 2013 – 1.7.6 – Format Background and Font

To make your data that bit more presentable, there are a number of simple formatting options you can use. Learn those options here.

DETAIL

Excel 2013 – 1.7.5 – Add Borders

Adding Borders around and within the contents of an Excel Table can be a useful way to provide focus to your data. Watch this video and you will learn some simple methods to apply Borders.

DETAIL

Excel 2013 – 1.7.4 – Format as Time

If you need to perform Time calculations in Excel your data must be formatted appropriately. Here we show various time formats that will facilitate future calculations.

DETAIL

Excel 2013 – 1.7.3 – Format as Dates

In this video we demonstrate how Excel works with Date information. You will also learn how to change the standard Date style to a different format.

DETAIL

Excel 2013 – 1.7.2 – Format Figures as Percentages

Take a look at this video and learn how to convert figures into percentages. You will also discover how Excel rounds percentage figures up or down – and how you can reformat percentage values to show more or less decimal places.

DETAIL

Excel 2013 – 1.7.1 – Format Figures as Currency

Ever wondered how to quickly apply currency formats to figures in your Excel Worksheet or Table? Take a look at this video and discover different methods to apply currency formats as well as different presentation styles.

DETAIL

Excel 2013 – 1.6.7 – Insert Headers & Footers

Watch this video to learn how – using the Page Layout feature – you can place information at the top and bottom of your printed sheets. We also show you how to select and set page numbers.

DETAIL

Excel 2013 – 1.6.6 – Adjust Page Margins

Want to create more professional printouts of your Excel data? In this video we show you how to set and change the page margins.

DETAIL

Excel 2013 – 1.6.5 – Change the Page Orientation

Using Print Preview check how many pages your data will be printed on and discover how to change the printed page orientation from Portrait to Landscape.

DETAIL

Excel 2013 – 1.6.4 – Hiding and Unhiding Rows, Columns and Sheets

Got a large amount of information in your Excel worksheet but don’t wish to view or print everything? Watch this video and find out how to Hide Columns, Rows and Sheets – and how to Unhide them afterwards.

DETAIL

Excel – 1.6.3 – Moving and Copying Sheets Within a Workbook

Have you ever needed to change the position of a Worksheet or make a copy of an existing Worksheet in your Workbook? In this video you will learn how to move or copy Worksheets using different techniques.

DETAIL

Excel 2013 – 1.6.2 – Insert, Rename and Delete Sheets

Learn how to quickly insert a new Worksheet into your Excel Workbook. Also discover how you can rename Worksheets and remove them from your Workbook if necessary.

DETAIL

Excel 2013 – 1.6.1 – Inserting and Deleting Columns and Rows

Working with existing data in Excel? Discover efficient ways of inserting additional Columns and Rows and learn which formats will be adopted by your data. Find out also how to quickly delete Columns and Rows.

DETAIL

Excel 2013 – 1.5.8 – Using the Fill Handle

Watch this video and discover how you can use the Fill Handle to quickly copy and apply a calculation down a column of data.

DETAIL

Excel 2013 – 1.5.7 – Paste Values

When Copying and Pasting numbers that have been calculated you will lose the original values – all due to Relative Referencing (take a look at Lesson 4). Here we show you how to use the Paste Values feature to retain those original figures.

DETAIL

Excel 2013 – 1.5.6 – Transpose

Here’s a scenario. You have a table in Excel but wish to turn the Column headings into Row headings or vice versa? Watch this video and learn how to use the Transpose feature in conjunction with the Copy and Paste commands.

DETAIL

Excel 2013 – 1.5.5 – Paste Column Widths

Ever been frustrated by having to resize every Column in a Table you’ve copied from one Worksheet to another? In this short video we’ll show you a very useful tip on how to quickly resize the Column Widths to match the original Table.

DETAIL

Excel 2013 – 1.5.4 – Different Ways to Copy and Paste

In this video we demonstrate 3 different methods which you can use to copy data in your Worksheet.

DETAIL

Excel 2013 – 1.5.3 – Different Ways to Cut and Paste

Want to move information around your Sheet? There are several different ways to Cut and Paste data in Excel. Watch this video to discover which technique suits you.

DETAIL

Excel 2013 – 1.5.2 – Series Fill using Numbers and Dates

In this video we show you some useful tips to help you create an increasing sequence of Numbers or Dates. We also demonstrate how the SmartTag feature can be used to change a sequence of Days to Weeks, Months or Years.

DETAIL

Excel 2013 – 1.5.1 – Create a Series Fill using Text

In this video you will learn how the Fill Handle can be used to create a series of Labels such as Months of the year or Days of the week. You will also learn how to copy a cell format across a number of adjacent cells.

DETAIL

Excel 2013 – 1.4.8 – Convert Blank Cells to Text

Careful now! The logical approach to converting Numbers to Text might be to simply format the selected range of Numbers as Text. However this will not work. Formatting as Text only works when you format a range of Blank Cells as Text and then enter Numbers in these Cells afterwards.

DETAIL

Excel 2013 – 1.4.7 – Convert Multiple Numbers to Text

In the previous videos in this Lesson we’ve looked at what can go wrong when Excel treats Text as Numbers – and we’ve seen how to spot these issues and resolve them. What happens if you wish to convert a list of Numbers to Text that are not developed sequentially? Watch this video and learn […]

DETAIL

Excel 2013 – 1.4.6 – Explanation of Number Conversion

In this short video we show you how Excel treats Numbers (or Values) differently to Text (or Labels). We also demonstrate how to spot these differences in a Worksheet.

DETAIL

Knowledge Market in Your Business

Knowledge Market is a great source for online video tutorials. We have developed a range of topics based on the applications that you use every day.
So whether you wish to refresh your existing knowledge - or you want to learn something new - we've got everything you need when you need it and where you need it.

Membership

Our Membership options have been developed to suit your specific needs. Contact us today to find out how we can be part of your office support infrastructure.

CONTACT

Email: kelly@knowledgemarket.ie

Performance Support and Learning for:
Microsoft Office – Excel, PowerPoint, Project, Word

Privacy & Cookies

This website uses Cookies. Continued use of the site will be deemed as your acceptance of this necessity.

Please read our Privacy Policy