Microsoft Excel Mastery: From Beginner to Pro
What you'll 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.
Requirements
- Nothing! This course assumes you are a beginner to Excel.
Description
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!
Who this course is 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.
Instructor
Samer is currently a Professor of Mechanical Engineering. He has ten years of teaching experience in thermo-fluid courses which include:
1-Engineering Thermodynamics
2-Heat Transfer
3-Internal Combustion Engines
4-Fluid Mechanics
5-HVAC
6-Power Plant Engineering
7-Solar Engineering
8-Computational Fluid Dynamics CFD
Moreover, Prof. Samer is involved in a wide research projects in Computational Fluid Dynamics (CFD), Fluid-Structure Interaction and numerical simulations applied to multi-functional heat exchangers/reactors. Prof. Samer has authored and co-authored several highly cited journal publications, conferences in the aforementioned topics.