Search
Cancel
Sign In

Excel: Advanced Formatting Techniques (365/2019)

Go to class
Write Review

Free Online Course: Excel: Advanced Formatting Techniques (365/2019) provided by LinkedIn Learning is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Excel: Advanced Formatting Techniques (365/2019) is taught by Dennis Taylor.

via LinkedIn Learning
1-2 hours worth of material
Self Paced
Overview

  • Learn advanced formatting techniques in Excel that can help you create effective and appealing spreadsheets.

    View simple, powerful tips for making Excel data more readable and easier to manipulate. Author Dennis Taylor shows you how to emphasize individual cells with fonts, borders, and colors; adjust the position of cell contents; format numeric data; and increase the readability of worksheets. You can also learn how to add images to worksheets and discover automation techniques that can take the drudgery out of formatting even large amounts of data.

Syllabus

  • Introduction

    • Harness the power of Excel formatting techniques
    1. Alignment Tools
    • Create angled text variations for variety and readability
    • Indent data and dollar signs
    • Use the Merge and Center button to simplify title adjustments
    • Use Wrap Text and Shrink to Fit to control titles and headings
    2. Adjusting Numeric Formats
    • Build custom numeric formats
    • Create custom date formats
    3. Tables, Styles, and Themes
    • Work with tables
    • Use styles and themes for consistent formatting
    4. Row, Column, and Sheet Adjustments
    • Work with rows, columns, and sheets
    • Use the Hide & Unhide options
    5. Other Worksheet Formatting Tools
    • Use the Format Cells dialog box and formatting part of a cell
    • Format text from Word or the web with the Justify feature
    • Add a background image to a worksheet
    6. Displaying Data as an Outline
    • Set up data for outlines
    • Use the Subtotal feature to create outlines
    7. Formatting Images
    • Format picture styles
    • Add borders and effects to pictures
    • Format Sparklines for visual impact
    • Use WordArt for formatted titles and headings
    8. Specialized Power Formatting Techniques
    • Hide repeating titles in a column to clarify printed output
    • Restore missing title data in a column
    • Display large values without using formulas
    • Create picture links
    • Format column and row titles
    • Format a list for double-spaced printing
    Conclusion
    • Next steps

← Prev Next →
0, based on 0 Course votes at GetYourEducation

Start your review of Excel: Advanced Formatting Techniques (365/2019)

Add review ->
Related courses by Level

ANIMATIONs

Beginner
Provider: Swayam
Language: English

Adobe Lightroom Classic Fundamentals

Beginner
Provider: CreativeLive
Language: English

Build, Train, and Deploy ML Pipelines using BERT

Beginner
Provider: Coursera
Language: English

English for Research Publication Purposes

Beginner
Provider: Coursera
Language: English

English for Research Publication Purposes

Beginner
Provider: Coursera
Language: English

Introduction to Bohemian Watercolor Techniques

Beginner
Provider: Skillshare
Language: English
Browse by subject
Browse by provider
Browse by university
Browse by institution
College Rankings