Скачать или смотреть Sort Data in meaningful order alphabetically (Based on values, cell color, font color & Icon)

MICROSOFT EXCEL LEARNING

In this video you will learn about how to Sort data in Excel.

Sort data alphabetically A to Z order & Z to A order
Multiple levels of data Sorting, Copy levels and delete levels
Sort data on the basis of Values
Sort data on the basis of cell color
Sort data on the basis of Font color
Sort data on the basis of Icon

ONLINE EXCEL TRAINING PROGRAM:-

We are conduction online session / Classes via Zoom Cloud Meeting Application

Excel Workbooks provided to participants at the end to each session for home practice via Whats App or Email

EXCEL COURSE TRAINING LEVEL:
1- Basic Intermediate
2- Intermediate Level
3- Advanced Level

TIMING & SESSIONS:
Training Sessions: 5 Session (For Each Level)
Session Duration: 60 to 90 Minutes (For Each Level)
Total Duration: Estimated 10 Hours (For Each Level)
Timings: 8:00 PM to 11:00 PM (Weekdays) & 1:00 PM to 11:00 PM (Weekend)

EXCEL TRAINING PROGRAM: -
Complete Training program having 15 Sessions and Total 30 Exercises

SESSION NO: 01
Exercise No 1:- Introduction to Spreadsheet » User interface of Microsoft Excel
Exercise No 2:- Format Cell » Font Color, Alignment , Border Style, Custom Formatting
Exercise No 3:- Data Consolidation » Consolidate multiple sheets with data linking

SESSION NO: 02
Exercise No 4:- Data Sorting » Group or UnGroup data » Subtotal option
Exercise No 5:- Count Function -Count, Countif, Countifs, CountA, Countblank
Exercise No 6:- Auto Format & Paste Special

SESSION NO: 03
Exercise No 7:- Date, Time, Month & Year Function » with Addition & Subtraction options
Exercise No 8:- Page Setup » Margin, Orientation and Size of Page
Exercise No 9:- Fill Function » Fill Data by Series & Across Sheet

SESSION NO: 04
Exercise No 10:- Data Validation » Prevent invalid data from being entered in to a cell
Exercise No 11:- Logical Test » Using of IF, AND & OR Function with multiple condition

SESSION NO: 05
Exercise No 12:- Index & Match Function » Combine Index function with Match Function
Exercise No 13:- Choose Function » Combine Choose function with different formulas

SESSION NO: 06
Exercise No 14:- Filter Options » Normal & Advance Filter
Exercise No 15:- Macro » Record & View
Exercise No 16:- Text to Column » Delimited option » Fixed width

SESSION NO: 07
Exercise No 17:- Conditional Formatting » Custom Conditional formatting by formulas

SESSION NO: 08
Exercise No 18:- Uses & benefits of Table
Exercise No 19:- Sumif, Sumifs & Sumproduct Function

SESSION NO: 09
Exercise No 20:- Vlookup & Hlookup » VLookup with choose & sum functions

SESSION NO: 10
Exercise No 21:- Protection » Worksheet cell, formula and file protection
Exercise No 22:- Find & Select » Go To & Go To Special

SESSION NO: 11
Exercise No 23:- Database Function » Review DSUM, DAVERGE, DCOUNT, DMAX, DMIN
Exercise No 24:- Offset Function » Set dynamic range of calculation through offset

SESSION NO: 12
Exercise No 25:- Indirect Function » Dynamic Calculation by using indirect Function
Exercise No 26:- Hyperlink Function » Uses & benefit of Hyperlink Function

SESSION NO: 13
Exercise No 27:- Graphical Presentation of Data » Creating charts & Sparklines
Exercise No 28:- Smart Arts » Kind of Smart Arts i.e. List, Process, relationship

SESSION NO: 14
Exercise No 29:- What if Analysis » Set Scenario, Goal Seek, Forecasting by data table
Exercise No 30:- Pivot Table & Chart » Grouping data in pivot tables » Insert slicer

SESSION NO: 15
Excel Dash Board Reporting: Prepare Dashboard Report though Pivot Table & Formulas
» Uses of Control form with Advance Excel Formulas » Learn how to make interactive Dashboard

COURSE BENEFITS:
• To gain a solid understanding of the more powerful features and functions in Excel
• To be able to use Microsoft Excel in a commercial environment
• With the basic advance excel skills, you save a good amount of time and increase your productivity
• Able to create Excel Dash board reporting from Complicated large number of data. Which make you distinguish
• Excel will make you better at your job (No Matter what that is)

Complete Course Outline Link:-
  / 159855522433065  

If you are interested for free demo session, Kindly send whats app message on +92 312 2011901. We will send you Zoom ID and Password for join free demo session on Zoom

Please let me know if you have any query regarding this online Excel Microsoft Excel Training program.
Thanks

Best Regards

Muhammad Faisal
Course Facilitator
Whats app No: +92 312 2011901
Instagram ID: mfaisal.advanceexcel
Email ID: [email protected]
Fagebook Page:   / advance-excel-training-course-104450