Easy and Free Video Editing

Need to create Videos for Work?

Many people agree that the current health crisis may well have changed working patterns permanently, with more people working from home, even after lockdown ends. Because of this, many organisations are looking at creating company videos that can outline company procedures or systems.  We here at Infero recently came across a video editor that can do most of things that a professional video editor can do, but is entirely free.

Shotcut User Interface

Shotcut

Shotcut is a free, open source, cross-platform video editor and supports hundreds of audio and video formats. It offers many standard video editing features, and with a little practice is not that hard to use

Shotcut can be downloaded for free and is available in a portable version, that can be run without being installed. It is also available for Windows, Linux and Mac operating systems. Unlike many video editors, it’s a small download of only 184MB. It is updated fairly regularly, even though it is an open source app, and the first time it is run the app checks if you’re running the latest version.

https://shotcut.org/download/

Interface

Shotcut’s interface is sparse when first opened. On opening a video file and click the timeline button, however, you will see source clips in a panel at top left, a preview window at the top right, and the timeline along the bottom. The panels are undockable, allowing the interface to be customised, especially useful if using multiple monitors.

There are three interface colour themes: dark, light, and system.

Shotcut can do most things from Basic Joining and Trimming, creating transitions between video clips and also adding Text to videos

To apply effects to videos, open the Filters panel, hit the plus sign, and choose an adjustment; lighting and colour, for example), filter. Other filters include Opacity, Colour Grading Blur and five Old Film effects. A  Rutt-Etra-Izer filter creates 3D extruded distortion from a video image.

Shotcut will even produce a Picture-in-Picture (PIP) effect for your videos PIP is considered a filter. The tool provides handles for resizing and moving the picture in picture.

Titles and text can be added, and as with other effects in Shotcut, these are also considered Filters. There is even a 3D Text option, with five font choices, something not normally available in a free application.

Adding Text

  • Select the video track you want to caption.
  • Click the Filters tab at the top left of the timeline
  • Type “TEXT” into the search box. then choose one of the three options: Text 3D, Text Simple and Text HTML

Fix out-of-sync audio

It is annoying when picture and audio in a video aren’t in sync. This is easily rectified in Shotcut:

Right click your clip on the timeline and select Detach Audio. This drops the audio on to a separate timeline where you can drag it independently of the video until the two are in alignment. (If you cannot see the detached audio, expand your timeline so it is visible.) For precise adjustments, zoom into the timeline using the slider.

Although there is not any help documentation as such, the Shotcut site has a number of video tutorials available. We suggest you start with the introduction video that is available here:

https://shotcut.org/tutorials/

There is also a lot of help documentation available for Shotcut at: https://guides.lib.uoguelph.ca/Shotcut.

Essential Ergonomics Tips for Remote Workers

Under the law, Employers have the same health and safety responsibilities for home workers as for any other workers. Whether the home-working is permanent or temporary, there are some areas an employer should consider:

Working with display screen equipment

Those working at home on a long-term basis must be risk assessed for using Display Screen Equipment (DSE) which includes them doing workstation assessments at home.

For those working at home temporarily, home workstation assessments do not necessarily need to be done.

Employers should, however, provide workers with advice on completing a basic assessment at home. The HSE provides a downloadable workstation checklist here: https://www.hse.gov.uk/pubns/ck1.pdf

There are also simple measures that can reduce the risks:

  • Breaking up DSE work with rest breaks (at least 5 minutes every hour) or change the work activity if possible.
  • Regularly change whilst working and don’t remain static.
  • Periodically move around and try stretching exercises
  • Changing work activity focus and blink to avoid eye fatigue.

There is more help from the Chartered Institute of Ergonomics and Human Factors for people working at home here https://www.ergonomics.org.uk/common/Uploaded%20files/Publications/CIEHF-Working-from-Home-Infographic.pdf

Specialised DSE equipment

If employees have specialised DSE needs, Employers should meet these where possible.

Workers can be allowed to take equipment, such as keyboards, mouse, riser etc. home.

If a worker normally uses items such as ergonomic chairs or height-adjustable desks, try other ways of having a comfortable working environment, such as supporting cushions.

Reviewing DSE arrangements

If temporary home working extends, regular discussions should be had and, assessments made and additional steps put into place if required. Areas that should be checked include:

  • Developing aches, pains or discomfort related to temporary DSE arrangements
  • Possible adverse effects of isolated working
  • Employees possibly working longer hours without adequate rest and breaks

