YoVDO

Awesome Excel Tips and Tricks for 2023

Offered By: Simon Sez IT via YouTube

Tags

Microsoft Excel Courses Data Analysis Courses Data Visualization Courses Macros Courses

Course Description

Overview

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.

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

Related Courses

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera
Excel 2010
Miríadax
The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd
Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity
Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard