Cognitive Behavioural Therapy (CBT) is a branch of psychotherapy used by many therapists and clinicians throughout the World.
It’s been around since the mid-1950’s, treating a number of emotional disorders, including Post-Traumatic Stress Disorder and anxiety.
What most people don’t realise however, is that CBT is a highly versatile model that can be used to benefit our everyday lives in many ways.
Here’s just seven things that CBT can help with:
Many of the changes from Excel 2013 to Excel 2016 are particularly relevant to more advanced uses of Excel, particularly for data analysis and visualisation.
There's an old adage in business - Turnover is vanity, profit is sanity but cash is reality. It's very useful to remember that cash flow is the king of your business. Let's look at a method for forming a cash flow forecast.
The holiday period is the perfect time to get to relax and read. So after you've finished reading this post, gone through our Festive Film guide and listened to our Christmas playlist, why not check out some books on this list? From business reading to comedy, sci-fi and crime, see what the EwB office is reading at the moment and what we recommend to relax or engage your brain over the holidays. Happy reading!
Feel that your meetings could be better? We've all been there. Someone's late, or dragging the meeting on longer than necessary, or doesn't even know why the meeting was called in the first place.
If you want to make sure sure that you're spending your time more effectively in 2016, we have some tips to prepare you for smooth and productive meetings from our Communication, Influence and Teams course. If you're not doing all of these already, try them out!
The Excel 2016 course has arrived! Most of the changes in this latest version are far from screamingly obvious. However, there are many very useful and significant improvements, as well as a crucial change in direction, refining the way in which we all use Excel.
Calculating Net Present Value
Ever wonder whether you should invest in a friend’s business idea? What is the mysterious formula against which businesses, from your local corner shop to Apple Inc, are evaluated?
Today we bring you a simple lesson in financial valuation: net present value (NPV). Imagine your friend Emma told you she needs a $350 loan to start a lemonade stand, which will make $50 profit in the first month, $150 in the second month and $200 in the third month, before she has to close down for winter. She will give you her first three months’ profits to pay you back your loan.
Should you make this investment? (Emma assures you that she will pay you those amounts no matter what.) What if she wanted $380?
Making good decisions is a critical skill at every level, whether you’re a parent deciding the best school for your child to attend, a Marketing Director deciding which advertising agency to employ for a particular campaign or the England Rugby captain deciding whether to stick or twist in the dying embers of a crucial World Cup Pool match versus arch enemy, Wales.
Office 2016 is here and with it Microsoft promises to “Take the work out of working together”.
So what does the first major update to Microsoft’s Office apps in three years really give us? On the surface, not a lot has changed. Office is still very much Office, with Microsoft having avoided any potential furore with windows 8-esque functionality changes, but there are some nice additions to make the upgrade to 2016 worthwhile.
So you’re starting your own business and it’s time to think about your vision. Do you think you can solve a problem in a new or unique way? Or maybe you can enable people to do things more efficiently or cheaply? You have almost total freedom to create your business as long as it is based on a service or product that the public needs.
It's been a while since we gave an update on our new courses so this post is long overdue. Over the summer here at EwB HQ, we've been putting together a number of new courses and have some more exciting releases over the next few months. If you are subscribed to an EwB membership plan then you will have access to all our new courses as they launch.
In the 2014 GE Global Innovation Barometer*, 2/3rds of the 3000 Executives surveyed globally believe that they need to encourage creative behaviours in their people to disrupt their internal processes. In the same group 84% agreed that understanding customers better and anticipating market evolutions is a critical success factor in the 21st Century Business.
How can you be equip yourself for this shift in thinking and contribute meaningfully at work?
Today’s best marketers and growth hackers are data-driven. They are able to pull data about their marketing campaigns, and use that data to get a clear picture of what’s working (and what’s not).
A key component of being data-driven is the ability to quickly collect data. For pulling data from customer databases, there are few better tools out there than SQL, and none that are more popular.
SQL is a database language (Structured Query Language) that’s used to pull information from a database. Every action your customers take is captured in a customer database somewhere. Knowing how to use SQL allows you to retrieve just about any data you could ever want to know about your customers.
Excel gives you many options when it comes to filtering your data. If you have a database with numerous entries, you can filter the data so that only the relevant information appears. Then, when you remove the filter, you have all of your data. Built in comparison operators such as “greater than”, “less than”, “between”, “top 10” or even custom filters can show the data you want and hide the rest.
Cognitive behavioural therapy (CBT) is a talking therapy that can help you manage your problems by changing the way you think and behave. It is most commonly used to treat anxiety and depression, but can be useful for other mental and physical health problems.
Some weeks back, we decided to offer 5 lucky users the chance to compete for 12 months free access to our full suite of 40 courses.
This took the shape of an Excel competition. Our course author and world renowned expert Simon Hurst, created an Excel file - filled with design, functionality, grammar, and formulae errors - for the EwB userbase to download and correct. They then submitted their corrections to us.
A few days later upon the competition deadline, we had received circa 100 responses. After some deliberation, we contacted our winners to deliver their prizes. Your submissions were SO GREAT that we couldn't just limit it to 5 winners. There was a tie in the fifth place, so we have 6 lucky winners instead of 5.
In order to spread the love, our Excel champions have kindly agreed to share a bit about themselves for the EwB blog and newsletter. So, without further ado, we give you the winners of our Excel competition:
In this modern world, we can so caught up with getting things done, that we fail to 'be' in the moment, not noticing the beauty of life and how quickly it is passing us by. Mindfulness is a response to this phenomenon, taking control of wandering attention in everyday life.
One of the most successful techniques to achieve mindfulness is to frequently meditate. Meditating can consist of breathing meditation, body scan meditation and sitting meditation.
We take you through four of the main benefits of meditation, that can have a positive impact on your day to day life.
The power of touch is an extraordinary thing, the skin is alive with millions of touch sensors waiting to be stimulated. Human survival and mental health depends not only on nutritional nourishment, but also physical nourishment in the form of skin-to-skin contact. It is a human’s first language. There are numerous studies that prove the benefits of touch for the receiver, one that particularly stands out, as reported in the New York Times, showed that “Premature infants who were massaged for 15 minutes three times a day gained weight 47 percent faster than others who were left alone in their incubators.”
Here at Excel with Business, we pride ourselves in providing the most proficient Excel learning experience there is, through our adaptedonline Excel course, written by our passionate team of Excel enthusiasts.
Today we're giving away free access to ALL of our 38 courses for a year to 5 lucky Excel gurus who can correctly solve the following Excel spreadsheet.
All you have to do is simply download the spreadsheet here, and follow the instructions below to be entered.
1. Copy the 'Original' sheet onto a new sheet on this work book and name it 'Corrections'
2. Correct any errors on the sheet.
3. Improve the design and usability of the overal file. Ensure the information is easy to understand.
HINT: Although best practice would suggest an ideal answer would be spread across several sheets, for simplicity, please organise your suggested answer on a single sheet.
4. Submit your answers by attaching them to an email to: email@example.com. Please use the subject line: "EwB Competition - your name"
Submission closes at midnight (UK time) on Sunday the 14th of June, 2015.
The official Microsoft certification for Office products is now available through Excel with Business in the UK and Ireland. Microsoft call this Microsoft Office Specialist (MOS for short). For Excel and Word there are two levels – Specialist and Expert. For PowerPoint, Outlook, Access, OneNote and SharePoint there is just Specialist level.
In my smash-hit underground book Appillionaires I explained how a generation of dreamers, designers, and programmers made millions on the Apple App Store and how you can too. In the extensive research and interviews that were conducted whilst writing this book, I observed with my ears that many of the people profiled were cagey about their app’s actual revenue numbers, downloads and demographics. They had easy access to this data from Apple’s developer dashboard but felt that this was very privileged information and not to be shared with anyone.
A very useful but often misunderstood technique is HDR or High Dynamic Range Imaging.
Misunderstood - because people are often shown exaggerated, over-the-top or “fruity” versions of this technique. It’s usually seen in painterly, arty or – in my humble opinion – shockingly bad Real Estate photos.
One way of judging the importance of different Excel features is to look through the ‘Must Have’ section of relevant job descriptions. You’d probably be surprised at how often PivotTables appear. The other thing that might surprise you about PivotTables is the extent to which they divide Excel users. I lecture on various aspects of Excel and often need to intervene to stop a mass brawl breaking out between PivotTable supporters and opponents.
The only thing new in the world is the history you don’t know.
- Harry S Truman
You don’t have to look very hard to find information about project failures. You can look through the ‘80s, ‘90s and 2000’s and find examples of projects that have failed. For example, in 2003 Levi Strauss undertook a project to migrate their disparate IT systems to a single SAP solution. The budget was $5M. Right from the beginning there were issues and looking at those challenges now you can see they did not properly define requirements or understand all stakeholder needs. By 2008 the company took a charge against earnings of $192.5M and the CIO was forced to resign because the failures experienced during the switch over to the new solution.
If you’re building a website or an app, you’re probably thinking about how to create the best content and features so that people are attracted to your wonderful creation. But once people arrive on your site or start using your app, it’s important that they are able to do what they want to do with ease. Your site or app may have the most wonderful functionality, content and features on the market, but if people find it too hard to figure out what to do, how to find information, or where to click, they are likely to get frustrated and leave your site or stop using your app. The problems that cause people difficulty in doing what they’d like to do, or confuse them in any way are known as usability problems.
A number of hit games have been created using Unity3D, here are some surprises that you may already be playing.
If you’re like me, then getting your hands on a New DSLR can be very exciting. The comfortable but reassuring weight of it in your hands – the lovely big LCD and array of ergonomically placed buttons…But this excitement can soon wane if you become overwhelmed by the choices and settings.
With the big day just two sleeps away, we bring you part two of our festive feature. Following on from our favourite festive films, this week we share the Christmas songs that our staff love to hear at this time of year.
Photography is omnipresent in our lives today. Those of us with smartphones carry at least one camera with us on a daily basis; those with a passion for gadgetry a few more besides. People are seen snapping photos on every street corner, and Oxford Dictionaries’ word of the year 2013 was selfie.
What’s more, the quality of these cameras is becoming superlative. The Nokia 1020’s camera weighs in at a remarkable 41 megapixels - over double that of my Canon 505D DSLR at home, and enough for a sharp 50-inch printed portrait of any committed selfier this Christmas.
Perhaps because of these developments, few of us take the time to develop our digital photography skills beyond a basic ability to point, shoot and apply a filter on Instagram. When it’s so easy to add polish to average images, why bother?
With the recent release of Kenneth Schultz’s excellent Beginner and Advanced photography courses on Excel with Business, I decided to offer ten quick but important answers to this question.
To celebrate the run-up to Christmas we're sharing a series of Festive Features. This week we share some of our favourite festive films with you:
Range names are a great way to keep your spreadsheets clear, make them quicker to construct and definitely helps when someone else looks at what you have done or audits your work. It really is a basic of business analysis that you should get into the habit of doing.
We take you through named ranges as well as dynamic ranges in our Business Analysis course but today we will just look at how we set up a basic range name using examples from within the course.
Author Harold Graycar takes you through creating and using range names
Do you ever wonder why some logos are more memorable than other? And have you ever looked for hidden messages in popular brands and logos?
I did some research over the weekend – anything to postpone the Christmas shopping – and put together the list below. Enjoy!
As Peter Drucker (the founder of Modern Management) said, “business is nothing more but marketing and innovation”. For now I’ll leave the innovation with you, and help you out on the marketing part. Call it sales, call it advertising, at the end of the day it is nothing more but getting people’s attention and having them know that you exist. All businesses face this problem, especially small businesses, so this article will give you the recipe on how to get more exposure on Twitter. As the title says, it’s all about Twitter Trends.
As much as this might scare you, Facebook knows more about you than you do. And while this might be difficult to grasp at first, the facts are overwhelming. Facebook knows when you’re awake, when you’re online, who your closest connections are and how often you stay in contact. It's aware of what brands you like, what food you eat and what mood you are in. And what it also does that you aren’t aware of, is track these patterns and habits and also influence them.
Test-driven development (TDD) is a software development process, the main principle of which is to write test code before anything else.
The developer is supposed to follow a few guidelines when building an application following this methodology:
Small business owners want access to their numbers wherever they are. They need to be able to do their accounting tasks on the go, throughout the day. Many accounting packages now provide the tools to do basic accounting, such as invoicing, budgeting and basic reporting from any mobile device. These packages may not offer full-service accounting options, but as long as the business owner selects an app that can send useable data to their accountant, mobile accounting on the go is a great solution for small businesses today.
A "Hello, world!" program is a computer program that outputs "Hello, World!" on a display device. It is typically one of the simplest programs possible in almost all computer languages. As such it can be used to quickly compare syntax differences between various programming languages. It is also used to verify that a language or system is operating correctly. The following is a list of "Hello, world" programs in 28 of the most commonly used programming languages.
Sparklines are very small charts that fit within a line of text or a single cell of a spreadsheet. They’re a great way to give your data some context without taking up half the page with various bulky charts. As they are so small, they are typically drawn without axes or coordinates, but rather present the general shape of a trend over time in a simple and highly condensed way.
When building an app many people (myself included) assume that you have to use software specific to the operating system you are planning to launch your app on. For example, if you plan on creating an app for iOS you develop in Xcode using the Objective-C programming language, and if you’re planning on going for Android you programme in Android SDK using Eclipse (which uses Java as the programming language).
What many of us don’t realise is that there are a whole host of alternative tools we can use to build our apps. These tools fall into three categories: tools for non-programmers, tools that use non-native programming languages and coding libraries. Each of these have their own benefits and this post will give you a brief synopsis of each to help you make an informed decision when you build your app.
As part of my role at Excel with Business, I regularly create emails for our marketing campaigns. To do this I use a web design programme called Adobe Dreamweaver. It is a programme that, on the outset, looks extremely daunting – especially if you have never written in code before. As Dreamweaver features in our Web Design course I thought it would be helpful to share a few features of the programme that I find really handy and allow me, a veritable coding novice, to produce some pretty powerful email campaigns.
It’s a joy to work in the customer service department for EwB and I believe one of the main reasons for this is that our customers love us. Imagine having to go about your day knowing 90% of the possible interactions you’ll have are with somebody who has a crush on you. Well, it’s not exactly like that (although our current level of customer service satisfaction averages around 90%), but I like the comparison!
We recently added Basic WordPress to the ever expanding EwB portfolio. Since adding this course we’ve had some people write in asking “Why should I pay for your course when WordPress is free?”
That’s a great question and it deserves an explanation.
ClearBooks is an online accounting software website used by businesses for purposes such as bookkeeping, accounting, invoicing and producing records of the profits and losses of their business.
We used to use a different accounting system when the business was new and on very small scale. As the business grew the need for a more effective accounting system arose and we tried out Clearbooks which so far has proved to be a great choice.
We are an online business and as one of the people responsible for our product (our website) it's important that we test, test, test. Oh, and then TEST some more.
This process in our business, repeated by countless millions in the digital sectors across the world, reminds me of those times when people get up to speak on a microphone, regurgitate the standard "Testing, testing, 1, 2, 3.... is this on" line before looking nervously at the PA guy to sort it out (for which the web comic by Brainless Tales was cute and relevant!).
So if you're thinking of taking either our Web Design course or one of the Development courses we have on offer, this should appeal to you in particular.
While the price you charge for your product or service is a big factor, just as important is maintaining control of your costs to ensure your business stays profitable. In this article we focus on how to properly calculate and track your costs starting with three key items:
The first web page I ever created had a grey background, not because that was "in" but rather because it was the only option available. All the links were blue, again because there was no way to change the colour. And the text was Times New Roman (why, oh why did anyone ever think that was a good idea? Still, anything’s better than Comic Sans).
It was 1996 and I was a college student in Los Angeles. I signed up to take a new course called Web Design without even really understanding what it meant.
All I knew was that I could somehow learn to create designs that would then be visible to anyone with an internet connection and a computer, no matter where they called home or what language they spoke. I didn't have to fax them the pages, or have them printed and shipped. They just appeared... magically... with the click of a button.
To anyone born since then, this isn't a revelation. But to me, particularly as a graphic designer, this was mind-blowing.
Hit games like Monument Valley, Thomas Was Alone and Temple Run (check them out if you haven't already) were all written in a wonderful game engine called Unity3D. The rise of the Unity3D game engine has been phenomenal: in a few short years since its launch, large game corporations and indie game designers around the world have realised the potential of this ingenious piece of software to streamline and accelerate their game-production pipeline; to date there are over two million registered users.
Unity’s magic lies primarily in its ability to export your game to all mobile platforms (including iOS and Android), consoles like the Playstation 3, as well as on the web and desktops. And this is just one of the features of this powerful toolkit.
As I am sure you’ve heard this has been a huge week for Excel with Business. Having revamped our online learning platform we’re excited by the changes and the positive effects it will have on your learning experience. In this blog post I want to very briefly run you through the key changes that we’ve made to improve your training with us.
We’re very pleased to announce that, after 18 months in the waiting, we’ve just launched our brand new Excel with Business website. We’re moving out of our practical two-bedroom apartment into a beautiful, luxury, custom-built beach house. We think you’ll agree that it’s come on leaps and bounds from the previous version and we hope that the new platform makes it easier for you to achieve your training goals.
The new website combines improved usability, a more appealing design and new content (both written and video) for you to peruse. We’ve even got some BRAND NEW courses coming soon for you to get stuck into.
What is a programming language? Amazingly, some people actually believe it’s a separate language that people learn to speak to computers! The point of this article is to clear the misconception of what a programming language is and to help you understand the differences between them.
15 year old Zachary Mustin from Chilton Cantelo School is set to represent the UK at the Microsoft Office World Championships in California.
These days you can get an app for pretty much anything. Whether you’re looking to conquer the western front from the comfort of the 44 bus or track how many miles you ran before work, there’s something for everyone. But when you’re designing an app the first thing you need to ask yourself is: “which platform am I going to design it for?”
Choosing a domain name is one of the first things you’ll need to do when creating your own website. You’d think this would be a piece of cake, but with the web now in its third decade it’s surprisingly difficult to find a truly original domain that hasn’t been thought up already.
Making sure you have a unique name is key. Fail that and people won’t be able to find your website, or associate it with your product or services.
There are a number of sites you can use to search for a domain name. GoDaddy.com, Names.co.uk and Fasthosts.co.uk will all allow you to check on whether your cunning creations have already been thought up, and let you buy the domain once you’ve settled on your favourite. Interestingly, your full domain name must be less than 67 characters in length.
With the World Cup drawing to a close there have been some major talking points triggered on and off the field over the past month; English and Spanish pre-tournament expectations quickly flattened by dismal performances and early group stage exits, Ghanaian duo Kevin Prince Boateng and Sulley Muntari sent home after heated rows over pay, Tim Howard’s heroics, and Germany’s humiliation of the hosts Brazil, to name but a few. However, there has only been one talking point that the 2014 World Cup in Brazil will be remembered for. Yes, you guessed it, Luis Suarez biting the Italian defender Giorgio Chiellini on the shoulder during Uruguay’s last group stage game, which subsequently resulted in Suarez’ four month ban from all football activity.
In this article, we visit the history of our website and how it evolved over the years. From the start to finish, the website has undergone several improvements and changes as we implemented new systems and coding languages throughout time. To learn more about web design, check out our course.
Applying styles to your spreadsheets is not simply a matter of style over substance. Formatting allows you to emphasise and delineate your data, enhancing both its clarity and your presentations. Styles is a tool that allows you to more quickly and easily apply consistent formatting to your spreadsheet using pre-defined formatting ‘styles’.
If I say “Yo”, these days, what do you say? You give me a “Yo” back, of course. Not sure what I am talking about? Stay with me and you’ll find out!
The Yo App is the ultimate success in the fantastic, constantly evolving world of smartphones and tablets applications. This brand new app claims to be “the simplest and most efficient communication tool in the world”, as with a single tap, users can send the word “Yo” to one another – and nothing else. Why would you do that using WhatsApp, Facebook or SnapChat, if that takes you 10 taps or more?
Are driverless cars the future? The world’s tech giants seem to think so.
Major technology players like Google and Apple are pushing ahead with the development of self-driving cars, an industry that Reuters reported to have an investment potential of around $50 billion.
The development of self-regulating vehicles is not a new phenomenon. Car companies have been using semi-autonomous demonstration systems since the 1920’s and 1930’s. Since then various companies have tried their hand at creating fully autonomous cars, vans and motorcycles.
I have always found it very interesting how people express things in a totally different way depending on the language they speak. Ever since I was very young my grandfather wisely suggested learning languages other than Spanish was a good investment in my future. I think he was right. It is only now as an adult that I start to understand how getting me on this language journey at such an early age has definitely been the best thing ever chosen for me. As soon as I turned 17 I left my hometown - Bogotá, Colombia - and stated wandering.
With England making an early exit in the Brazilian World Cup, we’ve been looking for consolation in our data. This little plot shows a measure of how much users from different nations improve in their Excel proficiency through taking our training. The measure of improvement is the average increase in ‘Excel IQ’ between the two tests we offer with our Excel course.
Microsoft Excel was the first successful spreadsheet (an interactive computer application program for organization and analysis of data in tabular form) of its kind back in 1985, an improved version of Microsoft’s failed original spreadsheet Multiplan in 1982.
We hope you're enjoying the World Cup as much as we are. Aside from our Italian Marketing Director skipping through the door on Monday morning, we've been loving all the goals and attacking football thus far. To celebrate, we've selected our ten favourite World Cup moments. As you can probably guess, they weren't all selected by English people.
As we look ahead to the football World Cup kicking off in Brazil next week, we’ve been meditating on our home-nations’ chances, wondering which of the big name players might star, hoping some new genius will burst to fame through their performance, and evaluating whether we need a bigger TV and one of those little fridges for beer that you put next to your sofa.
To escape from this anticipatory meditation, we’ve put together a World Cup Planner spreadsheet to ask you, our users, to make your own forecast – not just of the winner, but of the result and score in every match. It goes without saying we've done it in our favourite Microsoft application – Excel.
We’ll give a £100 Amazon.com gift card to the entrant who gets closest to the actual results – just complete the spreadsheet and email it back to us before the first match on 12 June (5pm in Brazil, 9pm in the UK).
Keep reading to see how it works ...
We’re just a few days from the World Cup! The opening game, on June 12th, sees hosts Brazil take on Croatia.
Whether or not you’re interested in soccer and betting, World Cup odds are an ideal vehicle for conducting some interesting analysis in Excel. In this blog we use Excel to make sense of some World Cup odds, and offer some suggestions on how punters might try to use these to gain an advantage over the bookies.
Lists of Internet tricks and shortcuts vary in usefulness. Some really can save you time and give you new browsing capabilities; some will purport to save your life by showing you how to make Google perform barrel rolls; and some will include a jumbled mixture of the valuable and the ludicrous.
We've compiled a list of eight Internet tricks that will make your browsing more time- (and even cost-) efficient. We may not win the prize for most random number of list-items included in a blogpost – there are indeed some crazy lists out there days; but we simply hope you'll find them useful.
To commemorate our 5th birthday, a few of us in the office decided to write a few words about why we enjoy working for Excel with Business. Although we're still a young business, we all have personal perspectives on the company that are nicely apparent in what is still a relatively small office.
Vic - Office Manager
What I love about EwB is the people; everyone here has such a different story and talent and brings something unique to the team. This is definitely down to the founders being extremely hands on with every aspect of their company. I can’t imagine - no matter how big the company gets - that will ever change.
Paolo - Marketing Director
Mainly coming from experiences within large and established organisations, when I joined EwB in June 2013 I was eager to be involved in and have a direct impact on as many areas of the business as possible - which is the most amazing thing about working for a start-up. The company is (almost annoyingly!) extremely organized, open, dynamic and efficient, and the entrepreneurial spirit of the founders still lies in every decision we make. There are many reasons why I'd recommend to be a part of EwB - one is that we intend to keep growing, and pretty quickly!
Last week, amid much mirth in the heart of Shoreditch, Excel with Business turned five years old!
When young humans turn five they are walking and talking and have just settled into their more formal classroom education, and the analogy holds quite nicely. Here at EwB we've been walking and talking for quite some time, and now know with more certainty where we’re heading and what we need to learn.
Of course we’re not taking our success so far for granted. But it can be motivating on occasions like this for a company to look back and remember the journey it’s been on. On that note, we posed some questions to our three co-founders - Marc, Chris and Vinit - about EwB’s life thus far.
Personal computers continue to grow steadily smaller. But somewhere between the beige desktops of the 1970s and Google Glass today, we decided that we’d missed a step. Having mastered smartphones for the person-about-town, we reversed a little and designed the tablet for the person-left-at-home.
The popularity of smartphones has for years been readily apparent to anybody reading this, even if you are a cat being filmed using a laptop for YouTube (you’re about to fall). More recent is the growing ubiquity of tablets, in particular the iPad; the marketplace for them is exploding. Even if simply to show that they have one, people are increasingly note-taking and photographing monuments with them, often sliding them from their satchels in places that should patently remain the preserve of the smartphone, such as lifts.
However, it’s important to recognise that from an app design perspective, there is a big difference between designing apps for tablet-sized screens and mobile phones.
If you are interested in web design you need to know HTML and CSS. And if you’re new to web design, the two are excellent places to start. Below is a very simple introduction to what the two are, what they each do and, consequently, the differences between them.
Hello, I’m Sam, and I’m the course editor here at Excel with Business. As we look to expand the focus of our blog, I’ve turned my hand to a more light-hearted look at Microsoft Excel.
Excel is, at its heart, a programme that manipulates numbers: so getting your numbers to appear as you want is an important skill. The appearance of a number entered in an Excel cell can be changed in many different ways. This blog post shows you how.
Apps have been a global phenomenon. According to market research firm Gartner, 102 billion apps were downloaded in 2013 (91% of them free) and generated $26 billion, up by 44.4%. An analyst report estimates that the app economy creates revenues of more than €10 billion per year within the European Union, while over 529,000 jobs have been created in 28 EU states due to the growth of the app market. Apps start from just a simple idea, to potential worldwide domination. Below is a list of the top 10 most addictive apps we simply can’t live without.
Microsoft Excel 2013 contains some very important new features, so we have been busy creating a 2013 version and we are pleased to announce that all existing EwB Excel users can now access the entire new Excel 2013 course at no extra cost. To help you undertsand whether, or when, you need to upgrade and how to make the best use of the new version, you can access the course preview on your myEwB page.
Our latest blog post is from guest blogger Al-Chen, Co-Founder at KeyCuts – a range of Excel keyboard covers, which will help you learn the most common Mac Excel keyboard shortcuts used by financial analysts, consultants, and top 10 MBA school students.
Congratulations on receiving your Excel with Business Microsoft Excel IQ certificate. You can now add this to your LinkedIn profile!
Personal computers continue to grow steadily smaller. But somewhere between the beige desktops of the 1970s and Google Glass today, we decided that we’d missed a step. Having mastered smartphones for the person-about-town, we reversed a little and designed the tablet for the person-left-at-home.
Conditional formatting changes the format of a cell dependent on the content of that cell, or a range of cells, or another cell or cells in the workbook. It helps users to focus quickly on important aspects of a spreadsheet, highlight errors and identify important patterns in data.
An Easter egg is an inside joke, hidden message or feature in a work such as a computer program, film or book.
Here are five tips borne of hard hours grafting through messy databases in search of some grains of gold. Sounds like an exaggeration? Think again… or at least have a read first!
We thought we’d write a blog post on one of the most talked-about faces in showbiz at the minute, analysing the trends between bad girl ‘I do what I want’ Miley Cyrus, and the eternal popularity of our favourite Microsoft programme, Excel. Below is a list of 7 things Miley Cyrus and Excel have in common – let us know your favourite!
The majority of us now access our bank accounts online – whether it’s to check our balance, pay bills or consider our spending habits in more detail. Because the data is accessible in this electronic format (most online bank accounts will let you download a statement as an Excel file, or a ‘CSV’ – comma separated variable – file, which Excel can read), it’s more amenable to analysis than a paper statement. It’s quick to analyse your spending and work out where the money’s gone.
‘New year, new me’… how many times have you heard that? Or even said it yourself?
It’s December once again, and it will be Christmas Day sooner than you think. We have created an Excel countdown to make sure you… don’t forget the date!
Some of the most pleasing functions in Excel are those that help to make sense of indigestibly large data sets. One such function, which is great at helping turn data into insight, is SUMIF(): a powerful function that adds up numbers across categories.
Congratulations to Microsoft, celebrating 28 years of successfully running Windows on desktop computers since Microsoft Windows 1.0 was first released on November 20, 1985.
At Red Triangle, Todd Michael Edwards uses Excel to provide training for pilots around the world on planes ranging from regional jets to Boeing 747s. His company’s cockpit mockups, created as Excel worksheets, show diagrams of the switches and indicators.
As the cricket gets under way here in the UK, and Old Trafford simmers in summer sun, down in London we’ve put together a quick ‘innings forecaster’, which predicts an innings total based on the top-order batsmen’s past and current scores.
This month’s post is less technical than usual, focusing instead on some principles that we at Excel with Business apply to formatting our spreadsheets – or, for that matter, Powerpoint presentations.
At Excel with Business we have always praised the benefits of Microsoft Excel, but we never thought spreadsheets could take you this far.
At EwB, we love to hear about other small, closely-knit startups doing well. So, when we were looking for an SEO (Search Engine Optimisation) tool, WooRank were immediately intriguing.
It all started just under a month ago, when Microsoft PR executive Frank Shaw expressed his doubts about Apple’s latest iWork app: “Helping folks kill time on a tablet is relatively easy. But helping people be productive on a tablet is a little trickier.”
In a recent post we looked at how to highlight differences between sets of figures in Excel, a useful technique to spot errors. This month we put this trick to a different use, alongside some other tips that will help you produce error-free work.
Simon Hurst is a Chartered Accountant and has been involved in computer software for 26 years, during which he has provided a wide range of training services to professionals of all levels. His expertise lies in all the main Microsoft applications: Access, Word, PowerPoint and Excel, about which he speaks frequently at conferences. He is also a prolific writer and published Excel author, contributing Excel articles to many websites and publications.
Inconsistencies can creep into spreadsheets for a range of causes: data-entry errors; accidental changes made to the data after entry; inconsistently applied rounding or changes to units; or differences in the way numbers are formatted in different systems. The following is a simple technique which can help you spot mistakes or inconsistencies in a spreadsheet very quickly.
We have all experienced the classic slow down, freezing, and those dreaded words “Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience.” This month we describe a few ways of reducing the chance of this happening, and minimising the consequences if it does.
There is a lot of talk surrounding “cloud” applications these days, and perhaps the hype has passed you by, leaving you thinking, “Why should I join the cloud?”
Tip of the month – also useful in forecasting. Average percentage growth tells us how fast something has grown, and eventually forecasts the future through extrapolation.
We often have an ordered list of items each with an assigned value such as revenue or cost which we need to analyse and understand. It is sometimes important to know how these numbers are adding up in order that we can be alerted to business limits (budgets, deadlines etc,) being approached or reached.
It’s always encouraging to hear positive feedback so we were, of course, very excited to speak to Hayley at the start of 2013, who had completed our App Design course last year. Hayley and her mother have subsequently pulled together and managed a team who have launched SymbolSmash – an iPhone app that is after our own hearts, delivering educational content via a technology platform! SymbolSmash takes children on a step-by-step interactive, musical, storybook adventure to introduce them to classical music as well as helping them to learn a whole range of skills.
Getting bogged down in Excel? Our Keyboard Shortcuts could Ctrl-S your day! Feel free to check them out, and don’t forget to (↓) to let us know how you got on.