Excel Help Blog

Full of helpful tips to help you get the most from Excel

Excel Top Tips

Developer Toolbar Ribbon

Developer Toolbar Ribbon

This quick video will show you how to view the Developer Tab or Ribbon in Excel. Since Excel 2007 – the traditional Visual BASIC options have moved to a new Developer Tab. This Tab is not visible by default. Learn how to view the developer tab or ribbon in Excel....

read more
Margins, Orientation and Page size

Margins, Orientation and Page size

This quick video explains how you alter the margins, orientation and page size in the Excel worksheet. Within the page layout tab – there is a section called Page Setup which allows us to alter the margins, orientation and page size. Learn what these settings refer to...

read more
How to insert page breaks in Excel

How to insert page breaks in Excel

This quick video will teach you how to insert Page Breaks manually in your spreadsheet. If you find that you have straggling rows or columns in your spreadsheet – you may need to insert a page-break at an earlier point in your spreadsheet. Learn how to insert page...

read more

Excel Foundations

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.

Excel Formulas and Functions

Drop down lists

Drop down lists

This quick video explains how to create a Drop Down List in Excel. Drop down lists are a useful way of presenting the user with a finite list of options. Learn how to create them Data Validation [et_social_follow icon_style="slide" icon_shape="rectangle"...

read more
VLOOKUP

VLOOKUP

This quick video explains how to use the VLOOKUP Function in Excel. The VLOOKUP function is one of the most widely used functions in Excel and is regularly used incorrectly. Learn why it is so useful and what errors to avoid. V is short for Vertical and lets us...

read more
Drop down lists using INDIRECT

Drop down lists using INDIRECT

This quick video explains Drop Down Lists using the INDIRECT Formula Learn how to create drop-down lists using the INDIRECT function. [et_social_follow icon_style="slide" icon_shape="rectangle" icons_location="top" col_number="auto" outer_color="dark"] Be Brilliant at...

read more

Excel Analyzing Data

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.

Excel Charts

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.

Excel Reporting and Dashboards

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.

Excel Security and Design

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.

Excel Recording Macros and VBA

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.