Excel Business Workshop

Workshop
| |

Tickets Closed. To check more events click here

Description

We , Bookitnow.pk , are a team to provide you with your One Stop Entertainment Solution - With the passion of giving the best , deriving innovation for your ease , inculcating the new trends to let you stay connected with everything happening around.

Business Excel workshop
will train you From Basic to Advanced Excel.

Level 1 - Basic 
▀▀▀▀▀▀▀▀
1- Make preface for all tools in Excel 
2- Make a lot of tables
3- Make analysis data formatting
4- Use Data validation
5- Use Conditional format
6- Make Password
7- Make protection
8- Use Hyperlink
9- Find and filter
10- How to print

Level 2 - Advanced 
▀▀▀▀▀▀▀▀▀▀
• Chapter 1:
- Creating Full Data Base.

• Chapter 2:
- Make Analysis for Data by
(custom Filter – Hyperlink – co-national
formatting – Data validation – text to columns- move or copy for Sheet).

• Chapter 3:
- Make Analysis by Pivot table
- Summarizing data using Pivot Tables

• Chapter 4:
- Use Formulas
(sum ifs – count ifs -sum if – count if – sum –count- H lookup – lookup – subtotals – substitute - V lookup – sum product -if –and - if and – if error – Abs –trim – proper –upper –lower –m round )

 


Tags

Questions or Comments

Invite your Friends to this Event

You May Like it

Signup for Newsletter

Signup for the latest news about Movies & Events and exclusive offers.

Don't worry, we won't spam you. You will be able to unsubscribe with a single mouse click.
Subscribe for Our Whatsapp Updates

Which update you want to receive?