• Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • More
    • Blog
    • Download Area
    • Excel Video Tutorials
Home » Excel Video Tutorials

Excel VLOOKUP Book By Chandoo. Org – Reviewed.

November 30, 2015 by Barbara

Now I have been an Excel enthisiast and user for around 20 years now, but one of the most talked about features in Excel I have experienced is the VLOOKUP table. I recently changed over offices in my day job, and one of the first things someone said to me when they found out about my Excel exploits was ohhh so you know all about them VLOOKUPS and stuff. ... Love them or hate them they are awesome in their power of analysis from just a few clicks of the mouse! A book/video I have had in my … [Read more...]

Filed Under: Blog, Excel Videos Tagged With: Excel, Excel Tips, Excel Video Tutorials

Compare Two Excel Lists To Highlight Missing Items

March 11, 2014 by Barbara

A really common task used frequently in Excel is to compare two lists to highlight items that appear in one list but are not in the other. Here is a great way to combine two great Excel features to get exactly the results we need. We can combine the VLOOKUP function along with Conditional Formatting. The VLOOKUP will be used used to look up an item from one list in the other, and the Conditional formatting will highlight the missing items for us. In my example I have two lists of … [Read more...]

Filed Under: Blog, Excel Tips& Tricks, Formulas, Tutorials Tagged With: Excel Tips, Excel Video Tutorials, Formula

Why You Should Use MS Excel To Build Business Dashboards

October 15, 2013 by Barbara

Dashboard skills are in great demand by employers, if you can build great dashboards; it is a valuable skill to have. Even better if you can build them in one of the most widely used pieces of software- Microsoft Excel. Essentially dashboards are a technique of report used to visually present critical metrics or a data summary to enable quick and effective business decisions. This would be in the same way a car dashboard will display only the main pieces of data needed when driving your … [Read more...]

Filed Under: Blog, Excel Charting, Excel Tips& Tricks Tagged With: Excel Charting, Excel Tips, Excel Video Tutorials

Quickie Tip: Shrink Your Cell Data

March 26, 2012 by Barbara

Here is another fab Excel tip. Excel is kind of clever as if you didn't already know. Excel will automatically fit your data to your cells by shrinking it. The data in the cell is fitted within your column width by the reduction of your font size- which then changes with the width of the columns. Yes clever! So, if you want to shrink your data into your Excel cells. Select a cell or a range of cells Home Tab Cells Group Format Format Cells OR select CTRL+1 for even quicker … [Read more...]

Filed Under: Excel Tips& Tricks, Quickie Tips Tagged With: Cells, Excel, Excel Tips, Excel Video Tutorials

Tags

Blog Cells Excel Excel Charting Excel Excel Tips Excel Formulas excel tip Excel Tip Category Excel Tips Excel Tips& Tricks excel tutorials Excel Videos Excel Video Tutorials formatting Formula formula friday Formulas macro Macro Mondays Macros Pivot Table Pivot Tables Power BI Power Query Tutorials vb VBA Worksheets

Recommended Excel Resources

Free Excel Dashboard Webinar

Copyright © 2021 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in

Popular Pages

  • Home

More Info

Want FREE Excel Tips?

Click on my FREE eBook, its my bonus for joining thousands of others who receive my 3 xFREE Excel tips every month in my Excel Newsletter. Join Us!.

Need Answers To Excel Questions Like These?

*How Do I Create A Timestamp In Excel?
*I Want To Change The Width Of The bars On My Excel Chart
*How Can I Find Out The Length Of My Text in Excel? Click the link below to receive more Excel tips' and my Free Ebook

New To Excel? This Is A Great Place To Start!!

Learn Excel Dashboard Course Excel Basics
Scrollbars
Colour of Sheet Tabs
Conditional Formatting
Calculations Introduction

Excel Charting

Self Expanding Charts
One Click Charts
Create Quick Dynamic Charts
Easy Combination Charts

Video Tutorials-If You Like To Learn By Watching

Subscribe to YouTube to get notified of of new Excel videos.


Self Expanding Chart
Delete Obsolete Items From A Pivot Table-Excel 2007
What Are Pivot Tables- Create Your First One
Enable The DeveloperTab In Excel

Some Fun Stuff

Pivot Table Song

Navigation

  • Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • Top Menu

Follow Us

  • Twitter
  • Facebook

Search

© howtoexcelatexcel.com. All rights reserved.

  • Privacy Policy