www.mrexcel.com Open in urlscan Pro
216.92.17.166  Public Scan

Form analysis
0 forms found in the DOM

Text Content

 * Home
 * Message Board
 * Excel Speaker
 * Bookstore
 * Excel Tips
 * News
 * Resources
   * Excel Mall
   * TechTV
   * Challenges
   * Learn Excel
   * Archive
 * About
   * About MrExcel
   * Authors
   * Consulting
   * Media Kit
   * Media
   * Contact Us
   * Terms of Use
   * Privacy Policy
   * Cookies Policy
 * Search

--------------------------------------------------------------------------------

 * 
 * 
 * 
 * 



BILL JELEN

MrExcel

--------------------------------------------------------------------------------

Explore MrExcel.com

A wealth of Excel knowledge at your fingertips...

UPCOMING EVENT

--------------------------------------------------------------------------------

Financial Modelling Summit
FINANCIAL MODELLING SUMMIT - 10/05/2022

More Events »


MASTER EXCEL BUNDLE

from Bill Jelen



Excel contains over 450 functions, with more added every year. That’s a huge
number, so where should you start? Right here with this bundle.

EXCEL DAILY NEWS

with Bill Jelen

POWER EXCEL NEWSLETTER

Subscribe for Excel Tips »
1 - 2 times per month




SORT PICTURES WITH DATA

--------------------------------------------------------------------------------

September 5, 2022 - by Bill Jelen

Problem: My manager wants me to add employee pictures to the department phone
list. I need the pictures to sort with the data.

Strategy: By default, this will work. Each picture has a property that will
cause it to move but not size with cells. To see the property, select the
picture and press Ctrl + 1. There are 16 categories in the left bar of the
Format Picture dialog. Near the bottom, choose Properties. The Move But Don’t
Size with Cells should already be selected.



continue reading »




MORE READING

--------------------------------------------------------------------------------

The DOSE for Excel Add-In »

September 3, 2022 - by Bill Jelen

--------------------------------------------------------------------------------

The DOSE for Excel Add-In adds Dozens of Excel Features for About US $30

Sort All Red Cells to the Top of a Report »

September 2, 2022 - by Bill Jelen

--------------------------------------------------------------------------------

I’ve read through a 20-page report and marked a dozen cells in red. I need to
audit those records and would like to sort the red cells to the top of the
report.

Sort a Report into a Custom Sequence »

September 1, 2022 - by Bill Jelen

--------------------------------------------------------------------------------

My manager wants me to sort a report geographically. My annual report typically
lists results from the United States first, then Europe, and then Australia. I
need to sort so that the countries appear as United States, England, France,
Germany, and Australia.

read more articles »


FEATURED PRODUCTS

--------------------------------------------------------------------------------

Guerrilla Data Analysis Using Microsoft Excel - 3rd Edition

May 2022

Two of the leading Excel channels on YouTube join forces to combat bad data.
This book includes step-by-step examples and case studies that teach users the
many power tricks for analyzing data in Excel. These are tips honed by Bill
Jelen, "MrExcel," and Oz do Soleil during their careers run as financial
analysts.

--------------------------------------------------------------------------------



Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)

April 2022

Use this guide to automate virtually any routine Excel task: save yourself
hours, days, maybe even weeks. Make Excel do things you thought were impossible,
discover macro techniques you won't find anywhere else, and create automated
reports that are amazingly powerful.

--------------------------------------------------------------------------------



Advanced Excel Techniques - Online Course

January 2022

Understanding data is crucial, and the easiest place to start is with Microsoft
Excel. In this guide, I've compiled advanced skills and formulas in Excel that
you should know to analyze and understand your data easier and faster.

--------------------------------------------------------------------------------



Ace Your Job Interview Where You Have to Know Excel - Online Course

January 2022

You have a job interview this afternoon where you have to know Excel? This short
video course will teach you enough Excel skills to get through the interview.

--------------------------------------------------------------------------------

see more products »

FEATURED PRODUCT

Guerrilla Data Analysis Using Microsoft Excel - 3rd Edition



MREXCEL.COM DEBUTED ON NOVEMBER 21, 1998.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on
this web site are provided "as is" and we do not guarantee that they can be used
in all situations.
This site contains affiliate links. Any affiliate commissions that we earn when
you click a link to Amazon or other sites is reinvested in keeping MrExcel.com
running. You can earn a commission for sales leads that you send to us by
joining our affiliate program.

View our Privacy Policy, Cookies Policy, and Terms of Use.
"Do not share my Personal Information"

Excel ® is a registered trademark of the Microsoft Corporation.

MrExcel ® is a registered trademark of Tickling Keys, Inc.

All contents © 1998 - 2022 MrExcel Publishing | All rights reserved.


X