If home working is made permanent for an employee, the full responsibilities of an employer under the law come into effect and full workstation assessments need to be done, with workers provided with appropriate equipment and advice.

Reviewing DSE arrangements

Workers may be using tablets and smart phones at home. These, too, have ergonomic issues and areas that need to be considered:

  • Texting and other small-screen use can be stressful on the thumbs. Limit this to no more than 10-15 minute sessions.
  • As with other DSE equipment, stretch often when spending extended time on a device.
  • Posture should be thought about. Use something to support your arms and don’t hold them aloft for long periods. Don’t maintain a bent-neck posture.

Other areas may need to be considered when assessing home working ergonomics, including lone working and stress and mental health.

How to Get a Job in Project Management

If you have excellent communication skills and a gift for organisation, project management could be for you. It might be something that you have always thought about, but just how do you get started?

 

What is a Project Manager?

 

Project managers oversee processes from start to finish. They are essential to the smooth running of an organisation and can work in a variety of sectors, from business and construction to IT, marketing and retail. Project managers ensure projects are delivered on time and to budget, by planning and organising resources and people.

 

It is possible to become a project manager, even if you haven’t previously worked in a similar role. You may already have some of the skills required. Many of the attributes needed to be successful in project management, such as leadership and time management, may be things that you have acquired in previous work or education. Any experience leading and organising the activities of a team will be valuable.

 

This could include things such as the completion of a successful project at university, a new initiative you manged in a previous role, or leadership of a team or club outside of work could potentially show off your project management skills. Even planning an event such as a charity evenings or weddings, may be useful.

 

What skills do Project Managers Require?

 

The skill set you start with is important, but it is important to improve your knowledge of project management processes, techniques, frameworks and tools, and develop the right soft skills required.

 

– Time management – it’s important to be skilled in managing your own workload, as a project manager must prioritise and delegate tasks for others successfully.

 

– Organisation – A project manager organises the work of others, so cannot be unorganised themselves. You’ll be responsible for setting goals, managing meetings and tracking the progress of a project.

 

– Communication – Much of a Project manager’s time is spent liaising with others. You need to clearly state ideas, goals and project issues to a variety of people; in written form with reports and verbally in meetings and presentations. Good listening ability is also essential.

 

– Negotiation – As a Project manager you may need to work with teams with competing interests to negotiate resources and schedules.

 

– Risk management – Identifying and managing risk is extremely important. Being able to predict and create solutions to problems before they arise may be the key to delivering projects successfully.

 

– Leadership – You have to lead your team, as well as just manage their activities. You need to be able to inspire and motive your colleagues.

 

Project Manager Entry Level Positions

 

Even when you have worked on the skills that you require to become a Project manager and have some experience, it is still the case that many Project Management positions will still not be attainable.

 

It may be the case, however, that there are entry level positions that could require little of no experience to get started such as Junior Project Manager, Project Assistant, and even Product Assistant. These allow you to building your experience up while you work, gain more knowledge and perhaps complete a Project Management qualification.

 

Project Management Courses

 

It is not a requirement for being a project manager that you have Project management qualifications.  It is not even necessary that you have knowledge of the area that you are project managing to be able to successfully complete a project, although it definitely helps and , for more specific project management roles, such as those in engineering or IT, subject knowledge is more important.

 

Whatever route you take into Project management, it is the additional knowledge gained through professional qualifications and short courses that will help you to progress as a project manager. And you will not always have to complete these qualifications before finding employment, as the many employers will fund these as on-the-job training.

 

Courses are available in the various project management methodologies, such as:

 

PRINCE2 – A structured methodology, commonly used for end-to-end project management. Courses are available at foundation, practitioner and agile level. Foundation courses are suitable for new recruits with a basic knowledge of project management processes.

 

AGILE – Suited to environments such as IT, where there may be constant change, as the methodology uses short development cycles to focus on continuous improvement in the development of a product. Training is available at foundation and practitioner level.

 

Industry certification can also be gained through the Association of Project Managers (APM) and the Project Management Institute (PMI).

 

Common Project Management Interview Questions

 

To make sure you’re well prepared for a job interview read our previous blogs on preparing for a Job Interview here http://wp.me/piy8w-Cb and here http://wp.me/piy8w-Cr.

 

