Excel Training Ppt

Jan 16, 2018 Microsoft Excel for Beginners 2.0 hours This is a basic computer workshop. Microsoft Excel is a spreadsheet program. We use it to create reports that need calculations and charts. In this workshop we will learn how to move around and work inside the spreadsheet. Jan 19, 2013 if you have two cells selected, excel will fill in a series. It will complete the pattern.for example,if you put 4 and 8 in two cells select them,click and drag the fill handle,excel will continue the pattern with 12,16,20.etc. Excel can also auto- fill series of dates, times, days of the week, months.

Dear All, Please find attached PPT for your knowledge, i have created this presentation for my company employees. see and post your comment.
From India, New Delhi
Attached Files
Basic excel training - 20140825.ppt (1.96 MB, 3839 views)

I have full basic knowledge of MS Excel. So i want to some additional information in excel. Some main formulas for save the time during making a big reports.
From India, Bhopal

If you are knowledgeable about any other fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

#Subject List:advanced excelCity-India-New-DelhiCountry-India

Microsoft Excel was first released in 1985 and it is still one of the most widely used and comprehensive spreadsheet programs today. Thanks to its functionality, Excel provides a variety of organizations and users simplified data solutions including, basic calculations, advanced data analysis, and data visualization. Having any skill level in this program is truly beneficial because Excel proficiency is in high demand by employers. And now users can leverage business intelligence tools within Excel to easily manipulate and combine data from multiple touchpoints.

ONLC offers multiple Excel learning formats, course levels and focuses. With our training you'll learn to create spreadsheets, data, calculations and more. In addition to furthering your Excel skills, you can use our courses to prep for professional certification—one of the best ways to prove your Excel skills and knowledge.

For additional assistance contact an ONLC Advisor via our chat icon on this page or 1-800-288-8221 (weekdays).

Excel Training Options Tailored to Your Learning Style

With ONLC, you can pick the experience that’s best for your learning style, schedule, education budget and desired outcome. For most people, live, hands-on training that's led and supported by a professional instructor is the most effective and efficient way to learn.

Instructor-led Training (ILT)

Instructor-led training (ILT) classes are live, hands-on training. Training is fully interactive and led via remote instructor. We offer all Excel titles on our regular daytime schedule which you may attend from one of ONLC's hundreds of training centers or from your own location .

On-Demand Training (self-study / eLearning)

On-Demand courses are self-study, self-paced you take using your own equipment. On-Demand courses may include video tutorials, live labs and assessments. You have 24/7 access to your course for a set duration. See On-Demand course titles.

Single Course or Bundled Savings

Just need one course? Pick a public course title from our full Excel class list. Need multiple courses or MOS certification prep? Our Excel bundles provide savings on training in the format you prefer plus offer bonus features.

Basic Excel Training Powerpoint

Custom & Private Excel Group Training

ONLC has options for groups that can help training coordinators, HR managers and Team Leaders upskill their group's skill successfully while staying on budget.

  • Public Classes. Pre-purchase our public training to receive volume discounting! Those coordinating training find this option very effective and efficient. With the discount established upfront, there’s no need to negotiate pricing on every registration. Participants can register themselves by phone or web, and the coordinator can access reporting to track, monitor and confirm training.
  • Private Classes. When group training is private course content can be customized and we can use a variety of learning formats to meet learning objectives, schedules and budgets.
Complete our quick Group Training Request form so together we can explore best options for your needs and we can provide a group training price quote.

Excel Class Titles & Schedule

Click course title for outline & dates (when applicable)

Excel Instructor-led (ILT)

Click the title of the classes marked with the green flag () to see specific locations and dates of Ready to Run classes. Click the title of the classes marked with the yellow flag () to see specific locations and dates of Early Notice classes.
Class Information
Click Title for Dates & OutlinesDaysFee
Excel Core Skills & Topic-Specific Classes
Excel Introduction 1$295
Excel Charts, Formatting and Reporting 1$295
Excel Database Features and PivotTables 1$295
Excel Workbooks, Formulas and Functions 1$295
Excel Mixed-Topic Classes for Intermediate Users
Excel Tips, Tricks and Timesavers 1$295
Excel Power User 2$795
Microsoft BI Tool Series
Microsoft BI Tools: PowerPivot and Interactive Visualizations 3$1495
Microsoft BI Tools: DAX Formulas for Dynamic Tables 2$995
Microsoft BI Tools: Get and Transform Data 1$495
Microsoft BI Tools: Power BI for Excel Users 2$795
Excel Special Topics
Excel Forecasting and What-If Analysis 1$395
Excel Macros 1$395
Excel Programming with VBA 3$1195
Microsoft Official: Excel Analytics & Business Intelligence (Can Pay with SA Vouchers)
20779: Analyzing Data with Excel 3$1595
10994: Data Analysis Fundamentals Using Excel 2$995

Excel On-Demand (self-study, eLearning)

Class Information
Click Title for Dates & OutlinesDaysFee
Core Office Courses
Excel 2019 On-Demand: Comprehensive (Parts 1, 2, & 3) 3$495
Excel 2016 On-Demand: Comprehensive (Basic, Intermediate & Advanced) 3$495
Microsoft BI Tool Series
Microsoft BI Tools On-Demand: Power BI for Excel Users 2$495
Microsoft BI Tools On Demand: Power BI Intermediate 2$595
Microsoft BI Tools On-Demand Bundle: Power BI for Excel Users & Power BI Intermediate 4$795
Excel Special Topics
Excel On-Demand: Excel 2013/2016 Programming with VBA 3$695
Related Topics
Office 2019 On-Demand: Comprehensive (Excel, Word, Outlook, PowerPoint, Access) 14$995

Other Microsoft Office Classes

See all Microsoft Office training classes

With real-world experience, our Excel instructors ensure that lessons and course materials are applicable for job responsibilities. We offer courses for all levels of Excel users. Learning Excel will let you increase productivity and speed up daily tasks. Our Excel curriculum includes courses in which you could learn:

  • Excel basics, formulas, charts and database features
  • Excel data visualizations for advanced data and trend analysis
  • Excel for business intelligence (BI) forecasting and reporting
  • Basic formulas
  • Pivot Tables Charts
  • Macros
  • Programming with VBA
  • Workbooks
  • Business Intelligence (BI) tools

Excel Courses for Core Skills

Ms Excel Training Ppt

Having fundamental experience with Excel is almost a necessity as Excel skills are in high demand by employers. Having that skill set may also provide advancement opportunities. Kingsoft corporation wps office. The following courses will give you the core skills Excel users need.

Excel Introduction 365, 2019, 2016

During this one-day instructor-led, hands-on course you'll learn to create basic Excel spreadsheets.
View outline & dates

Excel Charts, Formatting & Reporting

Learn the essentials regarding visualizations in Excel. During this one-day, instructor-led course you'll create charts, use styles and templates and manage advanced worksheet formatting.
View outline & dates

Excel Database Features & Pivot Tables

During this one-day, instructor-led course you'll learn the essentials regarding managing data and creating PivotTables in Excel. Students will create tables; import, modify and analyze data; create and enhance PivotTables.
View outline & dates

Excel Workbooks, Formulas & Functions

Excel training ppt free download

This one-day class covers the essentials of managing large worksheets, creating models, and working financial, date, and logical functions.
View outline & dates

Excel Power User Courses

Many who use Excel don't really know how to take advantage of all its features. These courses leverage advanced features and provide time-saving Excel techniques.

Excel Tips, Tricks & Timesavers

One of our most popular Excel courses, this training provides an overview of Excel’s most used features, teaching you timesaving options in Excel.
View course outline & dates

Excel Power User

Excel Training Ppt 2016

This two-day instructor-led, hands-on course provides a high-level Excel overview, covering chart formatting and reporting, database features, pivot tables, how to leverage workbooks, formulas and functions.
View course outline & dates

Excel Programming with VBA

This three-day instructor-led, hands-on course teaches advanced Excel techniques. Students will learn how to use the Visual Basics of Application (VBA) language and Excel objects, including Pivot Tables.
View course outline & dates

Excel Forecasting & What If Analysis

Excel Training Ppt Free Download

This instructor-led, hands-on course teaches the many built-in features and add-ons that make it easier to develop complex models that incorporate What-If Analysis.
View course outline & dates

Excel Training Ppt Download

Excel Business Intelligence (BI) Courses

Business intelligence tools provide data analysis solutions for organizations with large quantities of data or multiple data touchpoints. With Excel Power BI, users are able to store and share data through cloud technology. This integration with Big Data makes collaboration among remote teams and clients seamless.

Microsoft BI Tools: PowerPivot & Interactive Visualizations

This three-day instructor-led, hands-on course is perfect for individuals whose job responsibilities include complex Excel reports and advanced analytics. It covers how to utilize Excel’s Power Query to retrieve data, Power View to create interactive dashboards that teams can leverage, and Power Map to create 3D data visualization charts.
View course outline & dates

Microsoft BI Tools: DAX Formulas for Dynamic Tables

This two-day instructor-led, hands-on course is ideal for Excel power users who are responsible for turning data into powerful reports. Participants will learn how to leverage Data Analysis Expressions (DAX) to extend Excel’s reporting capabilities.
View course outline & dates

Microsoft BI Tools: Get & Transform Data

This one-day instructor-led, hands-on course teaches participants how to maximize Excel’s Power Query technology to transform data. Ideal for data scientists who are non-programmers, this course will teach users how to create automated reports and work with multiple queries.
View course outline & dates

Microsoft BI Tools: Power BI for Excel Users

This two-day instructor-led, hands-on course is one of our most popular Excel BI courses. Ideal for non-IT professionals, participants will learn how to easily create and publish reports using Excel’s Power BI cloud service.
View course outline & dates

Save with an Excel Bundle

Bundles need to be purchased BEFORE registering for any training and must be purchased by phone: 1-800-288-8221 (weekdays).
To view a course outline and upcoming ILT class dates click on the course title. MOS / MOS Expert certification details follow the bundle table or click here.

You will need to specify exam version (2019 or 2016) at the time of Bundle purchase.

Excel Training Bundles
(ILT only)
Instructor-Led Training (ILT)
Excel Introduction (1 day)
Excel Charts, Formatting & Reporting (1 day)
Excel Database Features & Pivot Tables (1 day)
Excel Workbooks, Formulas & Functions (1 day)
On-Demand Training
Excel Comprehensive (Basic, Intermediate & Advanced)
(Intro, Charts, Database & Workbooks titles - specify version)
Hard copy for On-Demand
Retail Total:
Training Bundle:
Optional MOS Certification Add-on (retail value over $200) *
Exam Prep Software & Study Guide
Exam Voucher with Exam Pass Guarantee
Training Bundle with MOS Add-on:

* Certification Add-on not sold separately. Retail value varies with Bundle type. See Bundle Terms & Conditions

Purchase Your Excel Bundle Today!

Bundles are available for purchase via our toll free number. We accept all major credit cards. To purchase contact an ONLC Advisor..


Excel Training Ppt

Excel Certification

Earning a Microsoft Office Specialist (MOS) certification proves to clients and perspective employers that you have the professional skills to work confidently in a specific Office application and can maximize its features to complete tasks. ONLC's classes can help you prep for MOS and MOS Expert certifications.

Earning MOS Excel confirms you have core Excel skills and maximize its features to complete tasks.

Advanced Excel Training Ppt

The below courses are recommended along with hands-on experience with the software to earn MOS certification.

Excel Training Ppt

Recommended Training

  • Excel Workbooks, Formulas & Functions

Certification Exam

MO-200: Excel Associate (Excel 365 / 2019) —OR— 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation
MOS authorized exams are performance-based and available from Certiport. Exam candidates schedule directly with Certiport. When you pass the authorized exam, you will receive a digital badge for that credential. Microsoft changes their exams frequently to maintain integrity, as such, training alone may not cover all skills on the exam.

Earning MOS Expert certification proves you have advanced-level skills and understanding in a specific Office application and can assist others with proper use of the program’s features.

The below courses, which are the same as those for the MOS credential above, can help you get started. You should also have extensive hands-on experience with Excel before attempting the MOS-Expert exam as it goes into much greater depth and breadth than the entry-level MOS exam.

Recommended Training


Certification Exam

MO-201: Excel Expert (Office 365 / 2019) —OR— 77-728: Excel Expert 2016: Interpreting Data for Insights.
MOS Expert authorized exams are performance-based and available from Certiport. Exam candidates schedule directly with Certiport. When you pass the authorized exam, you will receive a digital badge for that credential. Microsoft changes their exams frequently to maintain integrity, as such, training alone may not cover all skills on the exam.

Other Information & Options

Microsoft Excel Versions 365 / 2019 / 2016
These software versions are very similar. The difference is mostly a matter of how you're accessing the software. Microsoft Excel 365 is accessed via the cloud. You pay a monthly subscription to use the software. Since it's not static on your device, you'll get updates to the software when they happen. On the otherhand, 2019 / 2016 and earlier PC versions are purchased outright and installed directly onto your computer (aka 'on-premise'). Excel features and functions are the same no matter which of these versions you're using and as such students with those versions can attend the same classes.

Education Advisors for Assistance
Our advisors can answer questions you may have about our training options as well as Microsoft certification. They can help you determine a training path that is right for your background and your goals. Advisors are available weekdays at our toll free number or via the CHAT feature.

Hundreds of ONLC Training Centers Coast to Coast
We schedule every instructor-led (ILT) class at each of our ONLC Training Centers locations. Our training rooms are outfitted with the equipment needed for training and provide an interruption-free space so you can concentrate fully on learning. See ONLC locations.

Live Excel Classes from Home
You can attend our same live, instructor-led classes from the comfort and convenience of your own home. The setup is really easy and you don't have to have the class software on your device. Follow our easy setup video. If you're still not sure about the setup after contact an ONLC Advisor toll free for assistance.

Save a Bundle!
We have discounted bundles for those who need more than one Excel course. You get to select your preferred class format and can opt for a MOS Certification Add-on—all at a discount. See Excel Bundles

Excel Group Training
ONLC has training solutions specifically for large groups and companies. Options can include hands-on, lecture, eLearning and more. Training can be delivered virtually or in-person at your site. With private training content can be customized to meet a client's specific configurations and technologies. To explore ways we can reduce your training costs and employee downtime while maximizing learning and retention, complete our Group Training Request form so we can provide a price quote.

Train on Multiple Topics in Microsoft Office / Office 365 at a Savings!
Our 5/4 Office Saver gives you 5 training days on programs within Office for the price of 4. Your choice of topics (Excel, Word, PowerPoint and more), plus upgrade options. Find out more

For More Information

To learn more about Microsoft Excel classes and certifications, please contact our Education Advisors at:


Virtual Excel training
AlabamaBirmingham Excel trainingHuntsville Excel training
Mobile Excel trainingMontgomery Excel training
ArkansasBentonville Excel trainingLittle Rock Excel training
ArizonaMesa Excel trainingPhoenix Excel training
Scottsdale Excel trainingTucson Excel training
CaliforniaBakersfield Excel trainingGlendale Excel training
Irvine Excel trainingLos Angeles Excel trainingLos Angeles Excel training
Manhattan Beach Excel trainingOrange Excel trainingPleasanton Excel training
Riverside Excel trainingSacramento Excel trainingSan Diego Excel training
San Diego Excel trainingSan Diego Excel trainingSan Francisco Excel training
San Jose Excel trainingWalnut Creek Excel trainingWoodland Hills Excel training
ColoradoBoulder Excel trainingCentennial Excel training
Colorado Springs Excel trainingDenver Excel trainingFt. Collins Excel training
Grand Junction Excel trainingLakewood Excel trainingLoveland Excel training
ConnecticutCheshire Excel trainingDanbury Excel training
Rocky Hill Excel trainingShelton Excel trainingStamford Excel training
District of ColumbiaWashington Excel training
DelawareWilmington Excel training
FloridaBoca Raton Excel trainingBonita Springs Excel training
Bradenton Excel trainingFort Lauderdale Excel trainingFort Myers Excel training
Fort Walton Beach Excel trainingJacksonville Excel trainingKissimmee Excel training
Lakeland Excel trainingMelbourne Excel trainingMiami Excel training
Miami Excel trainingMiramar Beach Excel trainingOrange Park Excel training
Orlando Excel trainingOrlando Excel trainingPensacola Excel training
Plantation Excel trainingTallahassee Excel trainingTampa Excel training
GeorgiaAlpharetta Excel trainingAtlanta Excel training
Duluth Excel trainingKennesaw Excel trainingMacon Excel training
Martinez Excel trainingSavannah Excel training
IowaBettendorf Excel trainingDes Moines Excel training
IdahoBoise Excel training
IllinoisChicago Excel trainingGurnee Excel training
Joliet Excel trainingOak Brook Excel trainingPeoria Excel training
Schaumburg Excel trainingWarrenville Excel training
IndianaCarmel Excel trainingEvansville Excel training
Fort Wayne Excel trainingGreenwood Excel trainingIndianapolis Excel training
South Bend Excel training
KansasLenexa Excel trainingWichita Excel training
KentuckyFlorence Excel trainingLexington Excel training
Louisville Excel training
LouisianaBaton Rouge Excel trainingLafayette Excel training
New Orleans Excel training
MassachusettsBoston Excel trainingBraintree Excel training
Danvers Excel trainingEast Longmeadow Excel trainingNorth Andover Excel training
Norwell Excel trainingWestborough Excel trainingWoburn Excel training
Worcester Excel training
MarylandAnnapolis Excel trainingBethesda Excel training
Columbia Excel trainingFrederick Excel trainingGermantown Excel training
Greenbelt Excel trainingOwings Mills Excel trainingRockville Excel training
Towson Excel training
MainePortland Excel training
MichiganAnn Arbor Excel trainingGrand Rapids Excel training
Kalamazoo Excel trainingLivonia Excel trainingNovi Excel training
Southfield Excel trainingTroy Excel training
MinnesotaBloomington Excel trainingMaple Grove Excel training
Woodbury Excel training
MissouriColumbia Excel trainingLee's Summit Excel training
O'Fallon Excel trainingSpringfield Excel trainingSt. Louis Excel training
St. Louis Excel training
MississippiRidgeland Excel training
MontanaGreat Falls Excel training
North CarolinaAsheville Excel trainingChapel Hill Excel training
Charlotte Excel trainingCharlotte Excel trainingFayetteville Excel training
Greensboro Excel trainingRaleigh Excel trainingRaleigh Excel training
Wilmington Excel training
North DakotaFargo Excel trainingGrand Forks Excel training
NebraskaOmaha Excel training
New HampshireBedford Excel trainingConcord Excel training
Portsmouth Excel training
New JerseyBridgewater Excel trainingMahwah Excel training
Morristown Excel trainingMount Laurel Excel trainingParamus Excel training
Princeton Excel trainingRed Bank Excel training
New MexicoAlbuquerque Excel training
NevadaLas Vegas Excel trainingReno Excel training
New YorkAlbany Excel trainingBohemia Excel training
Brooklyn Excel trainingBuffalo Excel trainingLiverpool Excel training
Mt. Kisco Excel trainingNew York Excel trainingRochester Excel training
Uniondale Excel training
OhioBeachwood Excel trainingBeavercreek Excel training
Cincinnati Excel trainingCincinnati Excel trainingCleveland Excel training
Columbus Excel trainingColumbus Excel trainingDublin Excel training
Independence Excel trainingToledo Excel trainingWestlake Excel training
OklahomaOklahoma City Excel trainingTulsa Excel training
OregonPortland Excel trainingSalem Excel training
PennsylvaniaAllentown Excel trainingConshohocken Excel training
Erie Excel trainingHuntingdon Valley Excel trainingLancaster Excel training
Malvern Excel trainingMechanicsburg Excel trainingPhiladelphia Excel training
Pittsburgh Excel trainingPittsburgh Excel trainingSouth York Excel training
State College Excel trainingWexford Excel training
Rhode IslandWest Warwick Excel training
South CarolinaColumbia Excel trainingGreenville Excel training
Mt. Pleasant Excel trainingNorth Charleston Excel training
TennesseeKnoxville Excel trainingMemphis Excel training
Murfreesboro Excel trainingNashville Excel training
TexasAllen Excel trainingAmarillo Excel training
Austin Excel trainingAustin Excel trainingBryan Excel training
Dallas Excel trainingDallas Excel trainingDenton Excel training
El Paso Excel trainingFort Worth Excel trainingHouston Excel training
Irving Excel trainingKaty Excel trainingKeller Excel training
Plano Excel trainingSan Antonio Excel trainingSan Antonio Excel training
Southlake Excel trainingSugar Land Excel trainingThe Woodlands Excel training
UtahProvo Excel trainingSalt Lake City Excel training
VirginiaAlexandria Excel trainingArlington Excel training
Charlottesville Excel trainingFairfax Excel trainingForest Excel training
Fredericksburg Excel trainingGlen Allen Excel trainingHerndon Excel training
Manassas Excel trainingMcLean Excel trainingNorfolk Excel training
Reston Excel trainingRichmond Excel trainingRoanoke Excel training
Stafford Excel trainingVirginia Beach Excel training
WashingtonBellevue Excel trainingBothell Excel training
Federal Way Excel trainingLacey Excel trainingPuyallup Excel training
Seattle Excel training
WisconsinBrookfield Excel trainingGreen Bay Excel training
Madison Excel training
West VirginiaMartinsburg Excel training
WyomingCasper Excel trainingCheyenne Excel training