7 Steps To Excel Success - Excel Skills And Power Tips

Udemy

particular

details

                                    Medium of instructions
                                    English

                                    Mode of learning
                                    Self study

                                    Mode of Delivery
                                    Video and Text Based

Elements of the Excel Screen - Click This Do What? Ever hear of the Ribbon? Tab?
Did Somebody Say File Tab? What Does F11 Do? The Status Bar Counts, and Sums?
Can't See Your Data? Zoom Into It! There Have To Be More Options? Dialogue Box?
The Name Box - Where's My Marquee? The Formula Bar - What's In That Cell?
Got Skills?

Microsoft 365 - The Latest Version
Open Da Maka-Look At The Ribbon. The Simplest Way To Know The Version You're In.
Who Made This Workbook? Get Into The File Tab and Learn The Backstage View.
So What's The Difference?

F12 - Save As - I Prefer The "Old School" Save As.
Saving and Compatibility. What Happened To The Sparklines? Save As What Version?
Saving and Compatibility

Please Excuse My Dear Aunt Sally! - Time To Remember Some 5th or 6th Grade Math.
Formulas - The Heartbeat Of Excel - The Cells Remain The Same What Changes Is..?
You Try - Relative Referencing - Let's Keep It Relative - F4 Is Your Friend
Example Of The Moment You Realize - It's Time To Start Thinking About Functions
What Is A Function? Preprogrammed Formulas - Excel Does The Math - Check it out!
The Most Basic Function - The AutoSum - So Much More Than Just Sum!
Skill Snack - CALCULATIONS
Learn To Delegate To Excel - Just Press Alt+= - The AutoSum - More Than Just SUM
Quick Overview Of The Insert Function Tool - Your Search Engine For Functions
Quick Tip - Zoom To Selection
Introduction to 3D Referencing - Enter Data In One Cell, It Appears In Another
3D Referencing In Action
3D Referencing - Formula Explained - Why Did That Work? It's All In The Set Up!
Practice More 3D Referencing - Did You Know You Can Link Your Workbooks?
Let's Keep On Learning - CALCULATIONS

Why Format Your Data? Plus A Handy Way To Select Your Data Range - Ctrl+A
Let's Get Into Some Formatting - Make It Pretty! - Pus Some Formatting Shortcuts
Formatting Money - Should You Pick The Currency Method Or The Accounting Method?
Alignment- Customize The Orientation Of Your Values- Use Preset Formats (Styles)
The Format_Painter
Let's Keep On Learning - FORMATTING

7 Habits Of Efective Lists -Learn The Right Way To Set Up Your Data Effectivelly
The 7 Habits of Effective Lists - Quick Skill Snack
Organize And Display Data - Sort It Out- But Avoid Merged Cells
Continue Sorting - Right Click To Sort - A To Z Sorting And Keeping It Together
The BIG Sort Buton
Sometimes You Do Not Want To Show All The Data - Hide Rows And Columns With Ease
Skill Snack - REPORTING
The Filter That Lives A Healthy Lifestyle - Auto Filter
Want To See What Your Numbers Are Saying? How About A Graphical Representation?
Visualize Your Data With Charts - Insert Charts And See What Your Numbers Say
Different Charts For Different Reasons - Change Chart Types - Make Them Pretty
Sparklines - Miniature Charts Inside Of Your Cells - They Make People Say Wow!
Let's Keep On Learning - REPORTING

200+ Keyboard Shortcuts
My 15 Favorite Excel Power-Tips: Empower Yourself Get Faster Better Spreadsheets
15 More Of My Favorite Excel Power-Tips
8 Secrets In Excel (Aloha Friday Live Stream)
How To Use Excel 3D Referencing To Add (sum) Your Worksheets ??