Quick Excel Tips and Tricks with Video Tutorials
Minimum price
Suggested price

Quick Excel Tips and Tricks with Video Tutorials

Learn Excel Shortcuts with Exercise Files

About the Book

This Excel guide and its short video tutorials are a life safer! Now you can learn how to use Excel more efficiently with many useful tips and tricks in this book and its quick videos. I’ll show you how to get your Excel work done faster on either Windows or Mac platform.

There are numerous useful shortcuts, tips, tricks and exercise files inside for you to practice along. All these will help you increase your productivity so that you can produce reports in minutes instead of hours. In Chapter 14, I provide a hassle-free download link for the 56 tutorial videos and exercise files.

It is widely agreed that close to 60 percent of Excel users leave 80 percent of Excel untouched. That is, most users do not tap into the full potential of Excel’s built-in utilities. Excel remains one of the most underutilized tools in the entire Microsoft Office Suite.

The 14 chapters of this book and its videos serve as an exhaustive collection of quick tutorials on Excel shortcuts, tips and tricks. It’s very good for beginners and advanced learners alike because it’s accompanied with 56 quick HD demo videos. In these videos, I use a practical approach to simplify everything you need to understand to help you speed up your learning of Microsoft Excel.

Microsoft Excel is a tool is used in virtually all careers and is valuable in both personal and professional settings. For example, you can use it to keep track of medications in a hospital inventory, create a financial plan for retirement, or to do other similar activities accurately and efficiently.

This book and its demo videos are very valuable because they introduce the fundamental and advanced skills necessary to get you started quickly in using Excel. You will discover that the first few chapters or videos alone will make you very productive in a short period of time.

Finally, if you have questions or need further help, you can use the support link I provide in Chapter 14. I will get back to you very quickly.

About the Author

A. B. Lawal
A. B. Lawal

I am multi-talented. As a computer engineer and a computer scientist, I have over 15 years of teaching experience in software development and computer hardware architecture. I am the CEO of AB Publisher LLC, a media publishing company. I co-publish my books with Charles H. Johnson who also offers technical assistance to my company. In the last few years I have helped the IT industry develop various useful programs on Windows, MacOS and PLCs (programmable logic controllers).

I always build solutions from scratch and go as far as modifying open source software to meet my client’s needs. As an embedded systems expert, I design embedded Systems that optimize performance and cost against complex requirements. I leverage Stratify OS (a POSIX like RTOS for micro-controllers) to quickly and cost-effectively develop complex firmware applications in Python and C/C++ languages. I work with a dedicated team of Python programmers who look into specific automation problems and proffer solutions to them.

For any inquiry, you can contact us with any of the email addresses below any time. If you want to contribute your knowledge to this website, or if you have a request, just send us your message. We promise to do our best to help.

Bolakale Aremu (CEO), Founder info@abpublisher.com, OjulaTech@gmail.com.

Charles H. Johnson (Co-publisher and Technical Assistant) amandamorin3000@gmail.com.

