Microsoft Excel 365 Training - Beginner to Advanced Level
Microsoft Excel 365 Training - Beginner to Advanced Level

Microsoft Excel 365 Training - Beginner to Advanced Level

₹ 499
Desbloqueie e acesse
  • 1 mês de Skillshare

    Disponível com a compra
    Grátis

A compra será feita por meio da Superpeer, parte da família Skillshare.

Todas as assinaturas serão cobradas automaticamente de forma recorrente até serem canceladas. Se estiver qualificado para um teste gratuito, cancele antes que o teste termine para evitar cobranças. Oferta válida apenas para novos assinantes pagos. Veja os termos de serviço completos aqui.

Sobre este produto

Himanshu Dhar

Himanshu Dhar

MIS Trainer

Unlock Your Full Excel Potential: Excel 365 - From Beginner to Advanced
Are you ready to excel in Excel, even if you've never touched it before?
Discover the Power of Microsoft Excel 365!

In today's data-driven world, Excel isn't just a tool – it's the ultimate key to success. But we get it – you're short on time and don't have any prior experience. That's where we come in.

Our comprehensive course, "Excel 365 - From Beginner to Advanced", is designed especially for you. Starting from the ground up, we'll guide you through 11 hours and 30 minutes of expert-led training that will transform you into a Microsoft Excel master.

Why This Excel Course is Your Game-Changer:
1. Career Opportunities: Excel mastery opens doors in every field.
2. Rapid Advancement: Excel experts climb the corporate ladder effortlessly.
3.Future-Proof Skills: Your Excel proficiency means job security in any economic climate.

What Sets Us Apart?
• High-Quality Production: Crystal-clear HD video and top-notch sound.
• Experienced Instructor: With over 19000 students and 14+ years in the industry.
• Downloadable Resources: Handouts, Excel files, and more at your fingertips.
• Practical Examples: Reinforce your learning with real-world scenarios.
• Exceptional Support: Prompt answers to your questions and feedback.
• Dynamic Learning: No time-wasting – we maintain an engaging pace.
• Comprehensive Coverage: We leave no Excel stone unturned.
• Latest Version: Tailored for Office 365, but applicable to any Excel version.

Who Benefits Most:
• University students seeking an edge in their studies.
• Entry-level finance, business, and marketing professionals eager to outshine their peers.

Our Promise to You:
Ready to embark on this transformational journey? Buy the course today and unlock the full potential of Excel 365. Don't miss out – seize this opportunity to enhance your skills, advance your career, and secure your future!

Course Content:
1 Excel Intro - New File and Title Bar
2 Customize Ribbons and Quick Access Toolbar
3 Excel Structure and Worksheets
4 Data Entry and Formatting
5 Fill Series in Excel
5.2 Flash Fill in Excel
5.3 Cell Reference in Excel
6 Math Operators in Excel
7 Math Function in Excel
8 Advance Math Function in Excel
9 Database Math Function
10 IF Function in Excel
11 Nested IF in Excel
12 If Function Task Solution
13 IF Function Task
14 IF Task Solution
15 IFS in Excel
16 AND and OR Function
16.2 XOR Function
17 Filter in Excel
17.2 Date and Color Filter
18 Advanced Filter Option
19 Sort and Custom Sort
20 Upper, Lower, Proper and Trim Function
21 Left, Right and Find Function
21.2 Find Related Task Solution
22 Left, Right and Find Function Nesting
23 MID Function
24 Concatenate Function
25 Concatenate Function Solution
26 Concat and Textjoin Function
27 Replace Function
28 Replace Function Solution
29 Substitute Function
30 Rept, Len and Task
31 Task Solution - Substitute and Len Nesting
32 Numbervalue Function in Excel
33 Text to Column Option
34 Conditional Formatting - How to Apply
35 Types of Rules in Conditional Formatting
36 Manage Rules in Conditional Formatting
37 Chart Preperation in Excel Part 1
37.2 Designing and Format Chart
38 Chart Customization part1
39 Chart Customization part2
40 Pie Chart in Excel
41 Quick Analysis and Chart Recommendation
42 Power Map in Excel
43 Pivot Table 365
44 Power Pivot in Excel
45 Pduration Function in Excel
46 PMT Function - EMI Calculator
47 Data Table in Excel
48 Goal Seek in Excel
49 solver in excel
50 Scenerio Manager in Excel
51 Define Name Feature in Excel
52 Hyperlink in Excel
53 Group and Subtotal in Excel
53.2 Draw Tab in Excel
54 Print Options in Excel part 1
55 Print Options in Excel part 2
56 Protect Workbook in Excel
57 Protect sheet in Excel
58 Hide Formula and Unlocked Cell
59 Protect Excel File with Password
60 Date and Time Setting
61 Date and Time format in Excel
62 Date and Time Functions
63 Networkdays Function
64 Datedif Function
65 Vlookup Function
66 Iferror Function with Vlookup
67 Array Vlookup Function
68 Hlookup Function in Excel
69 Match and Index Function
70 Match and Index Nesting
71 Vlookup TRUE
72 Lookup and Reference Function Trick
73 Xlookup Function
74 Macro Recording in Excel
75 Macro Recording Example in Excel
76 Ways to Run Macros in Excel
77 Practice Files - 21

Perguntas frequentes

  • O que são produtos digitais?

    Os produtos digitais da Skillshare são ferramentas, recursos e modelos criados por especialistas que estão disponíveis para compra. Com uma ampla gama de recursos para atender a todas as necessidades criativas, eles são acionáveis, tornando sua experiência de aprendizado real e inesquecível.