get app

    7 Steps To Excel Success - Excel Skills And Power Tips

    BY
    Udemy

    Brochure Enquire
    Mode

    Online

    Fees

    ₹ 399 799

    Quick Facts

    particular details
    Medium of instructions English
    Mode of learning Self study
    Mode of Delivery Video and Text Based

    Course and certificate fees

    Fees information
    ₹ 399  ₹799
    certificate availability

    Yes

    certificate providing authority

    Udemy

    The syllabus

    Aloha! -- Congratulations! -- Welcome

    • START HERE -- ALOHA! -- CONGRATULATIONS! -- DOWNLOAD YOUR WORKBOOK HERE!
    • IMPORTANT - Please Start Here! -- This Is The Worlds Easiest Quiz!

    Elements of the Excel Screen - Click This Do What?

    • 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?

    Is This 2007, 2010, 2013, 2016? What's The Difference? Just Look At The Ribbon!

    • 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?

    Saving

    • 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

    QAT

    • The Quick Access Toolbar - QAT - Find The Secret Features Of Excel
    • The Secret Features - QAT

    Begin With The End In Mind - 7 Steps To Excel Success

    • Begin With the End in Mind - 7 Steps To Excel Success

    Step 1 - DESIGN - It's So Easy In The 21st Century

    • Templates - Learn how to to tame the "World's Most Dangerous Program."

    Step 2 - BUILD - Building Your Worksheet

    • Five Things That Can Go Into An Excel Worksheet - F2 Is Your Friend
    • Minimize Repetition - Learn The Auto Fill Handle.
    • Learn How To Create A Create Custom Fill Series - No More Typing That List!
    • How Many Rows and Columns In Excel? Select All And The Name Box Will Tell You
    • Navigation Shortcuts
    • Skill Snack - BUILD
    • Insert Rows and Columns Like A Professional
    • Selecting Cells And Ranges Like a Professional
    • Universal Shortcuts - You Probably Already Know Them And Did Not Realize It.
    • Insert A Worksheet, Name It, Rename It, Move It
    • Move Worksheets To Another Workbook - Make Worksheet Names Standout With Color
    • You Are Getting Good At This!

    Step 3 - Calculations - Add Some Calculations

    • 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

    Step 4 - FORMATTING -Make It Pretty For The End User. Make It easy To Understand

    • 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

    Step 5 - Reporting - Garbage In...Garbage Out - What About Charts?

    • 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

    Step 6 - Printing - Learn Where The "Fit-to-One-Page" Button Is Located

    • Print Correctly - Start With a Print Preview - There Is More Than One Way
    • Tell Excel What You Want To Print - Set The Print Area
    • Now That Excel Knows What To Print Let's Make It All Fit To One Page
    • Now That We Can Print Properly - How About Some Headers And Some Footers?
    • Let's Keep On Learning - PRINTING

    Step 7 - Macros - Delegate to Excel

    • What's A Macro?
    • Recording Your 1st Macro - Yes, It's That Easy
    • Run Your Macro
    • Wrap Up
    • Let's Keep On Learning - MACROS

    Additional Resources - Live Workshop Recordings - Shortcuts - And More...

    • 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 ??

    Bonus Section

    • Learn More With Mr. Aloha (BONUS LECTURE)

    Instructors

    Mr Billy Wigley
    Trainer
    Freelancer

    Ms Stephanie Jhoy Tumulak
    Operations Manager
    Freelancer

    Trending Courses

    Digital Marketing Courses Fashion Design Courses Data Science Courses Interior Design Courses Graphic Designing Courses Cyber Security Courses Nursing Courses Tally Courses Data Analysis Courses Web Designing Courses Artificial Intelligence Courses Ethical Hacking Courses Free Digital Marketing Courses And certifications Free Artificial Intelligence Courses And Certifications Free Data Analysis Courses And Certifications Free Cyber Security Courses And Certifications Free Data Science Courses And Certifications Free Cloud Computing Courses And Certifications Free Python Courses And Certifications Free Fashion And Textiles Courses And Certifications Free Graphic Designing Courses And Certifications Free Web Designing Courses And Certifications

    Popular Courses

    General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Programming Courses Cyber Security Courses Data Science Courses Law Courses Digital Marketing Courses Leadership Courses Explore all courses

    Popular Platforms

    upGrad Courses Udemy Courses Edx Courses Swayam Courses Coursera Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses NPTEL Courses IIT Kharagpur Courses Emeritus Courses IIT Kanpur Courses Explore all platforms

    Learn more about the Courses

    10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management
    Providers
    Close

    Download the Careers360 App on your Android phone

    Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

    Careers360 App
    150M+ Students
    30,000+ Colleges
    500+ Exams
    1500+ E-books