Tag Archives: Excel keyboard shortcuts

Reap the Benefits of the Excel 2013 CourseCARD

Microsoft Excel 2013 CourseCARD
Visit our website for more information on the Microsoft Excel 2013 CourseCARD.

Microsoft Excel has in record time become one of the most popular programs in both the corporate and small business world, as well as for home use. However, beginners experience moments of panic when delving into the inner workings of this versatile application.

Excel offers thousands of features so creating a system of understanding how to add onto the quick access toolbar, what a ribbon is and remembering keyboard shortcuts is vital to the overall success of learning Microsoft Excel.

That is why Labyrinth Learning is pleased to offer Microsoft Excel 2013 CourseCARD. Instead of students laboring over physical note taking, frequently distracting them from the next topic being introduced, our Microsoft Excel 2013 CourseCARD provides students with a quick and easy to understand reference guide.

More than just a step by step list that students follow to solve a problem, CourseCARD explains how Excel functions and details the necessary features and tools so each worksheet can operate properly. There are also basic and advanced topic sections along with a top productivity tips and solutions page.

The basic topic section includes tips on entering information, formulating data and managing worksheets, while the more advanced section discusses some of Excel’s newer features, including sparklines and PivotChart field buttons. The solutions page is a quick reference guide on customizing methods, creating specialized templates and worksheets and how to open older versions of Excel.

For information about our additional teaching aids, please contact us at Labyrinth Learning today.

textbook frustrates colleges students

Labyrinth Learning Textbooks & Learning Solutions Offer An Affordable Alternative

For many adults, the first experience with sticker shock happens in the most unlikely of ways – buying textbooks for college. After working hard, saving money, and scraping together the funds to pay for ever-increasing tuition statements, it can be heartbreaking to see the prices of the textbooks in the college bookstore. In an article by NBC contributor Martha C. Wright reports college textbooks have experienced triple-digit inflation over the past several years. The average college student has to spend $1200 on books each year, $1250 if they attend a private school.

student textbooks
Source: Freedigitalphotos.net

As a result, professors, administrators and students are looking for more affordable alternatives, but so far there isn’t a mainstream solution. In fact, the U.S. Public Interest Research Group reported that as many as 70% of students have admitted to not buying textbooks that are “required” because they simply can’t afford them, which negatively impacts their academic performance. One of the biggest contributors to expensive textbooks is that the publishers continually create “new editions,” using virtually the same material, making it difficult for students with old copies to find the same chapter or practice materials by page number.

This is one of the reasons why Labyrinth Learning has been so committed to producing high-quality textbooks and eLearning materials for an affordable price. We love learning, and we don’t think finances should limit students from getting the best possible education. Contact us at Labyrinth Learning to purchase top-quality, affordable textbooks for your classroom.

 

Microsoft Excel 2013

Speed Up Your Work With These Simple Excel Tricks

If it has been a while since you attended a brush-up course on Microsoft Excel, you’ll know this feeling; you leave the seminar inspired. You can’t wait to get to work and use the new tricks at work, but over the course of a few weeks, you’re lucky if three or four of the new shortcuts you learned make it into your daily rotation. Sound familiar?

Here are some simple Microsoft Excel 2013 tricks you can share at your weekly meeting to keep coworkers up to speed.Microsoft Excel 2013

Select All. Quick keyboard commands can shave seconds, which quickly add up to minutes and hours, off of your everyday computer tasks. [Ctrl]+A can be used to select all of the data in your Excel spreadsheet at one time. It also works in Word and other Windows applications.

Copy/Transfer Formatting. Here’s a trick you’ll really thank us for. The Excel Format Painter Tool is often neglected, but not for long. When you want to transfer the cell formatting (not formula), simply select the cell and right click. See the paint brush in the bottom-right corner? Select it. Then click on any other cell(s) and the identical formatting will be copied.

Display formulas. When you hit [Ctrl] + ~, all of the formulas in a spreadsheet will be visible, allowing you to edit/tweak them as needed.

Labyrinth Learning
has a host of Microsoft Excel 2013 products that can teach your employees basic and advanced skills, or can be used for a FastCourse refresher at your next training seminar.

Microsoft Excel

Excel Makes Quick Work for Your Accounting Needs

It’s easy to get comfortable in a work routine, but that doesn’t mean the routine is efficient. This is why it’s important for management personnel to encourage the accounting team to keep up to date in accounting software and programming updates. For example, the shortcuts available in the new Microsoft Excel 2013 software can up your company’s accounting game and make quicker work of your day-to-day procedures. Here are some Excel shortcuts that can help. Microsoft Excel

  • Select an entire table. Ctrl+Shift+Space Bar. This handy shortcut allows you to select all of the data in an Excel table so the it can be quickly copy/pasted/manipulated elsewhere. This won’t work if one of the active cells is outside of the specified range.
  • Formula reconnaissance. New to a set of data and aren’t quite sure which cells are linked to which formulas? You can click into formulated cell, and press Ctrl+Shift+{ and the linked cells will be highlighted, giving you a deeper understanding of the unfamiliar data.
  • Mouse-free Selection Extend. Tired of selecting an the accurate spreadsheet selection only to bump a key or mouse and have it disappear? Then you’ll love the keyboard shortcut for extended selections: F8. Hit the F8 button on your keyboard, then use the directional arrows to click left to right, and up or down, to select the appropriate cells. You can’t go wrong.

The best way to learn Microsoft Excel 2013 shortcuts is to host a company-wide training seminar using Labyrinth Learning’s FastCourse Series for the serious professional. Contact Labyrinth Learning today.

female hands touching keyboard

Keyboard Shortcuts Every Excel User Should Know

female hands touching keyboardWhen you are dealing with a spreadsheet all day, you have to deal with hundreds of calculations, thousands of cells and dozens of pages. Throughout the day clicking through a series of menus and finding the right buttons can add up to a lot of extra time.

Luckily all of your common productivity programs have built in shortcuts to make quick work of your work. Here are just a few Microsoft Excel 2013 keyboard shortcuts that can boost productivity in your workforce.

  1. [ALT] + ENTER. Insert a new line in a cell. As any introductory student to Excel knows, pressing Enter will take you directly to the next cell, but ALT+ENTER will create a new line within the same same cell.
  • [CTRL] + [ ; ] and  [CTRL] + [ : ]. Insert the current date and/or time. When you hit the CTRL + Semi-colon and/or CTRL + Colon, the current date and time will appear, respectively. This is significantly faster than alternative formatting methods.
  • [F11]. Create a chart. If you want to create a chart from a range of data, simply select the data and hit your F11 key. It’s like magic.
  • [SHIFT+F2]. Add a comment to a cell. Wish you could add a comment to a cell quickly? You can when you press the SHIFT, and then the F2 key.
  • [CTRL+F2]. Print Preview. This keyboard shortcut works in both Microsoft Excel 2013 and Word, and gives you an instant view of what your sheet will look like if you need to print it out.

Labyrinth Learning offers multiple levels of Excel course materials so your students can utilize efficient, time-saving keyboard shortcuts.

Image: shutterstock.com