Also pre-prepare your responses to these specific, common project management interview questions:

 

  • What project management methodologies are you most familiar with?
  • What are the most important qualities of a project manager and why?
  • How do you plan a schedule for a project?
  • How do you allocate resources?
  • How do you ensure your team stays on track to meet project deadlines?
  • How do you motivate a team?
  • Two key stakeholders have opposing views. How do you manage this?
  • What did you find most challenging about your last project?
  • What is the most complicated project you have managed? How did you handle it?
  • What was your most successful project?

 

It is entirely possible that you can achieve your goal of a job in Project Manager. Infero Training delivers course in PRINCE2 and in Microsoft Project.

Microsoft Project

Project

 

It is possible that you have heard of Microsoft, but have never used it. In this article, we set out its capabilities.

 

Project is the world’s most popular project management software. It was Microsoft’s third application, with its initial release in 1984. It is part of the Microsoft Office family but has never been included in any of the Office suites. There are two editions of Project available, the standard and professional versions. There are also web apps and an online version that can be used.

 

Project managers can use it to develop plans, assign resources to tasks, track progress, manage budgets and analyse workloads. Perhaps its most useful feature it the ability to see a project in a number of different views.  A View in Microsoft Project is a representation of data in the form of table and graph.

 

Essentially, the project can be viewed from different perspectives and representations, all from one platform. These views can also be customized providing particular solutions for specific projects. In the latest versions there is even a Board view, that looks like a traditional Kanban board.

 

The default view is the Gantt Chart view. This has two sections; a Table on left hand side and Graph on right hand side. Traditionally a Gantt Chart contains Tasks names, tasks duration, start and finish dates and a bar chart drawn to show the tasks duration over time.

 

There is also a Network Diagram view, a Team Planner view, a resource usage chart view, a calendar view, and many, many more.

 

Microsoft Project helps planning and scheduling, by allowing the definition of project tasks and setting the prioritisation of these. A Timeline view can be added to identify important tasks and Milestones in the project.

 

Project has extensive reporting facilities, allowing complex and detailed reports to be generated very easily. As well as built in reports, it provides the facility to create custom reports that meet your own organisation’s requirements. Reports include burn down reports; an overview of the entire project on one page; the conditions of available resources and their utilization; a cost overview; a list of pending tasks; and a list of targets achieved and upcoming goals.

 

There are a number of tools in project that allow effective resource management, allowing the tracking and monitoring of available resources. Project also allows the assignment of costs to individual resources, and check if certain resources are being overused or underused. Tasks can be correctly assigned to match resource availability. A Resource Pool can even be created that can be accessed by multiple projects.

 

Smaller projects, being looked after by different teams can be merged together into a Master Project, but still exist as separate entities, allowing a lot of flexibility on how the projects are managed, whilst still showing how smaller projects fit into a larger overall Project.

 

Project is a very flexible tool that is extremely useful for project management. It is also quite simple to master. Infero Training offers courses in Project at all levels. Click here to find out more:

 

https://www.inferotraining.com/course/project-courses_c_58_64.html

 

Part 2 – Delivering in the Virtual Classroom

InkedVirtual Training-Infero-Training

 

When delivering Virtual Classroom Training, it is important to remember that just because something works in normal classroom training, it does not mean that it will also work in online training. Not only does material need to be adapted for the online setting, but trainers too need to adapt their delivery, their training methods and the whole approach that they take.

 

Engaging a remote audience is entirely different from engaging one face to face and many of the visual clues that trainers normally make use of will not be available. In some Training sessions, there may be long periods when you cannot see or hear your audience.

 

A virtual Classroom Trainer should be able to type quickly and communicate clearly and concisely.
They should also be patient, as virtual classrooms produce lags in communication. This means allowing pause time for people to connect, or type answers.

 

Virtual Training is a skill that can be learned, like any other, but these are some of the things that you should consider.

 

Final Preparation

 

  • Be prepared for anything that can happen with the technology and equipment and have plans in place. Practice with the learning platform and record yourself to review how you are doing. Be confident and sure of yourself.
  • On the day check everything again. Enter the virtual classroom early and check the connection and audio. Invite trainees to join the training 10 minutes early to “live check” audio and visuals.
  • Make ‘eye contact’ by looking straight into the camera, not down at any notes. Have an interesting but not distracting background. Practise, practise, practise!

 

