Excel Tips: Tips & Tricks for Those Who Want to Save Time
Do More. Work Less. Excel Tips & Tricks that WILL Save You Time. Like you I don't want to spend any more time than I have to in Excel… and I looovvee Excel.
Wouldn't you rather open up Excel, get your work done as fast, and as efficiently as possible, and move on to the next task. Or just grab a cup of coffee?
I can help you save time in Excel without the inconvenience, and cost of having to take a day or two off work to do it.
You could absolutely take the time and read a book and learn this on your own. You could go to various websites, and watch multiple videos. What Excel Tips: Spotlight on Excel Time Savers can do is provide you with the top tips I've trained through the years, the tricks, the resources, hacks, shortcuts, whatever you want to call them.
You can spend hundreds of dollars to sit in on an Excel course, and then leave with a book and a bye.
Or you can spend a fraction of that cost, and have Lifetime access to view, and review the course at anytime, so that you can get your work done, and have your coffee, tea, or lemon water too.
See What Your Fellow Students Are Saying About This Course:
"Tremendous help. Thorough and informative…" - Dan B.
"This was a fabulous course! I learned so much… " - Renee R.
"This course would have saved me days, no months of trial and error.." - Larry W.
:: What's In This Course For You?::
Learn Navigation, Workbook Environment, & Worksheet Tips to save you time
Use Tables & Lists more effectively
Charts - yes! You will learn how to quickly create and use charts with other Microsoft applications.
Need to create PivotTables & PivotCharts, that will be covered.
Sometimes Printing in Excel can be a hassle, learn how to troubleshoot common printing issues.
Need to protect you files, you will learn some techniques in this course.
There is even an introduction to Macros.
The above is just a brief summary, there's a lot more, so please take a look at the curriculum. If you want to save time, and the curriculum looks worthwhile, I invite you to join us.
Section 1: Welcome
So many questions
Section 2: Navigation, Workbook Environment, & Worksheet Tips
Customizing the Ribbon
Customizing the Quick Access Toolbar
Selecting Cells & Ranges
Moving & Copying Cells
Copying Multiple Items to Office Clipboard
Quickly Navigate to Worksheets
Named Ranges for Navigation
Splitting Data Into Multiple Columns
Grouping Worksheets to Quickly Add Data
Copying and Renaming a Worksheet
Changing a Worksheet Tab Color
Entering the Current Date and Time
Useful Keyboard Shortcuts: Function Keys - 2 pages
Useful Keyboard Shortcuts: CTRL + - 2 pages
Useful Keyboard Shortcuts: ALT keys - KeyTips
Creating Forms Using the Form Command
Changing the Shapes of Comments
Section 3: Useful Tips on Formulas & Functions
Named Ranges in Formulas
Left, Right, Mid
Showing and Printing Formulas
Section 4: Using Data Validation for Data Entry
Creating Drop-Down Lists
Dependent Drop-Down Lists
Character Limits for Cells
Creating Custom Input Messages and Error Alerts
Section 5: Special, Custom, and Conditional Formatting
Special Number Formats: Phone Numbers, Social Security Numbers, and Zip Codes
Custom Number Formatting: Explained
Custom Number Formatting: Examples
Conditional Formatting with Quick Analysis
Conditional Formatting to Just Show Icons or Bars
Find & Replace with Formatting
Section 6: Tables & Lists
Filtering with Slicers
Sorting by Custom Lists
Section 7: Charts
Keyboard Shortcut & Quick Analysis
Exploding Pie Charts
Combination Charts – Secondary Axis
Copy a Chart to Word or PowerPoint
Section 8: PivotTables & PivotCharts
PivotTables & PivotCharts Overview
Section 9: Printing
Print Titles: Repeat Headings on Each Page
Setting a Print Area
Fitting Everything On One Page
Section 10: Protecting Files
Protecting Formula and Function Cells
Allowing Users to Edit Only Portions of the Spreadsheet
Protect a Workbook’s Structure
Password Protecting a Workbook
Section 11: Macros
Creating a macro
Assigning the macro to a button
Assigning the Macro to the Quick Access Toolbar
Macro Example: Creating Buttons to Navigate Between Worksheets
Simple Macro Maintenance
Section 12: Wrap Up!