Advanced Excel Learners Point Training Institute
Advanced Microsoft Excel 2016 training course is conceptualized to build the skills required to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. By using its advanced features like formulas, you can crunch data, analyze and get simple solutions to most complex questions.
Course Topics
Lesson 1: Using Custom & Conditional Formats
Lesson 2: Using Range Names
Lesson 3: Using Formulas & Functions
Lesson 4: Managing, Sorting & Filtering Tables
Lesson 5: Working with Charts in Excel 2016
Lesson 6: Working with Pivot Tables
Lesson 7: Working with Shared Workbooks
Lesson 8: Working with Multiple Workbooks
Lesson 9: Protecting Your Worksheet and Workbook
Lesson 10: Working with Excel Macros
Course Topics
Lesson 1: Using Custom & Conditional Formats
- Reasons for Using Custom Format
- Understanding Conditional Formatting
- Managing the Conditional Format Rules
- Changing the Conditional Formatting Rules
- Locating Cells with Conditional Formatting
- Working with Conditional Formatting
Lesson 2: Using Range Names
- Assigning Names to Groups of Cells
- Managing Named Range
- Using Names in Formulas
Lesson 3: Using Formulas & Functions
- Understanding Formulas & Functions
- Quick Way to Insert a Function
- Viewing the Formulas (and not the results)
- How to Delete Values and not Formulas
- Create a Relative & Absolute Reference
- Working with Logical Functions
- Using SUMIF and COUNTIF Functions
- Working with Text Functions
- Working with Date and Time Functions
- Working with Lookup Functions
- Understanding VLOOKUP Function
Lesson 4: Managing, Sorting & Filtering Tables
- Create and Modify Tables
- Sorting and Filtering Data in a Table
- Getting Summary Information in a Table
- Calculate Total Row in a Table
- Display Special Formatting for First/Last Column
- Outline a List of Data
- Validating Data During Entry
- Working with Database Functions
- Using Advanced Filters in Excel 2016
- Quick Analysis With New Features of Excel 2016
Lesson 5: Working with Charts in Excel 2016
- Summarizing Data Visually Using Charts
- Creating a Chart Quickly
- Changing the Chart Type
- Customizing Chart Data
- Show or Hide Chart Gridlines
- Creating a Pie Chart
- Saving the Chart as a Template
- Creating Combination Charts
- Using The New Pareto Chart Functionality
- Using Recommended Charts Effectively
Lesson 6: Working with Pivot Tables
- What is a Pivot Table
- Anatomy of a Pivot Table
- How does a Pivot Table Works
- Create a Basic Pivot Table Report
- Rearranging a Pivot Table Report
- Customizing a Pivot Table
- Changing Summary Calculations
- Adding and Removing Subtotals
- Sorting in a Pivot Table
- Filtering in a Pivot Table
- Create Report Filter Pages
- Using Slicers in Pivot Table
- Working with Pivot Chart
Lesson 7: Working with Shared Workbooks
- Working in a Group Environment
- Sharing Workbooks in Excel
- Commenting in Cells
- Tracking Changes in Workbooks
- Accepting or Rejecting Changes
- Keeping a Backup of your Changes
Lesson 8: Working with Multiple Workbooks
- Linking to Other Workbook
- Consolidating Multiple Sets of Data
- Consolidate Multiple Worksheets
Lesson 9: Protecting Your Worksheet and Workbook
- Protecting Your Worksheet
- Protecting Your Formulas
- Protecting Your Workbook
- Save Your Workbook with Password
- Encrypting your Workbook
Lesson 10: Working with Excel Macros
- Recording & Testing a Macro
- Using the Developer Tab
- Create a Macro
- Relative and Absolute Recording
- Testing the Macro
- Running and Deleting Macros
- Using a Shortcut key
- Placing a Macro on the Quick Access Toolbar
- Short Introduction to Macro Programming in
Excel 2016
هذه الدورة التدريبية لم تعد متاحة.
السعر: 327 USD
409 USD
تدريب إفتراضي أونلاين. المحاضرات قد تكون فردية أو ضمن مجموعة.
- مدة الدورة التدريبية: Upto 16 Hours
- مواعيد الدورة: Part Time, Flexible
تفاصيل الدورة
Advanced Microsoft Excel 2016 training course is conceptualized to build the skills required to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. By using its advanced features like formulas, you can crunch data, analyze and get simple solutions to most complex questions.Course Topics
Lesson 1: Using Custom & Conditional Formats
- Reasons for Using Custom Format
- Understanding Conditional Formatting
- Managing the Conditional Format Rules
- Changing the Conditional Formatting Rules
- Locating Cells with Conditional Formatting
- Working with Conditional Formatting
Lesson 2: Using Range Names
- Assigning Names to Groups of Cells
- Managing Named Range
- Using Names in Formulas
Lesson 3: Using Formulas & Functions
- Understanding Formulas & Functions
- Quick Way to Insert a Function
- Viewing the Formulas (and not the results)
- How to Delete Values and not Formulas
- Create a Relative & Absolute Reference
- Working with Logical Functions
- Using SUMIF and COUNTIF Functions
- Working with Text Functions
- Working with Date and Time Functions
- Working with Lookup Functions
- Understanding VLOOKUP Function
Lesson 4: Managing, Sorting & Filtering Tables
- Create and Modify Tables
- Sorting and Filtering Data in a Table
- Getting Summary Information in a Table
- Calculate Total Row in a Table
- Display Special Formatting for First/Last Column
- Outline a List of Data
- Validating Data During Entry
- Working with Database Functions
- Using Advanced Filters in Excel 2016
- Quick Analysis With New Features of Excel 2016
Lesson 5: Working with Charts in Excel 2016
- Summarizing Data Visually Using Charts
- Creating a Chart Quickly
- Changing the Chart Type
- Customizing Chart Data
- Show or Hide Chart Gridlines
- Creating a Pie Chart
- Saving the Chart as a Template
- Creating Combination Charts
- Using The New Pareto Chart Functionality
- Using Recommended Charts Effectively
Lesson 6: Working with Pivot Tables
- What is a Pivot Table
- Anatomy of a Pivot Table
- How does a Pivot Table Works
- Create a Basic Pivot Table Report
- Rearranging a Pivot Table Report
- Customizing a Pivot Table
- Changing Summary Calculations
- Adding and Removing Subtotals
- Sorting in a Pivot Table
- Filtering in a Pivot Table
- Create Report Filter Pages
- Using Slicers in Pivot Table
- Working with Pivot Chart
Lesson 7: Working with Shared Workbooks
- Working in a Group Environment
- Sharing Workbooks in Excel
- Commenting in Cells
- Tracking Changes in Workbooks
- Accepting or Rejecting Changes
- Keeping a Backup of your Changes
Lesson 8: Working with Multiple Workbooks
- Linking to Other Workbook
- Consolidating Multiple Sets of Data
- Consolidate Multiple Worksheets
Lesson 9: Protecting Your Worksheet and Workbook
- Protecting Your Worksheet
- Protecting Your Formulas
- Protecting Your Workbook
- Save Your Workbook with Password
- Encrypting your Workbook
Lesson 10: Working with Excel Macros
- Recording & Testing a Macro
- Using the Developer Tab
- Create a Macro
- Relative and Absolute Recording
- Testing the Macro
- Running and Deleting Macros
- Using a Shortcut key
- Placing a Macro on the Quick Access Toolbar
- Short Introduction to Macro Programming in
Excel 2016
وظائف مناسبة لهذه الدورة
Secretary / Adm Assistant , Sales Team Leader , الموارد البشرية , Senior Managerنبذة عن معهد Learners Point Training Institute
Learners Point is a Leading Educational Institute in Dubai which has been providing trainings for different educational and management development programs, operating for more than 12 years, educating more than 10,000 students. Located at the heart of Dubai, Learners Point has made a benchmark in providing cutting edge, cost effective, relevant and timely trainings that are guaranteed to widen your scope and to ensure a bright and progressive career. At Learners Point, you are provided with latest state of the art physical facilities and a friendly learning atmosphere powered by highly qualified professionals.We pride ourselves on our service and are totally committed to providing professional, practical and very personalised tuition. We offer training for individuals, small business, large corporations and government sectors. Our specialty is personalised small group training where we provide a fun, relaxed and personal service to all our clients.
Based on our extensive experience in the market we have formulated corporate training solutions tailor made for our clients covering a wide range of topics like Customer Service, Sales and Marketing techniques, Information Technology (Microsoft Certifications, Cisco Certifications, etc), Human Resource (HR) Management Course, Languages (English, Arabic & French) and Accounting Courses to mention but a few. With our customer service approach, pre-course and post-course consulting and assessments are critical to effectively customizing our certification courses to meet your training goals.
Our all trainers have had years of experience in the training industry and have extensive knowledge in their specific training field. Whatever your needs are in relation to IT, Management, HR and Languages, we have a training course available that will suit you!
If you are looking for a professional approach to dilate your professional scope, look no further. Just join Learners Point Training Centre and learn Today the EZ Way!. عرض الجميع دورات Learners Point Training Institute
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Microsoft Excel ابتداءً من الآن.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoonدرهم 1,449مدة الدورة التدريبية: Upto 30 Hours
- Microsoft Excel & Accounting StudyHub13 USD
260 USDمدة الدورة التدريبية: Upto 18 Hours - Excel 2010: Essentials 1TRAINING22 USD
153 USDمدة الدورة التدريبية: Upto 8 Hours
