Microsoft Excel Complete Course 2019

Overview:

The Microsoft Excel Complete Course 2019 is designed for individuals seeking to master one of the most powerful tools in data management and analysis. This comprehensive course covers everything from basic functionalities to advanced features, enabling participants to effectively utilize Excel in various professional settings. Topics include data entry, formatting, formulas, functions, pivot tables, and data visualization techniques. Through interactive lessons and hands-on projects, learners will gain practical experience and develop problem-solving skills that can be applied in real-world scenarios. The course also addresses best practices for data organization and analysis, ensuring participants can efficiently manage large datasets. By the end of this course, students will not only be proficient in Excel but also confident in their ability to leverage its features for better decision-making and increased productivity in their work environments.

Learning Outcomes:

  • Navigate and utilize Microsoft Excel 2019 efficiently.
  • Create and format spreadsheets for various purposes.
  • Apply formulas and functions for data analysis.
  • Generate pivot tables and charts for data visualization.
  • Implement best practices for data management and organization.

Description:

This course offers a thorough exploration of Microsoft Excel 2019, combining theoretical knowledge with practical applications. Participants will engage in step-by-step tutorials and real-world examples, making complex concepts accessible. By working on hands-on projects, learners will build a strong foundation in Excel functionalities, enhancing their ability to analyze and present data effectively. The course is structured to accommodate all skill levels, ensuring a comprehensive learning experience.

Who is this Course For?

This course is ideal for students, professionals, and anyone looking to enhance their Excel skills for academic or workplace success. Whether you are a beginner wanting to learn the basics or an experienced user seeking to expand your knowledge, this course is designed to meet your needs.

Career Path:

Completing the Microsoft Excel Complete Course can lead to various career opportunities such as data analyst, financial analyst, administrative assistant, and project manager. Proficiency in Excel is highly valued across industries, making it an essential skill for career advancement and effective data management.

Curriculum

  • Microsoft Excel 2019 New Features
    • Introduction to Microsoft Excel 2019 New Features (00:07:00)
    • CONCAT (00:02:00)
    • IFS (00:01:00)
    • MAXIFS (00:01:00)
    • MINIFS (00:01:00)
    • SWITCH (00:02:00)
    • TEXTJOIN (00:01:00)
    • Map Chart (00:02:00)
    • Funnel Chart (00:01:00)
    • Better Visuals (00:06:00)
    • Pivot Table Enhancements (00:02:00)
    • Power Pivot Updates (00:01:00)
  • Getting Started with Microsoft Office Excel
    • Navigate the Excel User Interface (00:28:00)
    • Use Excel Commands (00:10:00)
    • Create and Save a Basic Workbook (00:19:00)
    • Enter Cell Data (00:12:00)
    • Use Excel Help (00:05:00)
  • Performing Calculations
    • Create Worksheet Formulas (00:15:00)
    • Insert Functions (00:17:00)
    • Reuse Formulas and Functions (00:17:00)
  • Modifying a Worksheet
    • Insert, Delete, and Adjust Cells, Columns, and Rows (00:10:00)
    • Search for and Replace Data (00:09:00)
    • Use Proofing and Research Tools (00:07:00)
  • Formatting a Worksheet
    • Apply Text Formats (00:16:00)
    • Apply Number Format (00:08:00)
    • Align Cell Contents (00:09:00)
    • Apply Styles and Themes (00:12:00)
    • Apply Basic Conditional Formatting (00:11:00)
    • Create and Use Templates (00:08:00)
  • Printing Workbooks
    • Preview and Print a Workbook (00:10:00)
    • Set Up the Page Layout (00:09:00)
    • Configure Headers and Footers (00:07:00)
  • Managing Workbooks
    • Manage Worksheets (00:05:00)
    • Manage Workbook and Worksheet Views (00:07:00)
    • Manage Workbook Properties (00:06:00)
  • Working with Functions
    • Work with Ranges (00:18:00)
    • Use Specialized Functions (00:12:00)
    • Work with Logical Functions (00:24:00)
    • Work with Date & Time Functions (00:08:00)
    • Work with Text Functions (00:11:00)
  • Working with Lists
    • Sort Data (00:10:00)
    • Filter Data (00:10:00)
    • Query Data with Database Functions (00:09:00)
    • Outline and Subtotal Data (00:09:00)
  • Analyzing Data
    • Apply Intermediate Conditional Formatting (00:07:00)
    • Apply Advanced Conditional Formatting (00:06:00)
  • Visualizing Data with Charts
    • Create Charts (00:13:00)
    • Modify and Format Charts (00:12:00)
    • Use Advanced Chart Features (00:12:00)
  • Using PivotTables and PivotCharts
    • Create a PivotTable (00:13:00)
    • Analyze PivotTable Data (00:12:00)
    • Present Data with PivotCharts (00:08:00)
    • Filter Data by Using Timelines and Slicers (00:11:00)
  • Working with Multiple Worksheets and Workbooks
    • Use Links and External References (00:12:00)
    • Use 3-D References (00:06:00)
    • Consolidate Data (00:06:00)
  • Using Lookup Functions and Formula Auditing
    • Use Lookup Functions (00:13:00)
    • Trace Cells (00:09:00)
    • Watch and Evaluate Formulas (00:09:00)
  • Sharing and Protecting Workbooks
    • Collaborate on a Workbook (00:20:00)
    • Protect Worksheets and Workbooks (00:08:00)
  • Automating Workbook Functionality
    • Apply Data Validation (00:13:00)
    • Search for Invalid Data and Formulas with Errors (00:04:00)
    • Work with Macros (00:18:00)
  • Creating Sparklines and Mapping Data
    • Create Sparklines (00:07:00)
    • MapData (00:07:00)
  • Forecasting Data
    • Determine Potential Outcomes Using Data Tables (00:09:00)
    • Determine Potential Outcomes Using Scenarios (00:09:00)
    • Use the Goal Seek Feature (00:04:00)
    • Forecasting Data Trends (00:06:00)
  • Excel VBA Data Management
    • Create a Macro Using the Macro Recorder (00:00:00)
    • Edit a Macro (00:00:00)
    • Debug a Macro (00:00:00)
    • Customize the Quick Access Toolbar and Hotkeys (00:00:00)
    • Set Macro Security (00:00:00)
    • Insert Text (00:00:00)
    • Format Text (00:00:00)
    • Sort Data (00:00:00)
    • Duplicate Data (00:00:00)
    • Generate a Report (00:00:00)
    • Determine the Dialog Box Type (00:00:00)
    • Capture User Input (00:00:00)
    • Insert, Copy, and Delete Worksheets (00:00:00)
    • Rename Worksheets (00:00:00)
    • Modify the Order of Worksheets (00:00:00)
    • Print Worksheets (00:00:00)
    • Create User-Defined Functions (00:00:00)
    • Automate SUM Functions (00:00:00)
    • Activities and Exercise Files – Microsoft Excel 2016 and VBA (00:00:00)
  • Excel Templates
    • Excel Templates (00:00:00)

price : 50 $