Table of Contents

  • 1. Seven Significant Shortcuts
  • 1.1. How to Enter Data or Formulas in Non-adjacent Cells Simultaneously
  • 1.2. How to Copy Data or Formulas Down a Column
  • 1.3. How to Instantly Enter Today's Date or Time
  • 1.4. How to Convert Formulas to Values with a Simple Drag
  • 1.5. How to Display All Worksheet Formulas
  • 1.6. How to Create Charts with these Keystroke Shortcuts
  • 1.7. How to Zoom In and Out Quickly
  • 2. Ribbon & Quick Access Toolbar Tips
  • 2.1. How to Access Ribbon Commands with Alt Key Sequences
  • 2.2. How to Expand/Collapse the Ribbon and Full-screen Views
  • 3. Display Shortcuts
  • 3.1. How to Create Split Screens and Frozen Titles in a Flash
  • 3.2. How to Restore Missing Labels and Hide Repeating Labels
  • 3.3. How to Customize the Display of Status Bar Totals
  • 4. Navigation & Selection Shortcuts
  • 4.1. How to Navigate Between Workbooks and Worksheets Efficiently
  • 4.2. How to Navigate Within Worksheets Efficiently
  • 4.3. How to Open, Close, Save and Create New Workbooks with Keystrokes
  • 4.4. How to Select an Entire Row, Column, Region or Worksheet
  • 4.5. How to Select Non-contiguous Ranges and Visible Cells Only
  • 5. Data Entry and Editing Shortcuts
  • 5.1. How to Accelerate Data Entry
  • 5.2. How to Enter Dates and Date Series Efficiently
  • 5.3. How to Enter Times and Time Series Efficiently
  • 5.4. How to Use Custom Lists for Data Entry and List-based Sorting
  • 5.5. How to Enhance Editing Tools
  • 6. Drag & Drop Techniques
  • 6.1. How to Accelerate Copy and Move Tasks Within Cells and Worksheets
  • 6.2. How to Drag and Insert Cells with the Shift Key
  • 6.3. How to Display the Paste Special Options
  • 7. Formula Shortcuts
  • 7.1. How to Create Formulas Rapidly
  • 7.2. How to Select All Dependent or Precedent Cells
  • 7.3. How to Use AutoSum Shortcuts
  • 7.4. How to Count the Number of Unique Entries
  • 7.5. How to Use Conditional Formatting to Highlight Formula Cells
  • 7.6. How to Perform Calculations Without Formulas
  • 8. Operational Shortcuts
  • 8.1. How to Insert, Delete, Hide and Unhide Columns and Rows
  • 8.2. How to Realign Imported Text
  • 8.3. How to Select and Manipulate Blank Cells
  • 8.4. How to Collapse and Expand Detail with Group and Ungroup Buttons
  • 8.5. How to Create Double-spaced or Triple-spaced Printouts
  • 9. Formatting Shortcuts
  • 9.1. How to Use Keystroke Shortcuts for Frequently Needed Numeric Formats
  • 9.2. How to Accentuate Data with Alignment Tools
  • 9.3. How to Add a Color Background to Every 5th Row in a Range
  • 9.4. How to Use Conditional Formatting Based on Comparison Criteria
  • 9.5. How to Use Special Formats for Times Over 24 Hours
  • 9.6. How to Add and Remove Strikethrough and Borders with Keystroke Shortcuts
  • 9.7. How to Display Values in Thousands or Millions without Formulas
  • 9.8. How to Format Phone and Social Security Numbers
  • 10. Data Management Techniques
  • 10.1. How to Clean up Spaces with the TRIM Function
  • 10.2. How to Split Column Data Using Text to Columns and Flash Fill
  • 10.3. How to Join Data with the TEXTJOIN Function and Flash Fill
  • 10.4. How to Ensure Unique Entries with Data Validation Rules
  • 10.5. How to Display Unique Items from Large Lists
  • 11. Charting and Visual Object Tips
  • 11.1. How to Manipulate Chart Placement and Sizing with Dragging Techniques
  • 11.2. How to Create Chart Titles from Cell Content
  • 11.3. How to Create and Manipulate Shapes with the Shift, Ctrl and Alt Keys
  • 11.4. How to Create Linked Dynamic and Linked Static Images

  • 12. Pivot Tips
  • 12.1. How to Adjust Report Layouts to Allow Totals on Top or Bottom
  • 12.2. How to Revisit Relevant Source Data with the Drill Down Feature
  • 13. Ten Tiny Tips (Cheat Sheet)
  • 13.1. How to Become a More Proficient Excel User with Ten Tiny Tips
  • 14. How to Download the Demo Videos and Exercise Files
  • 14.1 How to Get Further Help & Answers to Your Questions
  • 14.2 More Helpful Resources
  • The Leanpub 60 Day 100% Happiness Guarantee

    Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.

    Now, this is technically risky for us, since you'll have the book or course files either way. But we're so confident in our products and services, and in our authors and readers, that we're happy to offer a full money back guarantee for everything we sell.

    You can only find out how good something is by trying it, and because of our 100% money back guarantee there's literally no risk to do so!

    So, there's no reason not to click the Add to Cart button, is there?

    See full terms...

    80% Royalties. Earn $16 on a $20 book.

    We pay 80% royalties. That's not a typo: you earn $16 on a $20 sale. If we sell 5000 non-refunded copies of your book or course for $20, you'll earn $80,000.

    (Yes, some authors have already earned much more than that on Leanpub.)

    In fact, authors have earnedover $13 millionwriting, publishing and selling on Leanpub.

    Learn more about writing on Leanpub

    Free Updates. DRM Free.

    If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).

    Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.

    Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.

    Learn more about Leanpub's ebook formats and where to read them

    Write and Publish on Leanpub

    You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!

    Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.

    Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.

    Learn more about writing on Leanpub