Spreadsheets Course For Localization Professionals

Spreadsheets For Beginners Course

Unlock the power of spreadsheets and data organization with Andrej Zito.

Enroll for free

1. Welcome To Your Spreadsheets Course
2. Why It's Good To Know Spreadsheets
3. Before You Start
1. Your First Spreadsheet With Google Sheets
2. The Hierarchy Of A Spreadsheet
3. Real Life Examples Of Hierarchy
1. How To Insert Data
2. Different Data Types
3. Basic Editing Operations
4. How To Change Data
1. How To Resize Cells
2. How To Use Text Wrapping
3. How To Align Content
4. Basic Text Formatting
5. How To Format Numbers
1. How To Import CSV
2. How To Split Text Into Columns
3. How To Resize Columns And Rows
4. How To Delete And Insert Columns And Rows
5. Cleaning Up The Data
6. Adding New Data To Existing Table
1. How To Move Around With Keyboard
2. How To Freeze Rows And Columns
3. Grouping VS Hiding
4. How To Use Filters
5. Using Automatic Calculations
6. How To Sort Tables
1. Relative VS Absolute References
2. Your First Formula
3. Using SUM Function
4. Calculating Adjusted Word Counts
5. Using Text Function
6. Using VLOOKUP Function
7. Finalizing The Total Budget
1. Why Make Spreadsheets Pretty
2. On Contrast And Choosing Colors
3. Alternating Colors
4. Proper Alignment
5. Using Borders
1. All Keyboard Shortcuts From The Course

For more information about the course, please visit our main site.

Learn more