Keep Trainees Engaged

 

  • In all training, learners should be involved. This is especially true in a virtual Classroom; don’t talk at attendees, talk with them, engaging them in the conversation. Do this right at the beginning of the training, so that delegates feel comfortable from the start.
  • Use Ice-Breakers: If it fits and especially in a long session, start with an interesting ice-breaker.
  • If possible, and taking into account bandwidth and screen space, ask people to switch on their camera. Do this at least at the start of the training. This will help both you and your delegates to settle and massively help interactions.
  • Get to know the students as much as possible and note names at the beginning of the session, so that you can call on them individually during the training.
  • Use Interactive learning activities that involve the participation of everyone. Exercises. Discussions. Games.
    Within the limitations of the Platform that you are using, try to make slides as interesting as possible. Avoid bland, over-wordy slides.
  • Make it relevant by asking how the subject matter relates to trainees, either personally or professionally. Ask Interesting and Thought-Provoking Questions.
  • Limit Chat Moderation: It is good to limit cross-talk during a presentation, but allow people to talk to you and each other whenever it is possible during the training.
  • Hold Think-Pair-Shares with Breakout Groups: If your platform support break-out rooms and if it fits, place delegates into pairs and groups to discuss, complete exercises and report back to the group.
  • Try to change thing and get interactions from delegates every five to ten minutes. Don’t go any longer than this, as delegates will drift off. If you are inventive enough, get trainees to use their smart phone to respond to exercises. Play games together. Connect people, share stories and tips on what works for them.

Structuring a Virtual Classroom

 

  • At the start of each session, after a break, do a formal check-in, ensuring everyone is back and happy so far. End with a check out and ask individually if they have any questions.
  • Keep concepts clear: Be extremely clear what are the key messages, concept and learning areas are. Do not be afraid to repeat the same message many times.
  • Try different things: Use polls, breakout sessions, whiteboards, ask people to draw on screen, unmute people, annotate etc. Things will go wrong, but don’t be afraid to laugh at yourself as you use all of these tools. Tell delegates to expect glitches and make a joke out of them.

 

It is possible to create a successful, engaging and even fun Virtual classroom. Remember to keep things interactive and start (and end) with your delegates. After all, they are the people who the training is all about!

Part 1 – Preparing For Virtual Training

 

InkedVirtual Training-Infero-Training

 

From a Trainer’s point of view, preparing to deliver Virtual training is quite different from normal face-to-face classroom learning. It requires acquiring new skills and perhaps adapting the normal method of delivery of a subject. In a series of Posts, we here at Infero are going to take you through planning, preparing and delivering a successful Virtual training session.

 

Platform and Equipment

 

The first and most important step is to invest In Stable, Reliable Virtual Technology. It is a mistake to not take time and effort to find the best platform for the training that is being delivered. There are lots of online meeting platforms, the most well-known being GoTo Webinar, WebEx and Zoom. Before deciding on which is the best for you, think about the following:

 

  • Is the training for small groups, large audiences, or both?
  • Can the training be accessed on multiple platforms and devices, such as phones and tablets?
  • Do you need a platform specifically designed to support learning delivery?
  • Does the platform allow the upload of shareable files and content to a secure location?
  • What are the platform’s messaging capabilities and how can they be used effectively?
  • Will the Training need Whiteboards, break-out rooms, annotation tools, the ability to look at attendee’s screens and other such tools?

 

Before deciding on a particular product, it may be useful to sign up for the free time-limited trials that many platforms have. They can be tried out to see if they are a match for your Trainers and for your material.
It is also really worth Investing in a Hands-free Headset, with a good quality microphone. Make sure it fits well and is comfortable, as you may be wearing it all day.

 

Preparing for Technical Difficulties
When delivering virtual training, technical problems will happen. There can be issues with sound/video, attendees being unable to connect to or access the meeting, the trainer’s machine crash and more. Prepare by:

 

  • Trying to anticipate all possible problems and have a plan in place to address each one. As a trainer rehearse and practice with the software as much as possible. Practice, Practice, Practice.
  • Having backup equipment and solutions ready if something fails.
  • When picking the platform that you are going to use, ensure it has good technical support.
  • Preparing attendees: they should know how to set up their systems and have the appropriate software installed beforehand.
  • Keeping the Technology as simple as possible, but make sure it is reliable and you have tested it properly.

We all know Murphy’s Law, but don’t forget O’Toole’s Law: Murphy was an optimist.

 

Prepare the Physical Space

 

The space and environment also need preparation. not just the technology.

 

  • Consider the background – a clear wall is best.
  • Check the light source – generally it is best if the light source comes from behind the screen.
  • Think about seating and standing positions when training and how to transition, if you plan to do both.

 

Training Material

 

