Become Efficient With Excel

by ETS Formation Claim Listing

Effectively use formatting techniques to present data in an Excel spreadsheet. Focus on presenting beautiful spreadsheets.

$1037

Contact the Institutes

Fill this form

Advertisement

ETS Formation Logo

img Duration

2 Days

Course Details

Effectively use formatting techniques to present data in an Excel spreadsheet. Focus on presenting beautiful spreadsheets.

 

Educational Goals:

  • Control typography and formatting;
  • Create custom numeric and time formats;
  • Use templates, themes and styles;
  • Use Excel tables;
  • Create column groups with or without subtotals.

 

Methodology:

  • Several learning methods and didactic tools allowing you to measure your progress and your integration of concepts by participants are used throughout the training.
  • Exposed
  • Demonstration
  • Teamwork
  • Computer exercise

 

Content:

  • Control Typography
  • Adjust Fonts, Size And Color;
  • Apply Underline And Stripe;
  • Add Borders And Adjust The Grid;
  • Adjust Cell Padding;
  • Adjust Vertical And Horizontal Alignment;
  • Indent Data;
  • Merge Cells And Centering;
  • Control The Folding Of Text In A Cell. 
  • Copy And Clean
  • Copy Formats Quickly With The Brush;
  • Stick With Formats;
  • Remove Formats;
  • Quick Formats. 
  • Add Luster
  • Use Shapes And Text Boxes;
  • Add Images;
  • Conditional Formatting With Criteria;
  • Use Of Sparklines;
  • Create Angled Texts For Better Results;
  • Leaves Linked In Picture. 
  • Templates And Themes
  • Use An Existing Template;
  • Create Your Own Model;
  • Apply Styles And Themes. 
  • Prepare For Printing
  • Custom Header And Footer;
  • Configure The Repetition Of Elements At The Top Of Pages;
  • Preview The Print And Make Adjustments. 
  • Format Data
  • Standard Formats For Numbers And Dates;
  • Create A Custom Format For Numbers And Dates;
  • Special Formats: Social Insurance Number, Telephone, Postal Codes;
  • Format Periods Over 24 Hours. 
  • Excel Tables
  • Create A Table;
  • Use Existing Styles And Create Your Own Style. 
  • Groups And Plan
  • Make Automatic Groups;
  • Open And Close Groups With Control Buttons;
  • Create Subtotals;
  • Disassociate A Group. 
  • Montreal Branch

    1220 Notre-Dame Street, Montreal

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy