Become Efficient With Excel

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.