Microsoft Excel Mastery: From Beginner to Pro

Microsoft Excel Mastery: From Beginner to Pro, available at $54.99, has an average rating of 4.1, with 63 lectures, based on 710 reviews, and has 52270 subscribers.

You will learn about Worksheet basics: Creating a worksheet, Entering data automatically with Auto Fill, Inserting/deleting cells, columns, and rows, and cell formatting. Excel Formula Basics: Adding numbers using Sum and AutoSum, working with numbers in columns, using IF, using SUMIF and AVERAGEIF, naming and using cell ranges. Excel Formatting: Adjusting fonts, colors, adding pictures, shapes and borders, inserting SmartArt, built-in styles and creating and using templates. Printing: Inserting headers and footers, generating PDFs. Data Analysis: Named ranges, data validation, data sorting and filtering, working with goal seek and using the scenario manager in excel. Dealing with large data: Using Find and Replace, managing worksheets, applying formulas across multiple worksheets. Discovering PivotTables: Creating and modifying a PivotTable and a PivotChart. Charts: Choosing chart types, inserting sparklines, creating and modifying a column chart and a pie chart. Macros: Understanding, recording, using and editing a macro. This course is ideal for individuals who are Students who have little or no familiarity with Microsoft Excel or more experienced Excel users who want to learn the topics covered in this course. It is particularly useful for Students who have little or no familiarity with Microsoft Excel or more experienced Excel users who want to learn the topics covered in this course.

Enroll now: Microsoft Excel Mastery: From Beginner to Pro

Summary

Title: Microsoft Excel Mastery: From Beginner to Pro

Price: $54.99

Average Rating: 4.1

Number of Lectures: 63

Number of Published Lectures: 63

Number of Curriculum Items: 63

Number of Published Curriculum Objects: 63

Original Price: $24.99

Quality Status: approved

Status: Live

What You Will Learn

Worksheet basics: Creating a worksheet, Entering data automatically with Auto Fill, Inserting/deleting cells, columns, and rows, and cell formatting.
Excel Formula Basics: Adding numbers using Sum and AutoSum, working with numbers in columns, using IF, using SUMIF and AVERAGEIF, naming and using cell ranges.
Excel Formatting: Adjusting fonts, colors, adding pictures, shapes and borders, inserting SmartArt, built-in styles and creating and using templates.
Printing: Inserting headers and footers, generating PDFs.
Data Analysis: Named ranges, data validation, data sorting and filtering, working with goal seek and using the scenario manager in excel.
Dealing with large data: Using Find and Replace, managing worksheets, applying formulas across multiple worksheets.
Discovering PivotTables: Creating and modifying a PivotTable and a PivotChart.
Charts: Choosing chart types, inserting sparklines, creating and modifying a column chart and a pie chart.
Macros: Understanding, recording, using and editing a macro.

Who Should Attend

Students who have little or no familiarity with Microsoft Excel or more experienced Excel users who want to learn the topics covered in this course.

Target Audiences

Students who have little or no familiarity with Microsoft Excel or more experienced Excel users who want to learn the topics covered in this course.

Microsoft Excel: Comprehensive Training for Beginners & Intermediates – Unlock Efficiency with Essential Excel Skills

Looking to refine your Excel abilities and enhance productivity? Our Microsoft Excel 2016 training course is designed specifically for beginners and intermediates seeking to develop essential Excel skills.

This user-friendly Excel course covers a range of essential Excel features and functions, providing a solid foundation in Excel for efficient and effective work. Key topics include:

Worksheet Foundations: Generate worksheets, utilize Auto Fill, insert/delete cells, columns, rows, and format cells for optimal organization.
Excel Formula Fundamentals: Utilize Sum and AutoSum, manage numbers in columns, apply IF, SUMIF, AVERAGEIF, and handle cell ranges effectively for accurate calculations.
Excel Formatting Techniques: Customize fonts, colors, insert images, shapes, borders, implement SmartArt, apply built-in styles, and design templates for visually appealing presentations.
Printing Essentials: Add headers/footers and create PDFs effortlessly, ensuring professional documentation.
Data Analysis Tools: Master named ranges, data validation, sorting, filtering, goal seek, and scenario manager to analyze and manipulate data with precision.
Managing Large Data Sets: Employ Find/Replace, organize worksheets, and apply formulas across multiple worksheets for streamlined data handling.
PivotTable Proficiency: Design, modify, and evaluate data with PivotTables and PivotCharts for deeper insights and informed decision-making.
Charting Expertise: Choose chart types, incorporate sparklines, create/modify column and pie charts for clear data visualization and effective communication.
Macros Mastery: Learn, record, implement, and edit macros for seamless automation, saving time and enhancing productivity.
Bonus Tips & Tricks: Alongside the core learning modules, we’ll also share valuable tips and tricks to help you navigate Excel 2016 with ease and confidence.

