Excel Advanced

Tila

Ei aloitettu

Ohje

Suljettu

Aloita kurssi

This kurssi is currently closed

Kurssin sisältö

Laajenna kaikki

1 Process Information 7 Aiheet

Laajenna

Moduulin sisältö

0 % suoritettu 0/7 Steps

02 Format Cells with Custom Formats

03 Paste Data in Any Fromat

04 Switch Rows to Columns

05 Calculate With Paste

06 Import text Data To Excel

07 Split Data From Single to Multiple Columns

2 View Data 4 Aiheet

Laajenna

Moduulin sisältö

0 % suoritettu 0/4 Steps

01 Freeze Headings

02 Hide Restore Rows and Columns

03 Hide restore Tables

3 Protecting Worksheets 4 Aiheet

Laajenna

Moduulin sisältö

0 % suoritettu 0/4 Steps

01 Protect with Password

02 Password to Prevent Editing

03 Marks as Final

04 Limit Changes to Specific Cells

4 Editing Data 6 Aiheet

Laajenna

Moduulin sisältö

0 % suoritettu 0/6 Steps

01 Advanced Sort

02 Advanced Filtering

03 Filtering With Slicers

05 Collecting Data Using 3D References

06 Excel Templates

5 Advanced Visualizations 8 Aiheet

Laajenna

Moduulin sisältö

0 % suoritettu 0/8 Steps

01 Creating Chart

02 Viewing 3D Charts From Different Angles

03 Horizontal Vertical Axis

04 Manually Place Chart Elements

05 Split Chart Segments

06 Add Remove Data From Chart

07 Combine Multiple Chart Types

08 Images In charts

6 Advanced Functions 16 Aiheet

Laajenna

Moduulin sisältö

0 % suoritettu 0/16 Steps

01 Time Related Functions

03 Count Empty or Full Cells

04 Conditional Calculations

05 Text Functions

06 Combine Cells With Functions

07 Functions Inside Other Functions

08 Searching With VLOOKUP

09 More Advanced Search Using Two Functions

10 IF Functions

11 Error Messages with IFERROR

12 Conditional Calculation Using Database Functions

13 Loan Payments Using PMT

14 Calculating Future Value With FV

15 Investment Rates with RATE

16 Calculate Investment Values With NPV

7 Pivot Tables 6 Aiheet

Laajenna

Moduulin sisältö

0 % suoritettu 0/6 Steps

01 Create Pivot Table

02 Updating Pivot

04 Filter with Slicer Timelines

05 Easier Updating For Pivot Tables

06 Common Problems With Pivot

8 Analyze Work Together 5 Aiheet

Laajenna

Moduulin sisältö

0 % suoritettu 0/5 Steps

02 Tracing Precedents and Dependents

03 Show Hide Formulas

04 Track Changes

9 Automate With Macros 5 Aiheet

Laajenna

Moduulin sisältö

0 % suoritettu 0/5 Steps

01 Introducing Macros

02 Recording a Macro

03 Running a Recorded Macro

04 Show a Macro In Quick Actions

05 Deleting Macros

Ab Has

Vastaa Peruuta vastaus

Sinun täytyy kirjautua sisään kommentoidaksesi.