Discover 30 essential Excel tips and tricks in this comprehensive 2-hour tutorial designed for beginners and intermediate users. Learn how to maximize productivity with step-by-step instructions on various Excel features, including dark mode, accounting number format, cell splitting, worksheet grouping, error bars, indentation, format painter, checkboxes, spill error fixes, cell locking, macro recording, named range deletion, page breaks, scrollbar fixes, heat maps, name error solutions, row and column manipulation, space removal, bullet points, pie charts, row freezing, Excel-to-Word conversion, rounding prevention, SUBTOTAL calculations, slicers, function graphing, text-to-number conversion, visible cell copying, secondary axis addition, and non-adjacent cell selection.
Overview
Syllabus
How to Use Excel Dark Mode
Using the Accounting Number Format Excel
How to Split Cells in Excel
How to Group Worksheets in Excel
How to Add Error Bars in Excel
How to Indent in Excel
Excel Format Painter - How to use it
How to Insert Checkboxes in Excel
How to Fix the Spill Error in Excel
How to Lock Cells in Excel
How to Record a Macro in Excel
How to Delete a Named Range in Excel
How to Insert a Page Break in Excel
How to Fix Missing Scrollbar in Excel
How to Insert a Heat map in Excel
How to Fix the Name Error in Excel
How to Move Rows & Columns in Excel
How to Remove Spaces in Excel
How to Add Bullet Points in Excel
How to Make a Pie Chart in Excel
Freeze Rows in Excel
How to Convert Microsoft Excel to Word
How to Stop Excel rom Rounding
How to Calculate SUBTOTAL in Excel
How to Create an Excel Slicer
How to Graph a Function in Excel
How to Convert Text to Number in Excel
How to Copy Visible Cells Only
How to add a Secondary Axis in Excel
How to Select Non-Adjacent Cells in Excel
Taught by
Simon Sez IT
