Your Top Excel Tips For Beginners

On Twitter this week, David Napoli asked us – What top Excel tip would you teach in a class? David is planning an Excel class, and has most of the content ready, but wanted ideas from other people who have taught similar courses. What are your top Excel tips for beginners?

David’s Tweet

If you’re on Twitter, you can find David’s account here. He’s a Data Viz consultant and instructor, recovering rocket scientist, and loves cycling near his home in Colorado.

Here is the tweet that David posted, asking for suggestions on Excel tips and topics.

My Top Excel Tips

In my reply to David, I listed 2 tips:

  1. Format lists as named Excel Tables
  2. Save early and save often

See the end of this blog post for the macro that I use to make a quick backup copy, while working on an Excel file.

Sensible Formats and Names

John MacKintosh had a few great tips in his tweet, including sensible date formats and column names. Those can save you lots of pain and trouble.

Keeping data on a single sheet is important too – don’t create a different sheet for each month or department or whatever!

Personalize the Topics

Ann K. Emery had a great tip – personalize your topics, such as “Here’s a thing I wish I knew sooner…” How many times have you finally learned a quicker way to do something that you’ve been doing for years?

Formats and Layout

Jovan Lekovic suggested that David show Themes, from the Page Layout tab, and Copy/Paste Special…Formats with charts.

Cell Styles are an overlooked feature too, that can make it quicker and easier to format a workbook.

Power Query or Not?

The big debate though, was whether or not David should show Power Query (Get and Transform) to Excel beginners. Which side are you on?

Ken Puls and Greg Frazier both suggested Power Query, before David said it was a beginner class.

___________________________

David and Ken thought that Power Query would be better in a later class.

___________________

Structured Data

But Jorge Camoes disagreed, and said that Power Query should be taught from Day 1 in Excel.

___________________________

And Ken seems to agree with Jorge now!

Your Excel Tips for Beginners

So, what are your top tips for Excel beginners? And would you include Power Query basics in your beginner class?

Excel Workbook Backup Macro

Here’s the Excel workbook backup macro that I use almost every day. Copy this macro code, and paste it into a regular code module in a workbook that’s always open, when you use Excel.

NOTE: If you’ve bought a copy of my Excel Tools add-in, you already have this macro. Just click the Make Backup command in the Workbook section of the toolbar

Quick Backup Macro Code

The code below will save a copy of the active workbook, in the same folder. The copy has the same file name and extension, with the date and time added to the end of the name. For example:

MyFileName_20190627_0905.xlsx

Sub QuickBU_SameFolder()
Dim wb As Workbook
Dim strFile As String
Dim strName As String
Dim lExt As Long
Dim strDir As String
Dim strExt As String
Dim lPer As Long
Dim strStamp As String

Set wb = ActiveWorkbook
strName = wb.Name
strDir = wb.Path & ""
strStamp = Format(Now, "_yyyymmdd_HhMm")
lPer = InStr(1, UCase(Right(strName, 5)), ".")

Select Case lPer
  Case 1:     lExt = 5
  Case 2:     lExt = 4
  Case Else:  lExt = 0
End Select

If lExt = 0 Then
  MsgBox "Please save the file and then try again."
  GoTo exitHandler
End If

strExt = Right(strName, lExt)
strFile = Left(strName, Len(strName) - lExt)

ActiveWorkbook.SaveCopyAs _
  strDir & strFile & strStamp & strExt
  
MsgBox "The file was saved as " _
  & vbCrLf _
  & strFile & strStamp & strExt _
  & vbCrLf _
  & vbCrLf _
  & "in the current folder:" _
  & vbCrLf _
  & strDir

exitHandler:
  Set wb = Nothing
  Exit Sub
  
End Sub

____________________

Top Excel Tips For Beginners

Top Excel Tips For Beginners

__________________________

Original source: https://contexturesblog.com/archives/2019/06/27/your-top-excel-tips-for-beginners/

Leave a Reply

Close Menu