Custom Computer Training - Bob Flisser

New seminars available: AI Ethics | Microsoft Copilot

COMPUTER TRAINING:
IN PERSON, REMOTE,
OR VIDEO COURSE CREATION

Whether you need training in commercial or custom applications, in-person training or over the internet, or custom video course authoring, Bob will give you, your employees or customers the same quality training thousands of people have enjoyed from his courses for many years.

Bob Flisser

World Cup Excel

If you’re following World Cup Soccer (excuse me, I mean fútbol), here are two ways

Read more

Bob Flisser

Excel 2010 Essential Training

My full-length Excel 2010 course is now available at Lynda.com: http://www.lynda.com/home/DisplayCourse.aspx?lpk2=61219. It covers everything in

Read more

Bob Flisser

How to run multiple copies of Microsoft Office on the same computer

Microsoft said it couldn’t be done, but yes, it can! I always need to keep

Read more

Bob Flisser

New course: Excel 2010 New Features

Last month, Microsoft released the Office 2010 suite to enterprise customers. That means giant corporations

Read more

Bob Flisser

Back to the blogs

It’s like this: my last blog of software tips & shortcuts expired of not-so-benign neglect, and

Read more

Between the Sheets: Bob's Excel video podcast

Episodes

81 Videos

Need to find an investment yield? Excel calculates internal rate of return.

4:17

How to calculate present value and net present value in Excel

5:40

Enhance your Excel sheets with headers and footers

5:11

Convert between European and US commas and periods for thousands and decimals

2:52

Does your Excel sheet have extra spaces and nonprinting characters? You have to try this!

3:17

Google Sheets and Excel can automatically highlight the current date in a list

7:11

Put Excel formula results in shapes!

5:52

Make Excel convert text to numbers

7:17

How to calculate weighted averages with Excel

3:24

How to generate a list of random dates in Excel

4:07

Did you know about Excel's database functions?

11:41

Let Excel format cells according to their value

15:26

China's Deepseek AI CRUSHES the Excel test

7:02

Microsoft Copilot AI is now a tool in Excel 365

10:36

Displaying zero values in Excel and Google Sheets

8:28

Excel can convert meaurements for you

6:28

Running SQL in an Excel Worksheet

22:08

Dynamically extract data from cells

10:49

New Excel feature highlights the active cell

3:58

Turn a list in Excel into a diagram using Napkin.ai

14:45

Excel Selection Shortcuts You Must Know

9:38

Cool New Features in Excel Online

16:02

Microsoft Copilot AI and Excel

9:38

Excel's Xlookup Function

9:18

Excel's Language Translation Functions

12:40

Present value in Excel

7:57

Use Excel's Cell function to return metadata about your worksheet

10:39

Regular Expressions functions in Excel

20:00

Desert island shortcuts for Excel

12:47

Excel's New Advanced Formula Environment

13:13

Creating Bubble Charts in Excel

5:37

Creating Excel Pivot Tables from Multiple Tables

11:59

Groupby and Pivotby in Excel

21:16

Testing Google Bard & ChatGPT 4 in Excel

9:29

Automatic Calculations in Excel for Web

5:15

How to use the SCAN function in Excel

5:44

Inserting Checkboxes in an Excel Worksheet

5:41

Excel's What-If Analysis Tools

18:48

Excel’s Sumproduct Function

4:16

Using Python Inside Excel

15:28

Using the Lambda Function

16:21

Using the New Image Function

7:36

Using the Let Function

10:05

Combining Take and Filter Functions

14:02

Drop-Down Lists and Data Validation in Google Sheets

19:22

Comparing Values of Lists

9:43

Excel Formula Bot

11:42

Two Ways of Removing Middle Names From A List

11:20

How to Use ChatGPT in Excel

12:48

Compiling Yes/No Survey Results in Excel

12:02

Installing and Using Excel Add-Ins

11:04

Excel’s secret DATEDIF function

7:39

Creating Automatic Subtotals in Excel

12:24

Using the GoogleFinance function in Google Sheets

13:32

Linking and Embedding Excel into Powerpoint

9:03

Dynamic ranges and print areas with the Offset function

12:08

Dynamically collecting data with the TAKE and DROP functions

9:34

Functions That Generate Random Numbers

7:48

Rearranging columns and rows with TOCOL, VSTACK, and WRAPROWS

6:52

Using the Sequence Function

7:56

Dynamic ranges and print areas with the Offset function

12:08

Formatting Dates in Excel

12:34

HOW TO use the Query Function in Google Sheets

12:23

Split text in Excel using the FILTERXML function

10:56

Linking and Embedding Excel into Powerpoint

9:03

Connecting Excel to Access Database

11:51

NEW Text Splitting Functions in Excel

10:39

Using Power Maps in Excel

22:39

Dynamically collecting data with the TAKE and DROP functions

9:34

Freeze Panes in Excel

6:07

Drop Down Lists in Excel

6:13

Excel Transpose Function - Between the Sheets

5:23

How to Lock Cells in Excel

8:34

Using Excel Online

8:09

How to Add Notes in Excel

9:14

Auditing Worksheets in Excel

17:23

Excel Textjoin Function

11:30

PowerQuery and Live Data

7:46

Understanding the CHOOSE function in Excel - CHOOSE Function tutorial

6:30

Pivot Tables - Between the Sheets

23:06

Unique Function - Between the Sheets

5:15

Miscellaneous Tutorials

Tutorials

9 Videos

Easier and more creative text with Photoshop's new Dynamic Text tool

6:53

Using Photoshop's new Adjustment Brush

11:26

How to create rough or torn edges in Photoshophow to create a rough image border in photoshop

11:56

Adobe Illustrator AI tools: Create Patterns & Fill from Text

15:20

Photoshop AI vs. Midjourney: Which Should You Use?

10:43

How to use the new Select Object tool in Adobe Photoshop 2020

11:40

Adobe illustrator Shape Builder tool tutorial

7:42

How to clean up an email list with Excel

9:35

Built-in mobile screens in Adobe XD

0:16