Top 19 Excel Hacks of 2023 - Master Spreadsheets Like a Pro
Offered By: Simon Sez IT via YouTube
Course Description
Overview
Master 19 essential Excel hacks in this comprehensive tutorial designed to elevate your spreadsheet skills. Learn to import data seamlessly, enhance security by locking cells, add bullet points effortlessly, and manipulate rows and columns with precision. Discover techniques for copying visible cells, inserting page breaks, converting Excel to Word, and merging files. Explore collaborative features like sharing workbooks and grouping worksheets. Optimize your workflow by reducing file sizes, inserting hyperlinks, converting text to numbers, and splitting cells. Tackle common issues such as spill errors and learn advanced functions for extracting text, counting cells with text, and calculating subtotals. Perfect for beginners and experienced users alike, this tutorial provides step-by-step guidance to boost productivity and efficiency in Excel.
Syllabus
- Intro Simon Sez IT
- Importing Data into Excel
- How to Lock Cells in Excel
- How to Add Bullets Points
- How to Move Rows and Columns
- How to Copy Only Visible Cells
- How to Insert a Page Break
- How to Convert Excel to Word
- Merge Excel Files
- Sharing a Workbook
- How to Group and Ungroup Worksheets
- How to Reduce Excel Files Size
- How to Insert Hyperlink in Excel
- How to Convert Text to Numbers
- How to Split Excel Cells
- How to Fix Spill Errors
- Extracting Parts of a Text String
- How to Count Cells with Text
- How to Calculate Subtotals
Taught by
Simon Sez IT
Related Courses
Economic Issues, Food & YouUniversity of Florida via Coursera Get Organized: How to be a Together Teacher
Relay Graduate School of Education via Coursera Work Smarter, Not Harder: Time Management for Personal & Professional Productivity
University of California, Irvine via Coursera Lean Operations العمليات الرشيقة
Rwaq (رواق) Realidad Macroeconómica Latinoamericana
Inter-American Development Bank via edX