Excel Keyboard Shortcuts: Specific Number Formatting

Name: Excel Keyboard Shortcuts: Specific Number Formatting
Rating: 4.3 (157 reviews)

Learn to Be More Efficient in Microsoft Excel (Part 17 of a 20-Part Excel Course Series)

Created byThe ProductivityMe Company

Last updated 12/2015

English

English [Auto],

What you'll learn

Become MORE PRODUCTIVE in Microsoft Excel
Save minutes each day
Show off your cool new skills: impress others with 7 awesome tips, tricks, and keyboard shortcuts

Course content

3 sections • 12 lectures • 29m total length

Introduction to the Course1:06
DOWNLOADS: Guide to Other Mini-Courses in Series & Guide to Keyboard Shortcuts0:13
Overview of Specific Keyboard Shortcuts Covered in Course3:59
Explore seven keyboard shortcuts for applying specific number formats in Excel, including general formatting, currency, percentage, scientific notation, date format, time formats, and number format.

17.01 - (Ctrl + Shift + ~) - Applying General Format2:45
Apply the general format in Excel to one or more cells with Ctrl+Shift+tilde, and explore alternatives like the Home tab general option, or Ctrl+1 to open number formatting.
17.02 - (Ctrl + Shift + $) - Applying Currency Format2:30
Learn to apply currency formatting in Excel with ctrl+shift+$, compare currency and accounting formats, and explore quick alternatives via the ribbon, Alt+H, or Ctrl+1.
17.03 - (Ctrl + Shift + %) - Applying Percentage Format3:30
Learn how to apply percentage format in Excel using the Ctrl+Shift+% shortcut to convert fractions and numbers, compare keyboard shortcuts with the Home tab option, and adjust decimals for consistency.
17.04 - (Ctrl + Shift + ^) - Applying Scientific Format3:45
Learn to apply scientific notation in Excel using the Ctrl+Shift+6 shortcut and explore multiple ways to format selected cells, including via the ribbon, right-click menu, and format cells options.
17.05 - (Ctrl + Shift + #) - Applying Date Format3:45
Apply the short date format in Excel with Ctrl+Shift+3 to quickly convert dates. Explore switching to short, long, or custom date formats for your data.
17.06 - (Ctrl + Shift + @) - Applying Time Format3:30
Use the ctrl+shift+@ shortcut to apply time format in Excel, turning numbers into times. The video shows examples like 10, 10:30, and 13 o'clock and notes formatting consistency.
17.07 - (Ctrl + Shift + !) - Applying Number Format (with Commas)3:13
Learn to apply number formatting in Excel using the Ctrl+Shift+1 shortcut to display commas and decimals, switch to general format, and adjust decimals for accurate numbers.

Requirements

Windows PC or laptop

Description

Most Recent Course Update:

December 2015

Course Description

Are you a Microsoft Excel user? How well do you know the program? Can you do most actions in Excel without using your mouse?

If not: Stop wasting time.

Learn to save several minutes each day by slightly tweaking your workflow. Discover 7 ways to work more efficiently when applying a Specific Number Formatting in Microsoft Excel.

So…

Become the go-to keyboard savant in your office.
Impress your boss.
Get more done each day.
Use the hours you save to make more money or just have some fun!

The choice is yours.

Click “Take This Course" now, and become MORE PRODUCTIVE today!

See you in on the other side.

Cheers,

Tolan
Co-Founder of ProductivityMe

Who this course is for:

Course is for PC-users of Microsoft Excel 2007, 2010, 2013, and 2016
Excel for Mac uses a different set of keyboard shortcuts; this course is not recommended for Excel 2011 Mac or Excel 2016 for Mac (unless user is running Windows on Boot Camp or Parallels)

Excel Keyboard Shortcuts: Specific Number Formatting

What you'll learn

Explore related topics

Course content

Getting Started in the Course3 lectures • 5min

Keyboard Shortcuts7 lectures • 23min

Course Wrap-Up2 lectures • 3min

Requirements

Description

Who this course is for: