Advance Excel 2019

1965 Ratings (4.8)

Microsoft Excel is the industry standard spreadsheet program used for data calculations, analysis, visualization and much more. It can be programmed to access data from external databases and is an excellent tool for data modeling, statistics and financial calculations with built-in functions to quickly and easily perform common tasks. Proficiency in Excel is typically required for accounting, business analytics, data analysis and statistics jobs.

active-directory-services-with-windows-server
request

Can’t find a batch you were looking for?

About the course

Advanced Excel course is designed for students/professionals who want to learn advanced features of Excel for generating smart reports with lots of time-saving which they can use it for other tasks. In addition, ADVANCED EXCEL course is also useful to people who want to clear the Microsoft certification for MS Excel (MOS) 2013/2016. Learn how to set up an Excel sheet, perform calculations, use basic and advanced Excel formulas and create visual representations of data with charts and graphs. Learn how to quickly create different views of data with pivot tables and much more, directly from the Excel team at Microsoft. Additional Excel training courses explore the more advanced statistics and data visualization features of the software.

Learn about descriptive statistics, basic probability, random variables, Excel VBA, sampling and hypothesis testing. Perform data mashups and visualizations using data pulled from multiple sources. Some other elements you will learn on Microsoft Excel include conditional formatting, pivot tables, keyword shortcuts, and more. The advanced features courses are part of the Microsoft Professional Program Certificate in Data Science, a specialization designed to get learners on a path to a career in data science or related field. If you've been looking to learn Excel, you've come to the right place.

Course Contents

The Basics
  • Creating a New Workbook
  • Navigating in Excel
  • Moving the Cell Pointer
  • Using Excel Menus Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars
  • Entering Values in a Worksheet and Selecting a Cell Range
  • Previewing and Printing a Worksheet
  • Getting Help from the Office Assistant
  • Saving a Workbook & Re-opening a saved workbook
Formatting a Worksheet
  • Creating Headers, Footers, and Page Numbers
  • Adjusting Page Margins and Orientation
  • Adding Print Titles and Gridlines, rows to repeat at top of each page
  • Adjusting Row Height and Column Width
  • Formatting Fonts & Values
  • Changing Cell Alignment
  • Adding Borders
  • Applying Colors and Patterns
  • Using the Format Painter
  • Using AutoFormat
  • Merging Cells, Rotating Text, and using AutoFit
  • Using AutoFill
To see the full course content Download now
active-directory-services-with-windows-server

Course Prerequisites

Basic knowledge about computers

Who should attend?

  • This Microsoft Excel courses will take you through 4 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced and Macros/VBA).
  • If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.

Number of Hours: 40hrs

Certification

Microsoft Office Specialist: Excel Associate (MO-200)

Keyfeatures

  • One to One Training
  • Online Training
  • Fastrack & Normal Track
  • Resume Modification
  • Mock Interviews
  • Video Tutorials
  • Materials
  • Real Time Projects
  • Virtual Live Experience
  • Preparing for Certification

FAQs

TechyEdz in BTM Layout 2nd Stage offers long-term courses, short-term courses and certification courses. Inclusive of comprehensive learning, the long-term program feature subjects such as Web- Development, Digital Marketing, Computer Application and Programming, Information Technology and Data Science. Some of the short-term courses cover topics like Cloud, RPA, Big Data, Microsoft, VMware & Oracle. Walk into this center all through the week between 07:00am – 09:00pm. Pay in Cash, Debit Cards, Credit Card and Online Payment.

TechyEdz Software Specialization in developing customized suite of HR consulting solutions based on the operational models of our clients with a special focus on small & Large Enterprises. We bring practical, results driven HR Practice to our clients business that would help them retain people, Improve business productivity and performance of employee.

TechyEdz Software Specialization in developing customized suite of HR consulting solutions based on the operational models of our clients with a special focus on small & Large Enterprises. We bring practical, results driven HR Practice to our clients business that would help them retain people, Improve business productivity and performance of employee.