www.mrexcel.com
Open in
urlscan Pro
216.92.17.166
Public Scan
URL:
https://www.mrexcel.com/
Submission: On September 06 via manual from AU — Scanned from AU
Submission: On September 06 via manual from AU — Scanned from AU
Form analysis
0 forms found in the DOMText 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