Overview

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 authorMicrosoft Certified EducatorMicrosoft Office Specialist ExpertTenured College ProfessorUdemy 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 ExcelLearn to enter and edit data in ExcelLearn to adjust the way data and information are displayed in ExcelLearn to write formulas quickly and easily with the point-and-click methodLearn to use relative, absolute, and mixed references in ExcelLearn to create powerful calculations with Excel functionsLearn to use documentation so that you can work with every functionLearn to visually represent your data: charts, trendlines, sparklines, combo chartsLearn to use Excel data tools like sorting, subtotaling, and filteringLearn to "freeze columns and rows" with freeze panes in ExcelLearn to remove duplicates from data in ExcelLearn to "transpose data" - switching the columns and rows in ExcelLearn to use Excel to leverage data with Pivot Tables & Pivot ChartsLearn to format worksheets including conditional formattingLearn to automate Excel tasks with time-saving macrosLearn to integrate Microsoft Excel with Microsoft WordLearn to use passwords in Excel to protect your work in multiple scenariosLearn tips and tricks about Excel, as well as Excel secrets and shortcutsLearn to use printing and sharing in ExcelLearn to harvest data from the webLearn to create powerful random data generatorsLearn to use freeze panes, sorting, filtering, & advanced filteringLearn to "what if" sensitivity analysis such as goal seek, scenarios, & data tablesLearn to use multiple windows, selection panes, proofing, & translating toolsLearn to print your worksheets with various formatting to various formats including PDFLearn to use pivot tables, slicers, timelines, & pivot chartsLearn to apply styles, themes, stats, accessibility, watch & calculation optionsLearn to use get & transform and the power query editorLearn to use the data model and to create relationships between your dataLearn to work with data joins and to append dataLearn to use 3D maps and to create recorded scenesLearn to program Microsoft Excel with VBA (Visual Basic for Applications)Download all of the Excel project files that are used in the videosDescribed 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.

Skills

Reviews