|
Excel Scratch
It's amazing. Half the year has already passed and we are in the midst of Summer 2016. I remember when I was younger, summer vacation felt like ages. That time was filled with vacation trips, growth spurts (very few) and ice cream. Today, time passes by so quickly. Perhaps that is why I register certain activities more than I use too. I take more photos, videos and jot down thoughts. Perhaps it's a way to capture a moment that will fly away but I can relive again. When you consider these mediums (i.e. photo, video etc.) they are all data points. Information about a particular point in time. The same way summer memories are important is the same way data in business is important. Reliving historical data can give us insights, provide enjoyment and growth just like our summer days. It's amazing...analytics is all around us. Happy Summer!
Excel at Work. Excel at Business. Excel.
-Othniel
|
Whitepaper: The Dark Side of Data
In our latest whitepaper we discuss the perils that lie inside data. It's important to keep in mind the way data can be misused and abused. Only then can data truly tell a compelling, true story.
Read WhitePaper
|
Moving Pictures: Change Formula
One of the most powerful components in Excel are the formulas and functions. A good handle in this area can reap tremendous benefits. In this short video show how to construct a formula to determine the percentage change.
Watch Now |
Around the Web: Big Data in Excel? 'Bad Idea' IBM's Top Tips For Managing Analytics Projects
When I came across this article, I must say I was shocked. Excel truly has been ridiculed far to long. Everyone knows that I am a huge fan of Excel. With every new version of Excel the treasure chest of tools keeps accumulating wealth. Read this article and let me know what you think. Is she right? What are the assumptions of this argument?
Visit Webpage
|
Community News
Career Opportunity Spotlight
As part of our commitment to our subscribers, we would like to share an exclusive job opening. As you may have guessed, this position requires stellar Excel skills. Here is a little info about the position:
Company Profile
Hersha Hospitality Management is an industry-leading and growing hotel management, investment, and development firm that provides turn-key management solutions to hotels across the United States. HHM manages world class brands in the select service and full service markets as well as a collection of independent, boutique hotels in key markets.
Accounting Clerk
The Accounting Clerk duties will include a variety of duties, which may include verify, obtain approvals and pay invoices, bill and collect outstanding revenue
Responsibilities:
- Prepare cash discrepancy reports
- Retrieve and process deposits in accordance with hotel standards
- Maintain house bank
- Issue and redeem cashier banks and conduct audits as needed
Qualifications:
High School diploma
Previous accounting experience or equivalent training
To apply, please submit a resume and a letter through the website. Please mention Excellent Ones Consulting in the email.
Have news to share in this newsletter? Email us at info@ExcellentOnes.com.
|
The Store: The Power of Pivot Tables
I often meet people who need a crash course in Pivot Tables. Perhaps for a new job, labor intensive project or request by superior. What are they? Why do I need them? How can I quickly learn it? We are now sharing an online format to our monthly live workshops. This online format includes video presentation, PowerPoint slides and hands-on exercises for Finance/Accounting professionals. This materials equates to an hour of focused instruction broken down into bite size pieces. We cover best practices, common pitfalls and questions from previous participants. The cost is $50. If you are interested in purchasing this tutorial please email us at: Info@ExcellentOnes.com
|
|
