Share Description
In this course, you will :
- Excel Shortcuts and Hacks, Workbooks and Worksheets, Formatting Tips
- Increase your Productivity and Become the Office Excel Pro.
- The Custom-Build Practice Files will help you fully comprehend the Excel Hacks.
- Using the most recent version of Office Excel 365, you can improve your Excel skills.
Syllabus :
1. Worksheet Hacks & Shortcuts
- How to Create a Hyperlink to Other Worksheets
- Copying and Moving Worksheets in Various Ways
- Entering Data to Multiple Worksheets at a Time
- Preventing a sheet from Unhiding - Very Hidden Property
- Hiding Scrollbars in a Worksheet
- Creating and Managing Custom Views
- Changing the Default number of Worksheets
- Hiding and Unhiding Sheets
2. Basics of Shortcuts
- Understanding the Types of Shortcuts
- How to identify a shortcut for a feature
- Moving between Ribbons - Inwards and Outwards
- Shortcuts within Features - Inwards and Outwards
3. Data Protection Shortcuts and Hacks
- Protecting a Sheet, yet allowing only a few actions to happen
- Enabling a part of the Sheet to be editable
- How to Create Backup of your file automatically
- Excel Password Encryption to Open and Modify
4. Navigation Shortcuts & Hacks
- Navigating within a Sheet - Empty Sheet
- Navigating within a Sheet - With data
- Navigating Between Sheets
5. Formatting Hacks and Shortcuts
- How Excel Stores Info
- Changing Default Values
- Shrink Cell Tools to Have the Size of the Cells
- How to Add Text to a Number
- Solving the Problem with Leading Zero
- Blocking a User from Interacting Outside a Specific Range
- Understanding the Custom Format Options
- How to Hide & Unhide the Status Bar
- Calculating Values without Formulas
- Highlight Cells that contains Formulas
- Coloring Alternate Rows or Columns
- Formatting Numbers – Rapid Fire Shortcuts
- Duplicate Records and How to Get Rid of These
- Creating Bulleted List
- Format Painter Tips
- How to Insert a Watermark
- Formatting Dates - Custom Date formats
- Filling a cell with Color - Shortcut
- Increasing the Font Size and Decreasing it using Shortcut
- Hiding and Unhiding Rows and Columns
