Excel 365 Part 6 - Formatting

Once Formulas are entered, the spreadsheet must be formatted to look presentable. The Font Group contains some of the most commonly used font and character commands. There are some very unique and extremely useful commands in the Alignment Group available to effectively format a worksheet. Also, the Number Group will allow you to fine tune number and date styles.Show more

Video Series Part 6 - This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-1-ch6.mp4

Click + Rumble or +Like if the video was helpful.
Click Subscribe so you won’t miss out on any new videos.
Click the Share button so you can help others expand their skills.

If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com
Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video. The courseware is available on Amazon at: https://www.amazon.com/dp/1660217326

Courseware: Excel 365 - Formulas, Formatting, And Printing
Chapter 6 - Formatting

Chapter Contents:
Chapter Contents:

Section 1: Font Group
The Font Group contains some of the most commonly used font and character command. The following concepts will be covered: Dynamic Preview, Font Type, Font Size, Font Increase, Font Decrease, Bold, Italics, Underline, Font Color, Format Painter, and Font Effects.

Section 2: Alignment Group
There are some very unique and extremely useful commands in the Alignment Group available to effectively format a worksheet. The following concepts will be covered: Merge And Center, Word Wrap, Vertical Alignment, Horizontal Alignment, Rotation, Rotation At Any Angle, Indent, Hard Return, and Center Across Selection.

Section 3: Number Group
The Number Group will allow you to fine tune number and date styles.
The following concepts will be covered:General Format, Number Format, Currency Format, Accounting Format, Short Date Format, Long Date Format, Time Format, Percent, Decimal Points, Fraction Format, Scientific Format, Text Format, and More Number Options.

Section 4: Border & Fill Cells
The following concepts will be covered: Border & Fill Format, All Border, Thick Outside Border, Border Outline, Border Color, Border Edge, Border Style, Border Placement, Fill, More Colors, Custom, and Conditional Formatting.