Enroll now and gain a competitive edge in your personal and professional endeavors with hands-on, practical learning. Master essential Excel skills, elevate your productivity, and unlock efficiency with our Excel 2016 course for beginners and intermediates!

Course Curriculum

Chapter 1: Getting Started

Lecture 1: What is Excel used for? Exploring common uses

Lecture 2: Getting Familiar with Excel Interface

Lecture 3: Navigating the Ribbon Bar and Finding Commands

Lecture 4: Using the File Tab

Chapter 2: Worksheet Basics

Lecture 1: Creating Your First Worksheet

Lecture 2: Different methods for copying and pasting

Lecture 3: Using Auto Fill to Automatically Enter Data

Lecture 4: Selection Techniques for Large Data Range

Lecture 5: Inserting Cells

Chapter 3: Formula Basics

Lecture 1: Introduction to Formulas, Functions and Cell References

Lecture 2: How to Sum Numbers in Excel Manually

Lecture 3: How to Sum Numbers in Excel Using Sum and AutoSum

Lecture 4: How to AutoSum Across All Worksheet

Lecture 5: How to Use Average, Max, Min and Count Functions in Excel

Lecture 6: Using Absolute Cell References

Lecture 7: Display Current Date and Time in a Worksheet

Lecture 8: How to Use the Excel IF Function

Lecture 9: SUMIF and AVERAGEIF Functions in Excel

Lecture 10: How to Create Named Ranges in Excel

Chapter 4: Basic Excel Formatting Techniques

Lecture 1: Excel Dates and Numbers Formatting

Lecture 2: How to apply fonts, background colors, and borders in Excel

Lecture 3: How to Adjust Rows, Columns and Text in Excel

Lecture 4: How to Apply Conditional Formatting in Excel

Lecture 5: How to Customize Excel Conditional Formatting

Lecture 6: How to Add Pictures and Shapes in Excel

Chapter 5: Advanced Excel Formatting Techniques

Lecture 1: How to Add SmartArt Graphics to Your Excel Worksheets

Lecture 2: Using Themes to Change the Appearance of Your Worksheet

Lecture 3: Apply, Create or Merge Cell Styles in Excel

Lecture 4: How to Use and Create Templates in Excel

Chapter 6: Printing in Excel

Lecture 1: Preparing Your Worksheet for Printing

Lecture 2: Headers and Footers, Margins and Print Titles

Lecture 3: Printing and Generating a PDF

Chapter 7: Dealing With Large Data Sets

Lecture 1: Find or Replace Data on a Worksheet

Lecture 2: Freezing Panes to Lock Rows and Columns

Lecture 3: How to Use Excel Custom Views Like a Pro

Lecture 4: How to Hide and Group Rows or Columns in Excel

Lecture 5: Easy Ways to Manage Excel Worksheets

Lecture 6: Calculating Values Across Worksheets with Formulas

Chapter 8: Sharing and Collaborating on Excel Data

Lecture 1: What You Need to Know About Importing and Exporting in Excel

Lecture 2: How to Protect Workbooks, Worksheets, and Cells From Editing in Microsoft Excel

Lecture 3: Adding Comments to Cells in Excel

Lecture 4: How To Share An Excel File For Easy Collaboration

Chapter 9: Database in Excel

Lecture 1: Splitting Cells Into Multiple Columns

Lecture 2: Joining Cells Into One Column

Lecture 3: Sorting and Filtering Data in Excel

Lecture 4: Working With Tables

Lecture 5: Creating Subtotals

Lecture 6: Creating Formulas that LOOK UP Values Using VLOOKUP and HLOOKUP

Chapter 10: Analyzing Data in Excel

Lecture 1: Using Goal Seek

Lecture 2: Using Solver

Lecture 3: Creating Data Tables

Lecture 4: Using The Scenario Manager

Chapter 11: Analyzing Data With Pivot Tables

Lecture 1: Understanding and Creating a Pivot Table

Lecture 2: How to Edit your Pivot Table

Lecture 3: Creating and Editing a Pivot Chart

Chapter 12: Charts

Lecture 1: Hands On: Creating and Customizing a Chart

Lecture 2: Creating a Pie Chart

Lecture 3: Creating a Line Chart

Lecture 4: Use Sparklines to Show Data Trends

Chapter 13: Macros

Lecture 1: Introduction to Macros

Lecture 2: Recording and Running a Macro

Lecture 3: Editing and Saving a Macro

Chapter 14: Exercise Files

Lecture 1: Exercise Files

Instructors

Prof. Samer
Professor of Mechanical Engineering

Rating Distribution

1 stars: 10 votes
2 stars: 17 votes
3 stars: 96 votes
4 stars: 260 votes
5 stars: 327 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu