Courses from $19.99
|
Created by Ninja Excel
Category Software > Microsoft Office
Unit 0: Introduction A1
Unit 1: Excel Format Course
• Center text across multiple cells
• Change text orientation
• Merge Cells
• Applying Cell Styles
• Format Numbers in Cells
• Format Text in Cells
• Format Numbers as Percentages
• Format Numbers as Currency
• Create a Cell Style
• Summary & Glossary 1
• Control 1
Unit 2: Sort Data
• Data Preparation
• One-Level Sort
• Multi-Level Sort
• AutoFill
• Flash Fill
• Drop-down List
• Cells and Range Names
• Summary & Glossary 2
• Control 2
Unit 3: Filter Data
• Prepare Data to Filter
• Clear Filters
• Filter by specific words
• Text Filters
• Filter by specific dates
• Filter Multiple Columns
• Summary & Glossary 3
• Control 3
Unit 4: Page Layout and
Spreadsheet Printing
• Create and Apply Custom Views
• Page Layout
• Reference data in another
workbook
• Summary & Glossary 4
• Control 4
Unit 5: File Protection
• Protect Sheet
• Unlock Cells
• Hide Formulas
• Protect Workbook
• Summary & Glossary 5
• Control 5
Unit 6: File Protection
• What is a Formula?
• Addition, Subtraction, Multiplication, and Division
• Calculation Order
• Cell References
• Copy and Paste Formulas
• Absolute References
• Mixed References
• Summary & Glossary 6
• Control 6
FINAL EXAM
Students who achieve level A1 will understand basic cell formats such as combining, styling and formatting cells (date, text, percentage, number, etc.).
In addition, they will be able to sort data using filters, adding design and security to the spreadsheet.
Finally, they will understand the use, logic, and syntax of the most basic Excel functions.
Please note the following minimum requirements for an optimal course experience:
>Stable internet access with a minimum speed of 100 Mbps.
>A modern browser (such as Chrome or Firefox).
>Windows 10 or higher operating system.
>Allow access to domains.
English
Or
Get this course, plus 1,230+ of our top-rated courses, with Coggno Prime
Resold modules appear on your website. You earn syndication share from each purchase. Contact Coggno to learn more on how to embed your own Portable Webshop in your website.
ResellSale Share: $33.60