It may be useful to look at and the training material you plan to use. Ask if the content can be divided into smaller sections, delivered in shorter sessions. Remove any excess material. Use visual aids but keep words and images to a minimum. Get rid of anything you don’t need.

 

Preparing is just the start, however. Come back again for our next post on delivering successful Virtual Online Training,

Uncanny PowerPoint Facts

PowerPoint Collage

 

PowerPoint is used in Businesses, Schools and many other places. It is an incredibly versatile and powerful tool and can be used, among other things, to make social media images, YouTube videos, infographics, business cards, visual CVs, logos and photo collages.

 

For something that is so widely used, however, there are some things that not many people know about the world’s leading presentation app. Here are some suprising facts about PowerPoint:

 

  • PowerPoint was designed for Apple, not Microsoft and was initially only available on Macintoshes.
  • It was originally called “Presenter”, but because of Trademark issues the software’s name was changed to PowerPoint in 1987, which was the same year that Microsoft bought the application for $14million.
  • Approximately 35 million PowerPoint presentations are given every day by 500 million users worldwide.
  • The average PowerPoint slide length is 40 words, but it should be remembered, in PowerPoint Presentations, that LESS is more.
  • It is possible to use a ‘virtual’ laser pointer in PowerPoint, but this only works in presentation mode.
  • Most people tune out of a presentation after only 10 minutes. (To avoid this, the secret is to re-engage the audience with a poll, questions or some sort of activity.)
  • Powerpoint (like Word and Excel) can combine separate shapes into one custom shape. Effectively PowerPoint can be a vector art tool.
  • Preparing a presentation takes on average 2 hours of time for a normal employee.
  • One of the most annoying things about PowerPoint Presentations are presenter who just “read” the text on their slides. Only putting keywords on slides helps to avoid this.
  • PowerPoint Karaoke is a real thing! To play, presenters deliver a completely unknown presentation (without seeing the slides beforehand) and try to make it look they know what you are talking about.
  • PowerPoint includes functionality to take screenshots, remove photo backgrounds, create amazing animation and transition effects, take screen recordings, reshape photos into any shape and even use video as a background.

 

Infero offers course on PowerPoint at all levels, that help you unlock this functionality and provides tips on making your PowerPoint presentation stand out from the rest.

The Top Ten Interesting Facts About Microsoft Word

MS Word Collage

 

Microsoft Word had been around for a while now. In fact it is nearly forty years old. But there is a lot more to know about Word than that. We’ve collected together some interesting and fun facts that might surprise you.

 

  1. Word was launched in 1983, around the time that wearing a seat-belt became compulsory in the UK, when it was called Multi-Tool Word.
  2. It was one of the first word processors to have a What-You-See-Is-What-You-Get (WYSIWYG) interface. What appeared on the screen looked the same as what was printed. Before this, mark-up tags needed to be added to indicate different typefaces.
  3. Like Excel, Word was released for the Apple Macintosh years before there was a version for Windows.
  4. Early versions of word had interesting codenames, including Bill the Cat (for Word 1.1) and Spaceman Spiff (Word 2.0).
  5. AutoCorrect was only included with Word 6.0 in 1993. Before that users had to correct their own typing, spelling and grammar mistakes!
  6. There was a free download of Word released as a fail-safe against the much-feared Millennium Bug – Word 5.5. for DOS. (If you look hard enough, it can still be found on the company’s website.)
  7. It is possible to include most kinds of Equations in Word. (-b±√(b^2-4ac))/2a).
  8. There is a ‘Hidden’ option for text, so that it not only cannot be seen, it does not take up any space. You can still use ‘Find and Replace’ with hidden text, though.
  9. There are shortcuts for selecting in Word. Two rapid mouse clicks will select a word. Three rapid clicks will select an entire paragraph and CTRL + Click will select a sentence.
  10. It is possible to use Macros to automate Word. They are not just available in Excel.
  11. Bonus Fact:  According to Microsoft’s latest figures, there are currently 1.2 billion Office users worldwide. If all of them typed just ten words, then it would take one person 110 years to read them all, at average reading speed.

 

There is so much more that Word is capable of doing. Infero offers Training courses at all levels to help get the most out of this remarkable piece of software.

Six Steps For A Perfect Interview

free-to-use-sounds-now-hiring-infero-training

 

In a previous blog, we looked at how to prepare for an interview, but it is the interview itself that really matters. When the interview day arrives, you need to ensure that you stand out from all the other candidates. This is easier than you think. Here are a few simple guidelines that will ensure that your interview goes well:

 

