Excel | Shem Opolot

top of page

This site was designed with the

website builder. Create your website today.Start Now

Search

Freezing panes in Excel

Freezing panes in Excel

Freezing panes in Excel

Shem Opolot

Jul 25, 20221 min read

AutoSum went to London

AutoSum went to London

AutoSum went to London

Shem Opolot

Jul 11, 20221 min read

Import data from a picture into Excel using your phone

Import data from a picture into Excel using your phone

Import data from a picture into Excel using your phone

Shem Opolot

Jul 4, 20222 min read

The right way to number your lists

The right way to number your lists

The right way to number your lists

Shem Opolot

Jun 27, 20222 min read

Presenting attractive tables in your reports

Presenting attractive tables in your reports

Presenting attractive tables in your reports

Shem Opolot

Jun 20, 20222 min read

Pose for a picture in Excel

Pose for a picture in Excel

Pose for a picture in Excel

Shem Opolot

Jun 15, 20222 min read

Remove rows with blanks

Remove rows with blanks

Remove rows with blanks

Shem Opolot

Jun 6, 20221 min read

Replace blanks spaces in seconds

Replace blanks spaces in seconds

Replace blanks spaces in seconds

Shem Opolot

May 31, 20221 min read

Guinness World Record for the fastest way to create a chart

Guinness World Record for the fastest way to create a chart

Guinness World Record for the fastest way to create a chart

Shem Opolot

May 24, 20221 min read

Calculate your simple loan payments

Calculate your simple loan payments

Calculate your simple loan payments

Shem Opolot

May 17, 20221 min read

15 Excel Shortcuts you should know

15 Excel Shortcuts you should know

15 Excel Shortcuts you should know

Shem Opolot

Apr 4, 20222 min read

Top 3 time-saving techniques in Excel

Top 3 time-saving techniques in Excel

Top 3 time-saving techniques in Excel

Shem Opolot

Mar 28, 20222 min read

VLOOKUP: in depth

VLOOKUP: in depth

VLOOKUP: in depth

Shem Opolot

Mar 21, 20223 min read

Spreadsheets for planning a movie night

Spreadsheets for planning a movie night

Spreadsheets for planning a movie night

Shem Opolot

Mar 7, 20222 min read

Sum across multiple Sheets

Sum across multiple Sheets

Sum across multiple Sheets

Shem Opolot

Feb 28, 20223 min read

Real work problems: Custom formatting for better reports

Real work problems: Custom formatting for better reports

Real work problems: Custom formatting for better reports

Shem Opolot

Feb 14, 20224 min read

Building a Yearly Calendar III

Building a Yearly Calendar III

Building a Yearly Calendar III

Shem Opolot

Nov 22, 20214 min read

Building a Dynamic Calendar II: Let's go on DATES

Building a Dynamic Calendar II: Let's go on DATES

Building a Dynamic Calendar II: Let's go on DATES

Shem Opolot

Nov 15, 20212 min read

Build a Dynamic Calendar: Part 1

Build a Dynamic Calendar: Part 1

Build a Dynamic Calendar: Part 1

Shem Opolot

Nov 8, 20212 min read

Can you do a split?

Can you do a split?

Can you do a split?

Shem Opolot

Nov 1, 20213 min read

bottom of page