Excel Basics 17: Style Formatting: By Hand, Cell, Table & Conditional Formatting

Excel 2016 Basics Free Course - Learn to Efficiently Use Excel at Work and to Get a Job. - Excel Basics 17: Style Formatting: By Hand, Cell, Table & Conditional Formatting

4.0 (3)

24 learners

What you'll learn

This course includes

12.3 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

Highline College Busn 216 Mike Girvin Michael Girvin excelisfun Excel Basics Learn Excel Excel Excel 2016 Learn Excel for Free Learn Excel Online Complete Lesson in Excel

Full Transcript

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin. Download Excel Start & Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EB17StyleFormatting.xlsm Download Full Written Notes: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Office2016Class29-ExcelBasics17-StyleFormatting.pdf Class web page link: https://people.highline.edu/mgirvin/AllClasses/216v2016/Content/04Excel/Excel2016.htm Topics in this video: 1. (00:01) Introduction 2. (00:32) Example 1: Accounting Style Formatting (4 Examples) 3. (08:47) Example 2: Accounting Borders 4. (09:25) Example 3: Column widths!! 5. (10:16) Example 4: Wrap Text in Cell: Multiple Lines in a Cell (Alt + Enter) 6. (11:38) Example 5: Table Format button (Converts to Excel table) 7. (12:55) Example 6: Cell Styles 8. (14:00) Example 7: Built-in Conditional Formatting to Visualize Data 9. (17:11) Summary - Conclusion