Thành thạo Microsoft Excel - Khóa học toàn diện để trở thành chuyên gia Excel

This is the Comprehensive Excel Course.

This course covers everything there is to know about Microsoft Excel.

From the fundamentals, to the most advanced features, after taking this class you will be able to use Microsoft Excel at an expert level.

Beginners can begin right at the beginning, then work their way through the course to achieve mastery. Intermediate users can join the course where needed to forward their skills. Advanced users can also drop into sections they need to achieve mastery.

You can learn Excel quickly if it is taught correctly. Developed by a …

• Best-selling Udemy author

• Microsoft Certified Educator

• Microsoft Office Specialist Expert

• Tenured College Professor

• Udemy Instructor Partner

… this course has been designed and perfected to make it easy for you to master Microsoft Excel. Here are highlights of what you will learn in this course:

• Learn to navigate around Excel

• Learn to enter and edit data in Excel

• Learn to adjust the way data and information are displayed in Excel

• Learn to write formulas quickly and easily with the point-and-click method

• Learn to use relative, absolute, and mixed references in Excel

• Learn to create powerful calculations with Excel functions

• Learn to use documentation so that you can work with every function

• Learn to visually represent your data: charts, trendlines, sparklines, combo charts

• Learn to use Excel data tools like sorting, subtotaling, and filtering

• Learn to "freeze columns and rows" with freeze panes in Excel

• Learn to remove duplicates from data in Excel

• Learn to "transpose data" - switching the columns and rows in Excel

• Learn to use Excel to leverage data with Pivot Tables & Pivot Charts

• Learn to format worksheets including conditional formatting

• Learn to automate Excel tasks with time-saving macros

• Learn to integrate Microsoft Excel with Microsoft Word

• Learn to use passwords in Excel to protect your work in multiple scenarios

• Learn tips and tricks about Excel, as well as Excel secrets and shortcuts

• Learn to use printing and sharing in Excel

• Learn to harvest data from the web

• Learn to create powerful random data generators

• Learn to use freeze panes, sorting, filtering, & advanced filtering

• Learn to "what if" sensitivity analysis such as goal seek, scenarios, & data tables

• Learn to use multiple windows, selection panes, proofing, & translating tools

• Learn to print your worksheets with various formatting to various formats including PDF

• Learn to use pivot tables, slicers, timelines, & pivot charts

• Learn to apply styles, themes, stats, accessibility, watch & calculation options

• Learn to use get & transform and the power query editor

• Learn to use the data model and to create relationships between your data

• Learn to work with data joins and to append data

• Learn to use 3D maps and to create recorded scenes

• Learn to program Microsoft Excel with VBA (Visual Basic for Applications)

• Download all of the Excel project files that are used in the videos

Described as “fun,” “amazing,” and “life changing,” this Excel training will forever transform the way you work with numbers. Try this course for yourself and see how quickly and easily you too can master Microsoft Excel.