iTeachXL

11/02/2022

It’s tomorrow!

❗Mark the 3rd of November, 8:00 AM (London Time) not to miss exciting battles between the last 32 and ultimately the last 16 participants of the Microsoft Excel World Championship!
Join the livestream: https://youtu.be/0G8umOnbwFE

In our second livestream session of this Championship, you will have the opportunity to follow the case-solving strategy of 8 skillful players:

Michael Clarke vs. Steyn Wolmarans
Alfons Oliver Altes vs. Willem Gerritsen
Anup Agarwal vs. Matthew Fried
Liam Bastick vs. Ryan Bains

Hosted by Tim Heng and Danielle Stein Fairhurst!

🗓️ All participants will fight for a place in the Grand Final, which will be streamed LIVE on November 12 at 5:00 PM (London time).

P.S. London Daylight Saving time ended on October 30, and now London is 1 hour back. Check your local time, not to miss the event!

10/17/2022

Happy Spreadsheet Day!

Balance your budget, prepare lists, and organize every corner of your life simply by using spreadsheets, a tool used by individuals and large companies alike.

09/05/2022

Did you know...its easy to split up a column into 2 or more columns. For example, if you have a column with City, State separated by a comma, just click the Text To Colum icon on the Data tab. Then, select Delimited and Comma in the wizard and that 1 column has now become 2

08/21/2022

Did you know...you can find the file location where your unsaved Excel files are automatically saved, so you can easily recover them ? On the File tab, go to Options and in the Save section, find the "AutoRecover file location:" We advice you take a screenshot, or write this location down, so next time you need to re-boot, you can easily locate where your work resides.

08/15/2022

Did you know...you can Sort Left to Right, as well as Top to Bottom...it's easy: select your list, hit the Sort icon, and Options... from there, select the Sort left to right option and hit OK .

Contact us for Excel help

08/12/2022

Did you know...it's easy to se two Excel files side by side...on the View tab, select the View Side by Side icon, a window will pop up where you can select another file. If you also select Synchronous Scrolling, comparing row by row will be easy!

Contact us when you need Excel help.

08/11/2022

Did you know...you can quickly create a list of numbers...Select a cell with your starting number in it, and on the Home ribbon, select he flash Fill icon, and the Series option. Set a step value and Stop value, and click OK.

08/10/2022

Did you know...right click on the bottom right of the screen, to display SUM, AVERAGE, MIN, MAX or many other results for a column, row or range of cells you have selected.

Contact us for more tips, training or advice on handling your Excel files.

01/13/2022

Glad to be a provider to this library

WE'RE A 5 STAR LIBRARY!!! The PJFL has been named by Library Journal one of America’s Five Star Libraries for Public Library Service in 2021! We couldn't do it without our amazing community and all their support. THANK YOU!

03/02/2017

The STEM Challenge was inspired by President Obama’s “Educate to Innovate Campaign.” Nearly 5,000 middle and high school youth registered for the 2016 competition.

06/25/2016

Great blog on Power BI a tool we use quite a bit here at iTeachXL

Ready to get started? Excellent! Here’s some fantastic news! Power Pivot (and the rest of the desktop Power BI suite) ranges in price from FREE to VERY INEXPENSIVE, depending which version of Excel you are running. Yes, there are multiple versions of Power Pivot, but we will make that all clear an...