1. Practice Good Non-Verbal Communication

 

Demonstrate confidence from the start of the interview. Stand up straight and make eye contact. Greet all the people interviewing you with a smile and a firm (not crushing) handshake. Non verbal impressions are incredibly important and can give a great beginning to your interview.

 

2. Listen

 

Interviewers will give you information during the interview, either directly or non directly, so make sure you listening. An interviewer will want to know that your communication skills include listening, so it is important to let the other them know that you heard what they said. Match the style and pace of the interviewer, if that is possible. This is extremely important when responding to specific questions. You will have done your homework and prepared answers, but make sure that the question being asked matches the answer you have prepared. Listen carefully and answer the question that the interviewer has asked.

 

3. Don’t talk too much

 

It sometimes feels that you have said too little in answering a question, but don’t say too much. Long rambling answers that end up going nowhere are not a good idea. When preparing, you will have thought of specific, precise answers to questions. Give the interviewer only the information they need to answer that specific question and show you know exactly what you are talking about. Match your skills with the position’s requirements and relate only that information.

 

4. Don’t be too Familiar or Overconfident

 

The interview is a professional environment and the interviewer wants to see that you can be professional. Remember, you are not there to be the interviewer’s friend. Take your cue from the interviewer, be energetic and enthusiastic, but remember you are a candidate looking for a job. Make sure you use appropriate, professional language.

 

And remember, you are there to sell yourself, but try to get the balance between confidence and modesty right. Overconfidence can be worse than not highlighting your skills and abilities.

 

5. Ask Questions

 

At the end of the interview, when you are asked, “Do you have any questions for us”, make sure that you have prepared some in advance and ask these, to demonstrate an interest in what goes on in the company. Asking questions also gives you the opportunity to find out if this is the right place for you. The best questions are those that arise from listening carefully to both the questions that have been asked, and the things that the interviewers have said, and then asking for additional information.

 

As your last question, let the interviewers know you’re very interested in the job and ask when they think that they will be getting back to candidates.

 

6. Tell the Truth

 

It may seem obvious, but don’t lie, or be scared to admit that you don’t know something. Express your interest in learning or advancing in an area. If you have begun to look into something, tell them that, or try to ask a good question around the subject. Just don’t lie. No employer expects you to know everything. Admitting you don’t know is better than pretending that you do.

 

Bonus Do’s and the Don’ts

 

  • Do dress stylishly and job appropriate.
  • Do make eye contact. But don’t overdo it.
  • Do take time to consider your answers and respond thoughtfully.
  • Do take time for pleasantries.
  • Do use job appropriate language and well-placed jargon.
  • Do be yourself.
  • Do clearly define your reasons for wanting the job.
  • Do speak clearly, at a normal conversational pace.
  • Do remember that’s it’s ok to be nervous, as long as nerves don’t get the better of you.
  • Don’t get flustered if you slip up on a question.
  • Don’t speak ill of former co-workers, employers or colleagues.
  • Don’t reveal unnecessary personal information.
  • Don’t forget to highlight your biggest strengths.
  • Don’t tell jokes. They can fall flat.
  • Don’t panic. You will do great!

 

Remember, despite what you think, interviewers want you to do well. They are waiting for a great candidate and there’s no reason that shouldn’t be you.

12 Unbelievable Facts About Excel

Many of us use Excel everyday and we think that we know it very well, but just how well do know Excel? Even when you have had Excel training, facts about it that are not widely known and that are almost unbelievable. Here are 12 incredible facts about Excel:

 

  • Excel has been around since 1982, but it was originally called Multiplan and only became ‘Excel’ in 1985
  • The first version of Excel proper was only available for Macs and not for Windows
  • An Excel Cell can contain up to 32, 767 characters
  • There are 17,179,869,184 cells on a normal worksheet. At one second a cell, it would take 545 years to completely fill a worksheet.
  • The earliest date that can be used for calculations is the 1st of January, 1900
  • 16% of the world’s population use Excel
  • In Excel, it is possible to undo the last 100 actions
  • It is not possible to name a worksheet “History” in Excel.
  • There are more than 500 keyboard shortcuts in Excel.
  • The maximum number of worksheets in an Excel workbook is only limited by available memory.
  • It is possible to use up to 512 different fonts in an Excel worksheet.
  • Up to 4,000,000,000 formulas can depend on a single cell

 

 

16 Percent

 

 

Excel is an incredible application and can do some amazing things, but the facts about it are even more unbelievable.