Purchase any Event and get
20% Off
CODE: TWENTY20
T&C applicable, please referFAQ
Validity : 16th Dec'24 to 26th Dec'24
Excel Number Formatting (on Steroids)
- Number formats
- Learn the meaning of many symbols such as #, 0, @, ;, [color], *, parentheses, formatting dates and times, and more
- Shortcuts for number formatting
- Various underlines, borders,
- Using styles to make work easier
- Text boxes
- Shapes
- Aligning cell contents
- Aligning objects
- Distributing objects equally
- Z-order of objects
- How to make an object be on “top” of another or behind it or in the middle or 3 objects, etc.
- Screen captures
- Explanation of themes
Overview of the webinar
A session on Excel formatting typically encompasses a range of techniques and tools designed to enhance the visual appeal and readability of spreadsheets. The session starts with basic formatting principles, such as adjusting cell styles, fonts, colors, and borders to create a clean and organized look. Participants learn how to utilize the format painter to quickly apply consistent styles across different cells and ranges.
The session then delves into more advanced formatting features. This includes conditional formatting, where users can highlight cells that meet specific criteria, making it easier to spot trends and anomalies. You will learn how to create custom number formats to display data in various ways, such as currency, percentages, or dates, tailored to specific needs.
Attendees also explore the use of Excel's built-in table styles, which offer predefined formatting options that automatically adjust as data is added or removed.
Tips and best practices for maintaining consistency and ensuring accessibility in spreadsheet design is shared. By the end of the session, participants will have a comprehensive understanding of how to leverage Excel's formatting tools to create professional, easy-to-read, and informative spreadsheets.
Who should attend?
Anyone who uses Excel needs to be able to make their work more efficient. So, this course is for
- All Excel Users!
Why should you attend?
Attending a session on Excel's formatting is essential for anyone looking to enhance their data presentation skills. Excel's powerful formatting tools enable users to transform raw data into visually appealing and easily interpretable spreadsheets. Mastering these techniques can significantly improve productivity by making complex data sets more readable and professional. Moreover, understanding advanced formatting options, such as conditional formatting, custom number formats, and data visualization features, allows for more effective data analysis and decision-making. These skills are invaluable in any professional setting, from finance to marketing, where clear and concise data presentation can lead to better insights and outcomes. Overall, an Excel formatting session equips you with the tools to make your data stand out and communicate more effectively.
Faculty - Mr.Bob Umlas
Bob Umlas worked for a major tax and accounting firm, using Microsoft Excel® 8 hours a day, writing custom applications for staff and clients from 1998 to 2018.
He has been using Excel since 1986 - version 0.99 (on the Macintosh)! He was a contributing editor to Inside Microsoft Excel for many years, a magazine devoted exclusively to Microsoft Excel and published by The Cobb Group and later Ziff-Davis. At the time, most issues contain either an article by Mr. Umlas on using VBA (Visual Basic for Applications) or some tip or technique from him on using Excel. He has had more than 300 articles published on subjects ranging from beginner to advanced macros, and on tips, shortcuts, and general techniques using virtually all aspects of Excel.
Mr. Umlas was voted an “MVP” (Most Valuable Professional) by Microsoft each year from 1994-2018 (25 years!) for his contributions to the various online Forums about Excel and is known world-wide for his contributions in Excel. As an MVP, he met yearly with his fellow-MVPs at Microsoft’s headquarters in Redmond, where he had access to the product developers. He has been a beta tester for new versions of Excel since version 1.5, and was asked by Microsoft for his input for newer versions of Excel. In 1995 he led a session called "Maximizing Excel Development Using Array Formulas" at Microsoft's Tech Ed Conference in New Orleans, and he led a session called Tips and Tricks at a Microsoft convention in New York City. He has hosted London’s Global Excel Summit each year since 2021, and in person in 2024, as well as led a session on tips and tricks. He also led a session on tips and tricks at the Las Vegas’ Financial Modeling World Championship in December, 2023. He has led online sessions all over the world including Africa, India, England, Canada and of course, the USA.