“Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft/Office 365”
截至目前，超过 1075761+ 人们已经注册了这门课程，而且已经结束了 323332+ 评论.
课程内容
Microsoft Excel 101 Course Introduction Microsoft Excel Fundamentals Entering and Editing Text and Formulas Working with Basic Excel Functions Modifying an Excel Worksheet Formatting Data in an Excel Worksheet Inserting Images and Shapes into an Excel Worksheet Creating Basic Charts in Excel Printing an Excel Worksheet Working with Excel Templates Excel 101 – Practice What You’ve Learned (DOWNLOAD) Congratulations! You’ve Built a Solid Microsoft Excel Foundation Microsoft Excel 102 Course Introduction Working with an Excel List Excel List Functions Excel Data Validation Importing and Exporting Data Excel PivotTables Working with Excel’s PowerPivot Tools Working with Large Sets of Excel Data Excel 102 Additional Practice Exercises Congratulations! You’re an Intermediate Excel User Microsoft Excel 103 Course Introduction Working with Excel’s Conditional Functions Working with Excel’s Lookup Functions Working with Excel’s Text Based Functions Auditing an Excel Worksheet Protecting Excel Worksheets and Workbooks Mastering Excel’s “What If?” Tools Automating Repetitive Tasks in Excel with Macros Excel 103 Additional Practice Exercises Congratulations! Microsoft Excel Macros and VBA Course Introduction Project #1: Using Excel’s Macro Recorder Tool Excel VBA Concepts Working with Excel VBA Logic Statements Project #2: Moving Beyond the Basics and into VBA Project #3: Preparing and Cleaning Up Data with Excel VBA Project #4: Using VBA to Automate Excel Formulas Project #5: Bringing it All Together and a Weekly Report Project #6: Working with Excel VBA User Forms Project #7: Importing Data from Text Files Course Wrap Up
“A Beginner’s Guide to Microsoft Excel – Learn Excel Charts, Spreadsheets, Formulas, Shortcuts, Macros and Tips & Tricks”
截至目前，超过 400825+ 人们已经注册了这门课程，而且已经结束了 15084+ 评论.
课程内容
Introduction Excel Basics Essential Excel functions New! XLookup – only for Excel 2021 and Office 365 Data Tools Formatting data and tables Pivot Tables Excel Charts Pivot Charts NEW! Maps Chart – only for Excel 2019 and above Special purpose charts Named Ranges Excel Shortcuts Macros NEW! Importing data from PDF – Excel 2021 and office 365 Advanced Excel Creative Infographics Congratulations & about your certificate
Master Excel pivots & learn data analysis w/ advanced Excel cases from a top Excel & business intelligence instructor
截至目前，超过 180305+ 人们已经注册了这门课程，而且已经结束了 40663+ 评论.
课程内容
“Getting Started Excel Pivot Table 101 Formatting Data with Pivot Tables Sorting, Filtering & Grouping Data with Pivot Tables Enriching Data with Pivot Table Calculated Values & Fields Visualizing Data with Excel Pivot Charts Excel Pivot Table Case Studies Wrapping Up”
Financial Modeling in Excel that would allow you to walk into a job and be a rockstar from day one!
截至目前，超过 178685+ 人们已经注册了这门课程，而且已经结束了 42086+ 评论.
课程内容
Beginner to Pro in Excel: Financial Modeling and Valuation – Welcome! Introduction to Excel Useful tips and tools for your work in Excel Keyboard shortcuts in Excel Excel’s key functions and functionalities made easy Update! SUMIFS – Exercise Financial functions in Excel Microsoft Excel’s Pivot Tables in depth Case study – Building a complete P&L from scratch in Excel Introduction to Excel charts P&L Case Study continued – Let’s create some great-looking professional charts Business analysis techniques applied in Excel Case Study – Building an FMCG Model from Scratch Financial modeling fundamentals Introduction to Company Valuation Introduction to Mergers & Acquisitions Learn how to build a Discounted Cash Flow model in Excel Tesla valuation – Complete practical exercise How to value a company with multiples Capital budgeting – The theory Capital Budgeting – A complete Case study Next steps APPENDIX – Microsoft Excel 2010 – Introduction to Excel APPENDIX – Microsoft Excel 2010 – Useful tips and tricks APPENDIX – Microsoft Excel 2010 – Keyboard shortcuts APPENDIX – Microsoft Excel 2010 – Excel functions APPENDIX – Company Valuation
This Microsoft Excel class will make you a master of Microsoft Excel. The training uses Excel 2013 for Windows.
截至目前，超过 126762+ 人们已经注册了这门课程，而且已经结束了 24913+ 评论.
课程内容
Course Information Quick Start Getting Started Working With Functions Creating Charts & Graphs Harvesting Data From The Web Manipulating Data Advanced Filtering Going Pro With Pivot Tables Formatting For Impact Saving Time With Macros Integrating Word & Excel Securing Your Work Printing & Sharing Your Work Enhancing Your Value with Bonus Skills Hands-On: Creating A Gradebook Hands-On: Bringing Grades From Blackboard Into Excel Hands-On: Creating A Loan Amortization Templates Final Exam Farewell
“Learn Excel VBA from Scratch with Dan Strong, Bestselling Excel Expert with Over 180K Students Worldwide!”
截至目前，超过 112166+ 人们已经注册了这门课程，而且已经结束了 15541+ 评论.
课程内容
The Range Object Range Properties The Cells Object Variables Toolbars and Menus Super Important Tools and Excel Logic Loops and Report Writing Basics EVENTS: Worksheet Events made Easy WorkBook Events Worksheet Controls Userforms – the best thing. EVER. BONUS Section – VBA Functions
“Excel: The WHOLE Excel Mastery Series In One! From Excel Novice To VBA Programmer – Excel 2013, 2016, 2019 & Excel 365”
截至目前，超过 96852+ 人们已经注册了这门课程，而且已经结束了 25117+ 评论.
课程内容
“Excel Essentials: Level 1 Basics – Master Excel Step-By-Step An Introduction To Level 1 Start Here – All The Basics Doing The (Simple) Math Rearranging Things Formulas: Learning The Clever Stuff! A Few More Essentials Bonus Section – The Keyboard Shortcuts Bonus Section: Absolute and Relative Cell References Bonus Section: Student Questions Answered! Excel Essentials: Level 2 – Intermediate/Advanced Project 1 – Creating A Data Entry Screen To Populate Multiple Templates Project 2 – Building A Database With Excel Project 3 – Named Ranges Project 4 – What Can I Have For Dinner? Project 5 – Using Excel For Gantt Charts…Timelines And Project Plans! Bonus Section – Just For Fun Student Questions Answered! Excel Essentials: Level 3 – VBA Programming What’s It All About, Alan? Introducing Your Personal Built In Translator…the Macro Recorder The Building Blocks Of Coding…Your Dictionary & Phrase Book Of Success! The Programmers Toolbox…The Techie Stuff, Made Easy (Honest!) Automating All Your Reports! The Data Is Out There…On The Internet, That Is Workbook Events: You Don’t Have To Run Code To Have Code Run! User Defined Functions…What To Do If The Function You Need Isn’t In Excel! Bonus Section: Controlling Windows – Folder Creation Gizmo Bonus Section: eMail Automation…Why WRITE emails! Bonus Section: Word Automation – Controlling Word From Excel Bonus Section: PowerPoint Automation – Create Your Presentation In Seconds! Importing Specific Data From Multiple Files Student Questions Answered Thank You – Your Special Bonus!”
“Microsoft Excel Beginner to Professional. Includes Pivot Tables, Power Query, NEW Formulas… (Excel 365, 2019 & 2016)”
截至目前，超过 48795+ 人们已经注册了这门课程，而且已经结束了 12869+ 评论.
课程内容
“Before You Dive In Quick Tour of Excel Data Input & Hidden Features to Save Time Worksheet Navigation, Copying and Protecting Excel Formulas & What to be Aware of Important Excel Functions (Everything you need to become Pro) Data Cleaning and Management: Sorting, Filtering & Replacing Data Formatting including Conditional & Number Formatting in Excel Printing Excel Files & Saving as PDF Workbook Design Principles Working With Excel Charts Quick Insights with Excel Pivot Tables Introduction to Power Query in Excel * NEW 365 Excel Functions: FILTER, SORT, UNIQUE, XLOOKUP & More * Next Steps”
“Use simple Excel shortcuts to Excel at work, impress your boss, and Excel your income. Macros, Formulas, PivotTable Tips”
截至目前，超过 37356+ 人们已经注册了这门课程，而且已经结束了 11508+ 评论.
课程内容
“Featured Shortcuts – The Newest Lectures And Discussion Answers – Featured Here! In The Beginning… Some Quick Tips, And Basic Elements Of The Excel Screen Let’s Get Back To The Basics Entering and Editing Data Data Validation – Let’s Make Some Drop-down Lists Words In Excel? Yikes! – Make It Work With Easy Text Functions Auto Fill Magic Calculations – Using FUNCTIONS and Building Formulas Like a Professional User! Working With Other Documents And Saying This Will Make You Sound Smart. Make It Pretty – Look at all those colors – Cool! Z-STUFF The French Section – No Specific Category For These Goodies – More Stuff Video Answers Here Are The Announcements – Good Stuff In Here! KEEP ON LEARNING SECTION BONUS SECTION”
有数以千计的在线课程和课程可以帮助您提高 Excel 技能并获得 Excel 证书。